PREVIEW / etf_5min / 2006-02-14
file: by_date/etf_5min/2006/2006-02-14.parquet size: 185 KB rows: 9,000
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-14 07:00:00 | SPY | ETF | 126.68 | 126.68 | 126.68 | 126.68 | 200.0 |
| 2006-02-14 07:10:00 | SPY | ETF | 126.69 | 126.74 | 126.69 | 126.74 | 8500.0 |
| 2006-02-14 07:15:00 | SPY | ETF | 126.75 | 126.75 | 126.73 | 126.73 | 6300.0 |
| 2006-02-14 07:30:00 | SPY | ETF | 126.7 | 126.7 | 126.7 | 126.7 | 100.0 |
| 2006-02-14 07:35:00 | SPY | ETF | 126.71 | 126.73 | 126.71 | 126.71 | 2100.0 |
| 2006-02-14 07:40:00 | SPY | ETF | 126.71 | 126.73 | 126.71 | 126.73 | 1800.0 |
| 2006-02-14 07:50:00 | SPY | ETF | 126.7 | 126.72 | 126.7 | 126.72 | 22800.0 |
| 2006-02-14 07:55:00 | SPY | ETF | 126.71 | 126.71 | 126.7 | 126.7 | 4200.0 |
| 2006-02-14 08:00:00 | SPY | ETF | 126.73 | 126.82 | 126.68 | 126.74 | 60300.0 |
| 2006-02-14 08:05:00 | SPY | ETF | 126.74 | 126.74 | 126.72 | 126.72 | 33300.0 |
| 2006-02-14 08:10:00 | SPY | ETF | 126.7 | 126.7 | 126.68 | 126.69 | 6600.0 |
| 2006-02-14 08:15:00 | SPY | ETF | 126.7 | 126.7 | 126.7 | 126.7 | 1300.0 |
| 2006-02-14 08:20:00 | SPY | ETF | 126.7 | 126.74 | 126.7 | 126.72 | 10800.0 |
| 2006-02-14 08:25:00 | SPY | ETF | 126.73 | 126.73 | 126.73 | 126.73 | 151600.0 |
| 2006-02-14 08:30:00 | SPY | ETF | 126.75 | 126.85 | 126.61 | 126.68 | 296500.0 |
| 2006-02-14 08:35:00 | SPY | ETF | 126.63 | 126.79 | 126.63 | 126.75 | 300200.0 |
| 2006-02-14 08:40:00 | SPY | ETF | 126.75 | 126.77 | 126.68 | 126.68 | 49100.0 |
| 2006-02-14 08:45:00 | SPY | ETF | 126.7 | 126.77 | 126.69 | 126.71 | 926900.0 |
| 2006-02-14 08:50:00 | SPY | ETF | 126.66 | 126.66 | 126.62 | 126.62 | 9400.0 |
| 2006-02-14 08:55:00 | SPY | ETF | 126.63 | 126.67 | 126.62 | 126.66 | 158500.0 |
| 2006-02-14 09:00:00 | SPY | ETF | 126.65 | 126.65 | 126.56 | 126.59 | 27800.0 |
| 2006-02-14 09:05:00 | SPY | ETF | 126.6 | 126.6 | 126.53 | 126.54 | 4400.0 |
| 2006-02-14 09:10:00 | SPY | ETF | 126.56 | 126.57 | 126.55 | 126.55 | 8600.0 |
| 2006-02-14 09:15:00 | SPY | ETF | 126.55 | 126.56 | 126.53 | 126.54 | 43000.0 |
| 2006-02-14 09:20:00 | SPY | ETF | 126.54 | 126.7 | 126.5 | 126.52 | 372300.0 |
| 2006-02-14 09:25:00 | SPY | ETF | 126.52 | 126.54 | 126.41 | 126.46 | 540100.0 |
| 2006-02-14 09:30:00 | SPY | ETF | 126.46 | 126.61 | 126.45 | 126.54 | 1560200.0 |
| 2006-02-14 09:35:00 | SPY | ETF | 126.52 | 126.53 | 126.3 | 126.34 | 1509500.0 |
| 2006-02-14 09:40:00 | SPY | ETF | 126.34 | 126.48 | 126.28 | 126.35 | 1044400.0 |
| 2006-02-14 09:45:00 | SPY | ETF | 126.34 | 126.37 | 126.19 | 126.34 | 1313500.0 |
| 2006-02-14 09:50:00 | SPY | ETF | 126.34 | 126.48 | 126.3 | 126.45 | 1159500.0 |
| 2006-02-14 09:55:00 | SPY | ETF | 126.45 | 126.72 | 126.43 | 126.72 | 2263600.0 |
| 2006-02-14 10:00:00 | SPY | ETF | 126.66 | 126.84 | 126.61 | 126.62 | 1499600.0 |
| 2006-02-14 10:05:00 | SPY | ETF | 126.63 | 126.72 | 126.62 | 126.66 | 825300.0 |
| 2006-02-14 10:10:00 | SPY | ETF | 126.66 | 126.71 | 126.6 | 126.65 | 492300.0 |
| 2006-02-14 10:15:00 | SPY | ETF | 126.65 | 126.69 | 126.56 | 126.57 | 467900.0 |
| 2006-02-14 10:20:00 | SPY | ETF | 126.56 | 126.62 | 126.5 | 126.56 | 618100.0 |
| 2006-02-14 10:25:00 | SPY | ETF | 126.56 | 126.64 | 126.55 | 126.57 | 498000.0 |
| 2006-02-14 10:30:00 | SPY | ETF | 126.57 | 126.6 | 126.37 | 126.43 | 698500.0 |
| 2006-02-14 10:35:00 | SPY | ETF | 126.42 | 126.42 | 126.26 | 126.39 | 1242100.0 |
| 2006-02-14 10:40:00 | SPY | ETF | 126.37 | 126.51 | 126.35 | 126.45 | 514700.0 |
| 2006-02-14 10:45:00 | SPY | ETF | 126.46 | 126.6 | 126.45 | 126.56 | 1042500.0 |
| 2006-02-14 10:50:00 | SPY | ETF | 126.56 | 126.67 | 126.53 | 126.61 | 360000.0 |
| 2006-02-14 10:55:00 | SPY | ETF | 126.62 | 126.7 | 126.51 | 126.7 | 555100.0 |
| 2006-02-14 11:00:00 | SPY | ETF | 126.7 | 126.82 | 126.63 | 126.78 | 980400.0 |
| 2006-02-14 11:05:00 | SPY | ETF | 126.77 | 126.94 | 126.73 | 126.81 | 1960400.0 |
| 2006-02-14 11:10:00 | SPY | ETF | 126.82 | 127.01 | 126.78 | 127.01 | 1326200.0 |
| 2006-02-14 11:15:00 | SPY | ETF | 127.0 | 127.09 | 126.95 | 127.01 | 1258400.0 |
| 2006-02-14 11:20:00 | SPY | ETF | 127.01 | 127.16 | 126.99 | 127.11 | 1264700.0 |
| 2006-02-14 11:25:00 | SPY | ETF | 127.11 | 127.15 | 127.01 | 127.04 | 938000.0 |
> showing 50 of 9,000 rows — these rows as CSV