PREVIEW / etf_5min / 2008-11-11
file: by_date/etf_5min/2008/2008-11-11.parquet size: 528 KB rows: 24,632
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2008-11-11 04:15:00 | SPY | ETF | 92.04 | 92.04 | 92.04 | 92.04 | 200.0 |
| 2008-11-11 04:25:00 | SPY | ETF | 91.8 | 91.8 | 91.8 | 91.8 | 200.0 |
| 2008-11-11 04:40:00 | SPY | ETF | 91.81 | 92.1 | 91.81 | 92.1 | 5700.0 |
| 2008-11-11 04:45:00 | SPY | ETF | 92.13 | 92.13 | 92.0 | 92.0 | 6100.0 |
| 2008-11-11 04:50:00 | SPY | ETF | 91.82 | 91.84 | 91.7 | 91.7 | 6500.0 |
| 2008-11-11 04:55:00 | SPY | ETF | 91.65 | 91.65 | 91.6 | 91.6 | 1900.0 |
| 2008-11-11 05:00:00 | SPY | ETF | 91.73 | 91.73 | 91.43 | 91.43 | 800.0 |
| 2008-11-11 05:05:00 | SPY | ETF | 91.56 | 91.56 | 91.3 | 91.3 | 1800.0 |
| 2008-11-11 05:10:00 | SPY | ETF | 91.34 | 91.5 | 91.34 | 91.5 | 1200.0 |
| 2008-11-11 05:20:00 | SPY | ETF | 91.56 | 91.6 | 91.56 | 91.6 | 1400.0 |
| 2008-11-11 05:25:00 | SPY | ETF | 91.7 | 91.7 | 91.7 | 91.7 | 400.0 |
| 2008-11-11 05:35:00 | SPY | ETF | 91.5 | 91.5 | 91.5 | 91.5 | 200.0 |
| 2008-11-11 05:45:00 | SPY | ETF | 91.7 | 91.7 | 91.7 | 91.7 | 200.0 |
| 2008-11-11 05:50:00 | SPY | ETF | 91.8 | 91.8 | 91.8 | 91.8 | 200.0 |
| 2008-11-11 06:10:00 | SPY | ETF | 91.71 | 91.71 | 91.71 | 91.71 | 100.0 |
| 2008-11-11 06:15:00 | SPY | ETF | 91.7 | 91.7 | 91.7 | 91.7 | 7500.0 |
| 2008-11-11 06:20:00 | SPY | ETF | 91.63 | 91.63 | 91.63 | 91.63 | 100.0 |
| 2008-11-11 06:25:00 | SPY | ETF | 91.6 | 91.6 | 91.6 | 91.6 | 100.0 |
| 2008-11-11 06:30:00 | SPY | ETF | 91.62 | 91.62 | 91.62 | 91.62 | 1000.0 |
| 2008-11-11 06:35:00 | SPY | ETF | 91.51 | 91.51 | 91.4 | 91.4 | 1100.0 |
| 2008-11-11 06:40:00 | SPY | ETF | 91.37 | 91.37 | 91.37 | 91.37 | 1000.0 |
| 2008-11-11 06:45:00 | SPY | ETF | 91.4 | 91.4 | 91.4 | 91.4 | 500.0 |
| 2008-11-11 06:50:00 | SPY | ETF | 91.43 | 91.43 | 91.43 | 91.43 | 1000.0 |
| 2008-11-11 06:55:00 | SPY | ETF | 91.3 | 91.3 | 91.24 | 91.26 | 15340.0 |
| 2008-11-11 07:00:00 | SPY | ETF | 91.34 | 91.39 | 91.24 | 91.35 | 69269.0 |
| 2008-11-11 07:05:00 | SPY | ETF | 91.38 | 91.38 | 91.11 | 91.18 | 10145.0 |
| 2008-11-11 07:10:00 | SPY | ETF | 91.12 | 91.12 | 91.0 | 91.11 | 39959.0 |
| 2008-11-11 07:15:00 | SPY | ETF | 91.12 | 91.13 | 90.73 | 90.75 | 126590.0 |
| 2008-11-11 07:20:00 | SPY | ETF | 90.75 | 90.79 | 90.5 | 90.5 | 104987.0 |
| 2008-11-11 07:25:00 | SPY | ETF | 90.51 | 90.7 | 90.48 | 90.68 | 122530.0 |
| 2008-11-11 07:30:00 | SPY | ETF | 90.67 | 90.71 | 90.53 | 90.61 | 133555.0 |
| 2008-11-11 07:35:00 | SPY | ETF | 90.63 | 90.83 | 90.58 | 90.71 | 69842.0 |
| 2008-11-11 07:40:00 | SPY | ETF | 90.81 | 91.01 | 90.81 | 90.95 | 76736.0 |
| 2008-11-11 07:45:00 | SPY | ETF | 90.95 | 90.96 | 90.76 | 90.77 | 23232.0 |
| 2008-11-11 07:50:00 | SPY | ETF | 90.78 | 91.07 | 90.76 | 90.99 | 133850.0 |
| 2008-11-11 07:55:00 | SPY | ETF | 90.99 | 91.08 | 90.91 | 90.94 | 168938.0 |
| 2008-11-11 08:00:00 | SPY | ETF | 90.94 | 91.19 | 90.55 | 91.01 | 396062.0 |
| 2008-11-11 08:05:00 | SPY | ETF | 91.0 | 91.03 | 90.75 | 90.89 | 457429.0 |
| 2008-11-11 08:10:00 | SPY | ETF | 90.91 | 90.97 | 90.85 | 90.97 | 73370.0 |
| 2008-11-11 08:15:00 | SPY | ETF | 90.97 | 91.02 | 90.85 | 90.87 | 36511.0 |
| 2008-11-11 08:20:00 | SPY | ETF | 90.88 | 92.63 | 90.78 | 90.82 | 55317.0 |
| 2008-11-11 08:25:00 | SPY | ETF | 90.82 | 90.9 | 90.67 | 90.67 | 147945.0 |
| 2008-11-11 08:30:00 | SPY | ETF | 90.67 | 90.77 | 90.64 | 90.74 | 150006.0 |
| 2008-11-11 08:35:00 | SPY | ETF | 90.76 | 90.8 | 90.72 | 90.72 | 69266.0 |
| 2008-11-11 08:40:00 | SPY | ETF | 90.71 | 91.04 | 90.7 | 91.03 | 202935.0 |
| 2008-11-11 08:45:00 | SPY | ETF | 91.04 | 91.12 | 90.96 | 91.04 | 282822.0 |
| 2008-11-11 08:50:00 | SPY | ETF | 91.02 | 91.1 | 90.94 | 90.95 | 158443.0 |
| 2008-11-11 08:55:00 | SPY | ETF | 90.95 | 90.95 | 90.86 | 90.87 | 296507.0 |
| 2008-11-11 09:00:00 | SPY | ETF | 90.89 | 91.08 | 90.89 | 91.03 | 133461.0 |
| 2008-11-11 09:05:00 | SPY | ETF | 91.02 | 91.03 | 90.97 | 91.03 | 73698.0 |
> showing 50 of 24,632 rows — these rows as CSV