PREVIEW / etf_5min / 2004-08-19
file: by_date/etf_5min/2004/2004-08-19.parquet size: 83 KB rows: 4,250
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-08-19 08:00:00 | SPY | ETF | 109.7 | 109.7 | 109.65 | 109.7 | 34900.0 |
| 2004-08-19 08:15:00 | SPY | ETF | 109.78 | 109.78 | 109.78 | 109.78 | 60000.0 |
| 2004-08-19 08:20:00 | SPY | ETF | 109.81 | 109.81 | 109.77 | 109.77 | 3200.0 |
| 2004-08-19 08:30:00 | SPY | ETF | 109.81 | 109.81 | 109.77 | 109.77 | 18900.0 |
| 2004-08-19 08:35:00 | SPY | ETF | 109.75 | 109.79 | 109.75 | 109.79 | 15400.0 |
| 2004-08-19 08:40:00 | SPY | ETF | 109.79 | 109.8 | 109.76 | 109.77 | 20000.0 |
| 2004-08-19 08:45:00 | SPY | ETF | 109.77 | 109.78 | 109.74 | 109.74 | 281800.0 |
| 2004-08-19 08:50:00 | SPY | ETF | 109.75 | 109.75 | 109.73 | 109.73 | 3600.0 |
| 2004-08-19 08:55:00 | SPY | ETF | 109.76 | 109.85 | 109.76 | 109.84 | 38400.0 |
| 2004-08-19 09:00:00 | SPY | ETF | 109.8 | 109.8 | 109.8 | 109.8 | 300.0 |
| 2004-08-19 09:05:00 | SPY | ETF | 109.8 | 109.84 | 109.8 | 109.84 | 40100.0 |
| 2004-08-19 09:25:00 | SPY | ETF | 109.83 | 109.85 | 109.83 | 109.83 | 11300.0 |
| 2004-08-19 09:30:00 | SPY | ETF | 109.81 | 109.86 | 109.64 | 109.73 | 772200.0 |
| 2004-08-19 09:35:00 | SPY | ETF | 109.74 | 109.79 | 109.7 | 109.76 | 494400.0 |
| 2004-08-19 09:40:00 | SPY | ETF | 109.8 | 109.89 | 109.73 | 109.88 | 644600.0 |
| 2004-08-19 09:45:00 | SPY | ETF | 109.88 | 109.93 | 109.82 | 109.85 | 540800.0 |
| 2004-08-19 09:50:00 | SPY | ETF | 109.86 | 109.98 | 109.85 | 109.95 | 623500.0 |
| 2004-08-19 09:55:00 | SPY | ETF | 109.95 | 110.02 | 109.91 | 110.0 | 548900.0 |
| 2004-08-19 10:00:00 | SPY | ETF | 110.01 | 110.01 | 109.84 | 109.86 | 442200.0 |
| 2004-08-19 10:05:00 | SPY | ETF | 109.86 | 109.87 | 109.76 | 109.83 | 623600.0 |
| 2004-08-19 10:10:00 | SPY | ETF | 109.83 | 109.88 | 109.75 | 109.84 | 318200.0 |
| 2004-08-19 10:15:00 | SPY | ETF | 109.84 | 109.91 | 109.76 | 109.78 | 368600.0 |
| 2004-08-19 10:20:00 | SPY | ETF | 109.77 | 109.81 | 109.68 | 109.69 | 567800.0 |
| 2004-08-19 10:25:00 | SPY | ETF | 109.69 | 109.71 | 109.57 | 109.57 | 1693600.0 |
| 2004-08-19 10:30:00 | SPY | ETF | 109.56 | 109.68 | 109.55 | 109.65 | 1100400.0 |
| 2004-08-19 10:35:00 | SPY | ETF | 109.64 | 109.7 | 109.48 | 109.57 | 938800.0 |
| 2004-08-19 10:40:00 | SPY | ETF | 109.57 | 109.59 | 109.51 | 109.58 | 495800.0 |
| 2004-08-19 10:45:00 | SPY | ETF | 109.57 | 109.65 | 109.57 | 109.59 | 437500.0 |
| 2004-08-19 10:50:00 | SPY | ETF | 109.62 | 109.65 | 109.54 | 109.57 | 518600.0 |
| 2004-08-19 10:55:00 | SPY | ETF | 109.57 | 109.71 | 109.56 | 109.65 | 281500.0 |
| 2004-08-19 11:00:00 | SPY | ETF | 109.64 | 109.71 | 109.62 | 109.71 | 141400.0 |
| 2004-08-19 11:05:00 | SPY | ETF | 109.7 | 109.71 | 109.61 | 109.69 | 463100.0 |
| 2004-08-19 11:10:00 | SPY | ETF | 109.69 | 109.79 | 109.68 | 109.77 | 279400.0 |
| 2004-08-19 11:15:00 | SPY | ETF | 109.77 | 109.82 | 109.73 | 109.79 | 476600.0 |
| 2004-08-19 11:20:00 | SPY | ETF | 109.78 | 109.81 | 109.74 | 109.77 | 303900.0 |
| 2004-08-19 11:25:00 | SPY | ETF | 109.79 | 109.89 | 109.75 | 109.89 | 421200.0 |
| 2004-08-19 11:30:00 | SPY | ETF | 109.89 | 109.92 | 109.82 | 109.85 | 731000.0 |
| 2004-08-19 11:35:00 | SPY | ETF | 109.87 | 109.87 | 109.77 | 109.8 | 200400.0 |
| 2004-08-19 11:40:00 | SPY | ETF | 109.79 | 109.85 | 109.79 | 109.8 | 95700.0 |
| 2004-08-19 11:45:00 | SPY | ETF | 109.8 | 109.92 | 109.79 | 109.85 | 184300.0 |
| 2004-08-19 11:50:00 | SPY | ETF | 109.84 | 109.88 | 109.81 | 109.86 | 63300.0 |
| 2004-08-19 11:55:00 | SPY | ETF | 109.86 | 109.89 | 109.71 | 109.84 | 367100.0 |
| 2004-08-19 12:00:00 | SPY | ETF | 109.84 | 109.89 | 109.72 | 109.832 | 280300.0 |
| 2004-08-19 12:05:00 | SPY | ETF | 109.83 | 109.83 | 109.76 | 109.78 | 217100.0 |
| 2004-08-19 12:10:00 | SPY | ETF | 109.79 | 109.89 | 109.77 | 109.82 | 168000.0 |
| 2004-08-19 12:15:00 | SPY | ETF | 109.82 | 109.87 | 109.79 | 109.82 | 165000.0 |
| 2004-08-19 12:20:00 | SPY | ETF | 109.83 | 109.89 | 109.81 | 109.84 | 81400.0 |
| 2004-08-19 12:25:00 | SPY | ETF | 109.84 | 109.9 | 109.8 | 109.85 | 244500.0 |
| 2004-08-19 12:30:00 | SPY | ETF | 109.85 | 109.98 | 109.84 | 109.91 | 293900.0 |
| 2004-08-19 12:35:00 | SPY | ETF | 109.9 | 109.91 | 109.83 | 109.86 | 80700.0 |
> showing 50 of 4,250 rows — these rows as CSV