PREVIEW / etf_5min / 2004-04-01
file: by_date/etf_5min/2004/2004-04-01.parquet size: 91 KB rows: 4,812
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-04-01 08:05:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 600.0 |
| 2004-04-01 08:10:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 5000.0 |
| 2004-04-01 08:15:00 | SPY | ETF | 112.92 | 112.92 | 112.88 | 112.88 | 1800.0 |
| 2004-04-01 08:20:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 500.0 |
| 2004-04-01 08:25:00 | SPY | ETF | 112.92 | 112.95 | 112.92 | 112.95 | 2200.0 |
| 2004-04-01 08:30:00 | SPY | ETF | 112.91 | 112.98 | 112.91 | 112.95 | 47500.0 |
| 2004-04-01 08:35:00 | SPY | ETF | 112.98 | 113.0 | 112.98 | 112.98 | 3900.0 |
| 2004-04-01 08:40:00 | SPY | ETF | 112.98 | 112.98 | 112.92 | 112.95 | 7400.0 |
| 2004-04-01 08:45:00 | SPY | ETF | 112.93 | 112.94 | 112.92 | 112.94 | 1300.0 |
| 2004-04-01 08:50:00 | SPY | ETF | 112.95 | 113.06 | 112.95 | 113.03 | 8700.0 |
| 2004-04-01 08:55:00 | SPY | ETF | 113.05 | 113.15 | 113.05 | 113.13 | 5800.0 |
| 2004-04-01 09:00:00 | SPY | ETF | 113.11 | 113.11 | 113.06 | 113.06 | 900.0 |
| 2004-04-01 09:05:00 | SPY | ETF | 113.05 | 113.05 | 113.05 | 113.05 | 300.0 |
| 2004-04-01 09:10:00 | SPY | ETF | 113.07 | 113.09 | 113.07 | 113.09 | 3100.0 |
| 2004-04-01 09:15:00 | SPY | ETF | 113.12 | 113.12 | 113.12 | 113.12 | 11000.0 |
| 2004-04-01 09:20:00 | SPY | ETF | 113.11 | 113.11 | 113.11 | 113.11 | 200.0 |
| 2004-04-01 09:25:00 | SPY | ETF | 113.12 | 113.12 | 113.07 | 113.07 | 13000.0 |
| 2004-04-01 09:30:00 | SPY | ETF | 113.07 | 113.23 | 113.05 | 113.22 | 1497400.0 |
| 2004-04-01 09:35:00 | SPY | ETF | 113.22 | 113.27 | 113.12 | 113.17 | 818100.0 |
| 2004-04-01 09:40:00 | SPY | ETF | 113.18 | 113.32 | 113.14 | 113.24 | 841000.0 |
| 2004-04-01 09:45:00 | SPY | ETF | 113.24 | 113.3 | 113.15 | 113.19 | 765800.0 |
| 2004-04-01 09:50:00 | SPY | ETF | 113.18 | 113.25 | 113.16 | 113.16 | 702500.0 |
| 2004-04-01 09:55:00 | SPY | ETF | 113.17 | 113.21 | 113.14 | 113.17 | 497800.0 |
| 2004-04-01 10:00:00 | SPY | ETF | 113.17 | 113.36 | 113.16 | 113.29 | 2170500.0 |
| 2004-04-01 10:05:00 | SPY | ETF | 113.3 | 113.56 | 113.28 | 113.49 | 1783000.0 |
| 2004-04-01 10:10:00 | SPY | ETF | 113.49 | 113.63 | 113.45 | 113.5299 | 718300.0 |
| 2004-04-01 10:15:00 | SPY | ETF | 113.56 | 113.58 | 113.47 | 113.54 | 1561100.0 |
| 2004-04-01 10:20:00 | SPY | ETF | 113.53 | 113.67 | 113.51 | 113.64 | 1844400.0 |
| 2004-04-01 10:25:00 | SPY | ETF | 113.65 | 113.68 | 113.56 | 113.66 | 629400.0 |
| 2004-04-01 10:30:00 | SPY | ETF | 113.66 | 113.76 | 113.55 | 113.73 | 1076000.0 |
| 2004-04-01 10:35:00 | SPY | ETF | 113.74 | 113.79 | 113.68 | 113.71 | 806900.0 |
| 2004-04-01 10:40:00 | SPY | ETF | 113.7 | 113.73 | 113.62 | 113.67 | 519400.0 |
| 2004-04-01 10:45:00 | SPY | ETF | 113.68 | 113.86 | 113.67 | 113.83 | 888900.0 |
| 2004-04-01 10:50:00 | SPY | ETF | 113.86 | 113.87 | 113.77 | 113.78 | 1568300.0 |
| 2004-04-01 10:55:00 | SPY | ETF | 113.78 | 113.8 | 113.75 | 113.76 | 246600.0 |
| 2004-04-01 11:00:00 | SPY | ETF | 113.76 | 113.84 | 113.73 | 113.78 | 646700.0 |
| 2004-04-01 11:05:00 | SPY | ETF | 113.78 | 113.83 | 113.7 | 113.72 | 427700.0 |
| 2004-04-01 11:10:00 | SPY | ETF | 113.72 | 113.74 | 113.67 | 113.71 | 507200.0 |
| 2004-04-01 11:15:00 | SPY | ETF | 113.71 | 113.73 | 113.65 | 113.7 | 395100.0 |
| 2004-04-01 11:20:00 | SPY | ETF | 113.7 | 113.74 | 113.66 | 113.67 | 300900.0 |
| 2004-04-01 11:25:00 | SPY | ETF | 113.68 | 113.7 | 113.58 | 113.67 | 382500.0 |
| 2004-04-01 11:30:00 | SPY | ETF | 113.67 | 113.68 | 113.62 | 113.65 | 222500.0 |
| 2004-04-01 11:35:00 | SPY | ETF | 113.68 | 113.68 | 113.58 | 113.62 | 226700.0 |
| 2004-04-01 11:40:00 | SPY | ETF | 113.64 | 113.7 | 113.62 | 113.66 | 138500.0 |
| 2004-04-01 11:45:00 | SPY | ETF | 113.65 | 113.68 | 113.57 | 113.6 | 509400.0 |
| 2004-04-01 11:50:00 | SPY | ETF | 113.63 | 113.66 | 113.57 | 113.64 | 486800.0 |
| 2004-04-01 11:55:00 | SPY | ETF | 113.65 | 113.66 | 113.6 | 113.6 | 125800.0 |
| 2004-04-01 12:00:00 | SPY | ETF | 113.62 | 113.62 | 113.54 | 113.61 | 224000.0 |
| 2004-04-01 12:05:00 | SPY | ETF | 113.6 | 113.61 | 113.45 | 113.5 | 429000.0 |
| 2004-04-01 12:10:00 | SPY | ETF | 113.51 | 113.55 | 113.46 | 113.52 | 285800.0 |
> showing 50 of 4,812 rows — these rows as CSV