PREVIEW / etf_5min / 2004-03-31
file: by_date/etf_5min/2004/2004-03-31.parquet size: 90 KB rows: 4,776
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-31 08:00:00 | SPY | ETF | 113.19 | 113.2 | 113.19 | 113.2 | 400.0 |
| 2004-03-31 08:05:00 | SPY | ETF | 113.21 | 113.24 | 113.21 | 113.24 | 6300.0 |
| 2004-03-31 08:10:00 | SPY | ETF | 113.23 | 113.23 | 113.23 | 113.23 | 100.0 |
| 2004-03-31 08:15:00 | SPY | ETF | 113.2 | 113.21 | 113.19 | 113.19 | 9400.0 |
| 2004-03-31 08:20:00 | SPY | ETF | 113.2 | 113.2 | 113.2 | 113.2 | 3900.0 |
| 2004-03-31 08:30:00 | SPY | ETF | 113.15 | 113.15 | 113.12 | 113.12 | 7000.0 |
| 2004-03-31 08:35:00 | SPY | ETF | 113.1 | 113.1 | 113.09 | 113.09 | 5200.0 |
| 2004-03-31 08:40:00 | SPY | ETF | 113.13 | 113.17 | 113.13 | 113.17 | 6600.0 |
| 2004-03-31 08:50:00 | SPY | ETF | 113.13 | 113.13 | 113.13 | 113.13 | 500.0 |
| 2004-03-31 08:55:00 | SPY | ETF | 113.1 | 113.17 | 113.1 | 113.17 | 3400.0 |
| 2004-03-31 09:00:00 | SPY | ETF | 113.15 | 113.17 | 113.13 | 113.13 | 31500.0 |
| 2004-03-31 09:05:00 | SPY | ETF | 113.1 | 113.12 | 113.07 | 113.07 | 4500.0 |
| 2004-03-31 09:10:00 | SPY | ETF | 113.08 | 113.08 | 113.0 | 113.02 | 7400.0 |
| 2004-03-31 09:15:00 | SPY | ETF | 113.02 | 113.03 | 112.99 | 113.0 | 2700.0 |
| 2004-03-31 09:20:00 | SPY | ETF | 113.01 | 113.01 | 113.0 | 113.0 | 1700.0 |
| 2004-03-31 09:25:00 | SPY | ETF | 113.0 | 113.05 | 112.97 | 112.97 | 14400.0 |
| 2004-03-31 09:30:00 | SPY | ETF | 112.99 | 113.02 | 112.81 | 112.92 | 767300.0 |
| 2004-03-31 09:35:00 | SPY | ETF | 112.88 | 112.97 | 112.84 | 112.85 | 354900.0 |
| 2004-03-31 09:40:00 | SPY | ETF | 112.88 | 112.89 | 112.64 | 112.75 | 2321100.0 |
| 2004-03-31 09:45:00 | SPY | ETF | 112.77 | 112.82 | 112.66 | 112.82 | 2287500.0 |
| 2004-03-31 09:50:00 | SPY | ETF | 112.83 | 112.95 | 112.79 | 112.92 | 1016400.0 |
| 2004-03-31 09:55:00 | SPY | ETF | 112.89 | 112.91 | 112.77 | 112.9 | 472500.0 |
| 2004-03-31 10:00:00 | SPY | ETF | 112.87 | 112.89 | 112.42 | 112.57 | 2523800.0 |
| 2004-03-31 10:05:00 | SPY | ETF | 112.56 | 112.6 | 112.38 | 112.41 | 1135900.0 |
| 2004-03-31 10:10:00 | SPY | ETF | 112.47 | 112.54 | 112.41 | 112.46 | 972100.0 |
| 2004-03-31 10:15:00 | SPY | ETF | 112.47 | 112.61 | 112.43 | 112.59 | 669000.0 |
| 2004-03-31 10:20:00 | SPY | ETF | 112.59 | 112.62 | 112.55 | 112.61 | 1030700.0 |
| 2004-03-31 10:25:00 | SPY | ETF | 112.59 | 112.61 | 112.46 | 112.48 | 384900.0 |
| 2004-03-31 10:30:00 | SPY | ETF | 112.5 | 112.64 | 112.47 | 112.63 | 214900.0 |
| 2004-03-31 10:35:00 | SPY | ETF | 112.63 | 112.67 | 112.57 | 112.58 | 378700.0 |
| 2004-03-31 10:40:00 | SPY | ETF | 112.61 | 112.77 | 112.55 | 112.77 | 690800.0 |
| 2004-03-31 10:45:00 | SPY | ETF | 112.69 | 112.77 | 112.68 | 112.68 | 714300.0 |
| 2004-03-31 10:50:00 | SPY | ETF | 112.69 | 112.7 | 112.62 | 112.66 | 260500.0 |
| 2004-03-31 10:55:00 | SPY | ETF | 112.65 | 112.78 | 112.65 | 112.74 | 225000.0 |
| 2004-03-31 11:00:00 | SPY | ETF | 112.74 | 112.79 | 112.73 | 112.75 | 693400.0 |
| 2004-03-31 11:05:00 | SPY | ETF | 112.75 | 112.78 | 112.67 | 112.69 | 249400.0 |
| 2004-03-31 11:10:00 | SPY | ETF | 112.69 | 112.82 | 112.68 | 112.8 | 223600.0 |
| 2004-03-31 11:15:00 | SPY | ETF | 112.8 | 112.89 | 112.77 | 112.86 | 188600.0 |
| 2004-03-31 11:20:00 | SPY | ETF | 112.86 | 112.87 | 112.8 | 112.86 | 344900.0 |
| 2004-03-31 11:25:00 | SPY | ETF | 112.85 | 112.88 | 112.794 | 112.84 | 616600.0 |
| 2004-03-31 11:30:00 | SPY | ETF | 112.83 | 112.85 | 112.76 | 112.78 | 211300.0 |
| 2004-03-31 11:35:00 | SPY | ETF | 112.78 | 112.82 | 112.72 | 112.75 | 277100.0 |
| 2004-03-31 11:40:00 | SPY | ETF | 112.75 | 112.76 | 112.64 | 112.65 | 249900.0 |
| 2004-03-31 11:45:00 | SPY | ETF | 112.67 | 112.72 | 112.64 | 112.7 | 345100.0 |
| 2004-03-31 11:50:00 | SPY | ETF | 112.7 | 112.76 | 112.7 | 112.74 | 84300.0 |
| 2004-03-31 11:55:00 | SPY | ETF | 112.74 | 112.79 | 112.7 | 112.74 | 779000.0 |
| 2004-03-31 12:00:00 | SPY | ETF | 112.74 | 112.78 | 112.69 | 112.75 | 121000.0 |
| 2004-03-31 12:05:00 | SPY | ETF | 112.75 | 112.86 | 112.74 | 112.82 | 243700.0 |
| 2004-03-31 12:10:00 | SPY | ETF | 112.82 | 112.82 | 112.74 | 112.8 | 265100.0 |
| 2004-03-31 12:15:00 | SPY | ETF | 112.8 | 112.99 | 112.77 | 112.99 | 321000.0 |
> showing 50 of 4,776 rows — these rows as CSV