PREVIEW / etf_5min / 2008-10-29
file: by_date/etf_5min/2008/2008-10-29.parquet size: 548 KB rows: 26,241
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-29 04:10:00 | SPY | ETF | 92.02 | 92.02 | 92.02 | 92.02 | 1000.0 |
| 2008-10-29 04:15:00 | SPY | ETF | 92.15 | 92.15 | 92.0 | 92.0 | 900.0 |
| 2008-10-29 04:30:00 | SPY | ETF | 92.03 | 92.03 | 92.02 | 92.02 | 200.0 |
| 2008-10-29 04:35:00 | SPY | ETF | 91.97 | 92.04 | 91.97 | 92.04 | 600.0 |
| 2008-10-29 04:40:00 | SPY | ETF | 92.24 | 92.24 | 92.24 | 92.24 | 100.0 |
| 2008-10-29 04:50:00 | SPY | ETF | 92.05 | 92.05 | 91.94 | 91.94 | 800.0 |
| 2008-10-29 04:55:00 | SPY | ETF | 91.95 | 91.95 | 91.95 | 91.95 | 1000.0 |
| 2008-10-29 05:00:00 | SPY | ETF | 92.0 | 92.0 | 92.0 | 92.0 | 1000.0 |
| 2008-10-29 05:05:00 | SPY | ETF | 92.03 | 92.1 | 92.03 | 92.1 | 27000.0 |
| 2008-10-29 05:20:00 | SPY | ETF | 92.05 | 92.05 | 92.05 | 92.05 | 100.0 |
| 2008-10-29 05:35:00 | SPY | ETF | 91.87 | 91.88 | 91.73 | 91.73 | 9700.0 |
| 2008-10-29 05:50:00 | SPY | ETF | 92.0 | 92.0 | 92.0 | 92.0 | 1700.0 |
| 2008-10-29 06:00:00 | SPY | ETF | 92.21 | 92.55 | 92.21 | 92.41 | 51250.0 |
| 2008-10-29 06:05:00 | SPY | ETF | 92.51 | 92.66 | 92.51 | 92.65 | 650.0 |
| 2008-10-29 06:10:00 | SPY | ETF | 92.65 | 92.85 | 92.65 | 92.83 | 54350.0 |
| 2008-10-29 06:15:00 | SPY | ETF | 93.0 | 93.0 | 93.0 | 93.0 | 100.0 |
| 2008-10-29 06:25:00 | SPY | ETF | 93.0 | 93.0 | 93.0 | 93.0 | 10000.0 |
| 2008-10-29 06:30:00 | SPY | ETF | 92.99 | 93.04 | 92.91 | 92.91 | 2400.0 |
| 2008-10-29 06:35:00 | SPY | ETF | 92.89 | 92.93 | 92.89 | 92.92 | 20000.0 |
| 2008-10-29 06:40:00 | SPY | ETF | 92.99 | 93.2 | 92.99 | 93.15 | 39003.0 |
| 2008-10-29 06:45:00 | SPY | ETF | 93.17 | 93.62 | 93.17 | 93.47 | 16234.0 |
| 2008-10-29 06:50:00 | SPY | ETF | 93.34 | 93.8 | 93.34 | 93.57 | 66098.0 |
| 2008-10-29 06:55:00 | SPY | ETF | 93.55 | 93.73 | 93.55 | 93.7 | 57227.0 |
| 2008-10-29 07:00:00 | SPY | ETF | 93.7 | 93.75 | 93.15 | 93.22 | 192325.0 |
| 2008-10-29 07:05:00 | SPY | ETF | 93.23 | 93.31 | 92.94 | 93.04 | 117992.0 |
| 2008-10-29 07:10:00 | SPY | ETF | 93.04 | 93.4 | 93.04 | 93.33 | 73496.0 |
| 2008-10-29 07:15:00 | SPY | ETF | 93.27 | 93.27 | 92.96 | 92.96 | 14198.0 |
| 2008-10-29 07:20:00 | SPY | ETF | 93.0 | 93.26 | 92.96 | 93.21 | 8000.0 |
| 2008-10-29 07:25:00 | SPY | ETF | 93.23 | 93.45 | 93.22 | 93.37 | 21534.0 |
| 2008-10-29 07:30:00 | SPY | ETF | 93.43 | 93.8 | 93.3 | 93.8 | 110042.0 |
| 2008-10-29 07:35:00 | SPY | ETF | 93.8 | 93.98 | 93.6 | 93.95 | 110416.0 |
| 2008-10-29 07:40:00 | SPY | ETF | 93.98 | 94.27 | 93.91 | 94.12 | 388603.0 |
| 2008-10-29 07:45:00 | SPY | ETF | 94.09 | 94.64 | 94.07 | 94.3 | 387123.0 |
| 2008-10-29 07:50:00 | SPY | ETF | 94.3 | 94.37 | 94.2 | 94.24 | 245950.0 |
| 2008-10-29 07:55:00 | SPY | ETF | 94.23 | 94.36 | 94.14 | 94.24 | 108775.0 |
| 2008-10-29 08:00:00 | SPY | ETF | 94.25 | 94.47 | 92.0 | 94.47 | 1414772.0 |
| 2008-10-29 08:05:00 | SPY | ETF | 94.48 | 95.13 | 94.45 | 95.07 | 973300.0 |
| 2008-10-29 08:10:00 | SPY | ETF | 95.1 | 95.23 | 94.71 | 94.79 | 1202643.0 |
| 2008-10-29 08:15:00 | SPY | ETF | 94.8 | 94.82 | 94.52 | 94.55 | 300897.0 |
| 2008-10-29 08:20:00 | SPY | ETF | 94.54 | 94.61 | 94.25 | 94.26 | 352963.0 |
| 2008-10-29 08:25:00 | SPY | ETF | 94.26 | 94.29 | 94.04 | 94.05 | 375177.0 |
| 2008-10-29 08:30:00 | SPY | ETF | 94.15 | 94.58 | 94.0 | 94.0 | 1152814.0 |
| 2008-10-29 08:35:00 | SPY | ETF | 94.0 | 94.0 | 93.73 | 93.83 | 979255.0 |
| 2008-10-29 08:40:00 | SPY | ETF | 93.83 | 94.0 | 93.57 | 93.65 | 850365.0 |
| 2008-10-29 08:45:00 | SPY | ETF | 93.65 | 93.83 | 93.58 | 93.71 | 666212.0 |
| 2008-10-29 08:50:00 | SPY | ETF | 93.71 | 93.88 | 93.71 | 93.82 | 467419.0 |
| 2008-10-29 08:55:00 | SPY | ETF | 93.82 | 93.89 | 93.59 | 93.74 | 464577.0 |
| 2008-10-29 09:00:00 | SPY | ETF | 93.74 | 93.86 | 93.57 | 93.78 | 572316.0 |
| 2008-10-29 09:05:00 | SPY | ETF | 93.81 | 93.96 | 93.6 | 93.96 | 800697.0 |
| 2008-10-29 09:10:00 | SPY | ETF | 93.96 | 94.25 | 93.93 | 94.03 | 612516.0 |
> showing 50 of 26,241 rows — these rows as CSV