PREVIEW / etf_5min / 2006-04-13
file: by_date/etf_5min/2006/2006-04-13.parquet size: 170 KB rows: 8,723
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-04-13 06:45:00 | SPY | ETF | 128.87 | 128.87 | 128.87 | 128.87 | 2500.0 |
| 2006-04-13 06:50:00 | SPY | ETF | 128.85 | 128.85 | 128.78 | 128.79 | 2900.0 |
| 2006-04-13 06:55:00 | SPY | ETF | 128.74 | 128.74 | 128.74 | 128.74 | 100.0 |
| 2006-04-13 07:00:00 | SPY | ETF | 128.73 | 128.73 | 128.7 | 128.7 | 5100.0 |
| 2006-04-13 07:10:00 | SPY | ETF | 128.73 | 128.73 | 128.73 | 128.73 | 100.0 |
| 2006-04-13 07:15:00 | SPY | ETF | 128.73 | 128.75 | 128.71 | 128.71 | 2300.0 |
| 2006-04-13 07:25:00 | SPY | ETF | 128.71 | 128.74 | 128.7 | 128.7 | 52000.0 |
| 2006-04-13 07:35:00 | SPY | ETF | 128.69 | 128.72 | 128.69 | 128.72 | 7000.0 |
| 2006-04-13 07:40:00 | SPY | ETF | 128.69 | 128.69 | 128.65 | 128.65 | 18000.0 |
| 2006-04-13 07:45:00 | SPY | ETF | 128.64 | 128.64 | 128.64 | 128.64 | 1000.0 |
| 2006-04-13 07:55:00 | SPY | ETF | 128.68 | 128.68 | 128.66 | 128.66 | 1100.0 |
| 2006-04-13 08:00:00 | SPY | ETF | 128.69 | 128.75 | 128.65 | 128.71 | 238500.0 |
| 2006-04-13 08:10:00 | SPY | ETF | 128.69 | 128.71 | 128.69 | 128.69 | 82400.0 |
| 2006-04-13 08:15:00 | SPY | ETF | 128.66 | 128.74 | 128.66 | 128.72 | 92700.0 |
| 2006-04-13 08:20:00 | SPY | ETF | 128.74 | 128.74 | 128.73 | 128.74 | 3400.0 |
| 2006-04-13 08:25:00 | SPY | ETF | 128.77 | 128.77 | 128.75 | 128.77 | 43100.0 |
| 2006-04-13 08:30:00 | SPY | ETF | 128.79 | 128.95 | 128.77 | 128.9 | 147600.0 |
| 2006-04-13 08:35:00 | SPY | ETF | 128.89 | 128.89 | 128.8 | 128.81 | 46600.0 |
| 2006-04-13 08:40:00 | SPY | ETF | 128.83 | 128.93 | 128.83 | 128.84 | 15200.0 |
| 2006-04-13 08:45:00 | SPY | ETF | 128.85 | 128.86 | 128.84 | 128.84 | 1500.0 |
| 2006-04-13 08:50:00 | SPY | ETF | 128.84 | 128.84 | 128.77 | 128.77 | 50200.0 |
| 2006-04-13 08:55:00 | SPY | ETF | 128.77 | 128.94 | 128.65 | 128.68 | 226000.0 |
| 2006-04-13 09:00:00 | SPY | ETF | 128.69 | 128.69 | 128.48 | 128.55 | 405500.0 |
| 2006-04-13 09:05:00 | SPY | ETF | 128.55 | 128.6 | 128.52 | 128.57 | 540900.0 |
| 2006-04-13 09:10:00 | SPY | ETF | 128.58 | 128.61 | 128.52 | 128.61 | 104400.0 |
| 2006-04-13 09:15:00 | SPY | ETF | 128.6 | 128.61 | 128.56 | 128.61 | 20900.0 |
| 2006-04-13 09:20:00 | SPY | ETF | 128.62 | 128.64 | 128.61 | 128.63 | 103600.0 |
| 2006-04-13 09:25:00 | SPY | ETF | 128.64 | 128.64 | 128.6 | 128.6 | 78700.0 |
| 2006-04-13 09:30:00 | SPY | ETF | 128.59 | 128.6 | 128.47 | 128.52 | 1998000.0 |
| 2006-04-13 09:35:00 | SPY | ETF | 128.52 | 128.6 | 128.5 | 128.5 | 1411900.0 |
| 2006-04-13 09:40:00 | SPY | ETF | 128.5 | 128.58 | 128.47 | 128.5 | 1337200.0 |
| 2006-04-13 09:45:00 | SPY | ETF | 128.49 | 128.59 | 128.43 | 128.56 | 1222100.0 |
| 2006-04-13 09:50:00 | SPY | ETF | 128.52 | 128.6 | 128.49 | 128.54 | 836500.0 |
| 2006-04-13 09:55:00 | SPY | ETF | 128.54 | 128.55 | 128.31 | 128.4 | 1496100.0 |
| 2006-04-13 10:00:00 | SPY | ETF | 128.4 | 128.77 | 128.37 | 128.77 | 1375800.0 |
| 2006-04-13 10:05:00 | SPY | ETF | 128.77 | 128.88 | 128.66 | 128.77 | 1409900.0 |
| 2006-04-13 10:10:00 | SPY | ETF | 128.77 | 128.92 | 128.72 | 128.8 | 1612900.0 |
| 2006-04-13 10:15:00 | SPY | ETF | 128.8 | 128.83 | 128.68 | 128.74 | 1010000.0 |
| 2006-04-13 10:20:00 | SPY | ETF | 128.75 | 128.75 | 128.6 | 128.67 | 1269500.0 |
| 2006-04-13 10:25:00 | SPY | ETF | 128.67 | 128.68 | 128.56 | 128.61 | 431100.0 |
| 2006-04-13 10:30:00 | SPY | ETF | 128.61 | 128.71 | 128.59 | 128.68 | 329400.0 |
| 2006-04-13 10:35:00 | SPY | ETF | 128.68 | 128.72 | 128.63 | 128.64 | 480600.0 |
| 2006-04-13 10:40:00 | SPY | ETF | 128.64 | 128.83 | 128.64 | 128.74 | 388200.0 |
| 2006-04-13 10:45:00 | SPY | ETF | 128.7495 | 129.03 | 128.73 | 129.02 | 1048600.0 |
| 2006-04-13 10:50:00 | SPY | ETF | 129.02 | 129.11 | 128.89 | 129.1 | 1066500.0 |
| 2006-04-13 10:55:00 | SPY | ETF | 129.12 | 129.16 | 129.0 | 129.11 | 1608900.0 |
| 2006-04-13 11:00:00 | SPY | ETF | 129.121 | 129.121 | 128.92 | 129.0 | 1500000.0 |
| 2006-04-13 11:05:00 | SPY | ETF | 128.98 | 129.11 | 128.94 | 129.09 | 868800.0 |
| 2006-04-13 11:10:00 | SPY | ETF | 129.09 | 129.25 | 129.09 | 129.14 | 1325500.0 |
| 2006-04-13 11:15:00 | SPY | ETF | 129.14 | 129.19 | 129.01 | 129.04 | 640600.0 |
> showing 50 of 8,723 rows — these rows as CSV