PREVIEW / etf_5min / 2008-09-10
file: by_date/etf_5min/2008/2008-09-10.parquet size: 520 KB rows: 24,742
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-09-10 04:15:00 | SPY | ETF | 124.11 | 124.21 | 124.11 | 124.21 | 2100.0 |
| 2008-09-10 04:20:00 | SPY | ETF | 124.17 | 124.17 | 124.17 | 124.17 | 100.0 |
| 2008-09-10 04:25:00 | SPY | ETF | 124.42 | 124.42 | 124.42 | 124.42 | 100.0 |
| 2008-09-10 05:25:00 | SPY | ETF | 123.79 | 123.79 | 123.79 | 123.79 | 1000.0 |
| 2008-09-10 05:40:00 | SPY | ETF | 123.78 | 123.78 | 123.78 | 123.78 | 100.0 |
| 2008-09-10 05:45:00 | SPY | ETF | 123.76 | 123.76 | 123.76 | 123.76 | 100.0 |
| 2008-09-10 05:50:00 | SPY | ETF | 123.68 | 123.68 | 123.68 | 123.68 | 5000.0 |
| 2008-09-10 06:00:00 | SPY | ETF | 123.64 | 123.64 | 123.64 | 123.64 | 5000.0 |
| 2008-09-10 06:05:00 | SPY | ETF | 123.74 | 123.74 | 123.74 | 123.74 | 100.0 |
| 2008-09-10 06:10:00 | SPY | ETF | 124.02 | 124.07 | 124.02 | 124.07 | 4000.0 |
| 2008-09-10 06:15:00 | SPY | ETF | 124.16 | 124.16 | 124.0 | 124.03 | 6500.0 |
| 2008-09-10 06:20:00 | SPY | ETF | 124.01 | 124.05 | 124.0 | 124.02 | 123300.0 |
| 2008-09-10 06:25:00 | SPY | ETF | 124.03 | 124.03 | 124.03 | 124.03 | 1000.0 |
| 2008-09-10 06:35:00 | SPY | ETF | 124.06 | 124.06 | 124.0 | 124.0 | 20200.0 |
| 2008-09-10 06:40:00 | SPY | ETF | 124.09 | 124.09 | 124.09 | 124.09 | 10000.0 |
| 2008-09-10 06:45:00 | SPY | ETF | 124.09 | 124.09 | 124.01 | 124.01 | 1600.0 |
| 2008-09-10 06:50:00 | SPY | ETF | 123.99 | 123.99 | 123.91 | 123.91 | 300.0 |
| 2008-09-10 06:55:00 | SPY | ETF | 123.9 | 123.9 | 123.73 | 123.84 | 14800.0 |
| 2008-09-10 07:00:00 | SPY | ETF | 123.83 | 123.84 | 123.8 | 123.84 | 10100.0 |
| 2008-09-10 07:05:00 | SPY | ETF | 123.86 | 124.03 | 123.86 | 124.03 | 12500.0 |
| 2008-09-10 07:10:00 | SPY | ETF | 123.93 | 124.05 | 123.9 | 123.95 | 207224.0 |
| 2008-09-10 07:15:00 | SPY | ETF | 124.0 | 124.2 | 123.96 | 124.16 | 113300.0 |
| 2008-09-10 07:20:00 | SPY | ETF | 124.09 | 124.14 | 123.96 | 123.96 | 88862.0 |
| 2008-09-10 07:25:00 | SPY | ETF | 123.88 | 124.2 | 123.84 | 124.06 | 269500.0 |
| 2008-09-10 07:30:00 | SPY | ETF | 124.08 | 124.4 | 123.9 | 124.23 | 392937.0 |
| 2008-09-10 07:35:00 | SPY | ETF | 124.2 | 124.31 | 123.5 | 123.82 | 1260960.0 |
| 2008-09-10 07:40:00 | SPY | ETF | 123.77 | 123.77 | 123.29 | 123.32 | 1117127.0 |
| 2008-09-10 07:45:00 | SPY | ETF | 123.32 | 123.42 | 123.07 | 123.4 | 1059544.0 |
| 2008-09-10 07:50:00 | SPY | ETF | 123.39 | 123.43 | 123.1 | 123.13 | 856581.0 |
| 2008-09-10 07:55:00 | SPY | ETF | 123.09 | 123.14 | 122.58 | 122.68 | 2061379.0 |
| 2008-09-10 08:00:00 | SPY | ETF | 122.67 | 124.13 | 122.47 | 122.6 | 2001122.0 |
| 2008-09-10 08:05:00 | SPY | ETF | 122.6 | 123.23 | 122.51 | 122.86 | 1102681.0 |
| 2008-09-10 08:10:00 | SPY | ETF | 122.87 | 122.89 | 122.71 | 122.72 | 719967.0 |
| 2008-09-10 08:15:00 | SPY | ETF | 122.72 | 122.82 | 122.69 | 122.78 | 480216.0 |
| 2008-09-10 08:20:00 | SPY | ETF | 122.8 | 123.07 | 122.77 | 123.03 | 513937.0 |
| 2008-09-10 08:25:00 | SPY | ETF | 123.03 | 123.63 | 123.01 | 123.51 | 2269254.0 |
| 2008-09-10 08:30:00 | SPY | ETF | 123.5 | 123.5 | 123.24 | 123.31 | 912580.0 |
| 2008-09-10 08:35:00 | SPY | ETF | 123.31 | 123.47 | 123.26 | 123.39 | 621448.0 |
| 2008-09-10 08:40:00 | SPY | ETF | 123.39 | 123.57 | 123.32 | 123.57 | 875440.0 |
| 2008-09-10 08:45:00 | SPY | ETF | 123.57 | 123.62 | 123.5 | 123.53 | 657380.0 |
| 2008-09-10 08:50:00 | SPY | ETF | 123.54 | 123.65 | 123.46 | 123.64 | 399026.0 |
| 2008-09-10 08:55:00 | SPY | ETF | 123.64 | 123.92 | 123.64 | 123.9 | 1283723.0 |
| 2008-09-10 09:00:00 | SPY | ETF | 123.89 | 123.91 | 123.81 | 123.86 | 494787.0 |
| 2008-09-10 09:05:00 | SPY | ETF | 123.85 | 123.85 | 123.72 | 123.76 | 336125.0 |
| 2008-09-10 09:10:00 | SPY | ETF | 123.76 | 123.8 | 123.65 | 123.73 | 209406.0 |
| 2008-09-10 09:15:00 | SPY | ETF | 123.5 | 123.8 | 123.5 | 123.76 | 277199.0 |
| 2008-09-10 09:20:00 | SPY | ETF | 123.77 | 123.94 | 123.72 | 123.91 | 565630.0 |
| 2008-09-10 09:25:00 | SPY | ETF | 123.91 | 124.0 | 123.85 | 123.88 | 806117.0 |
| 2008-09-10 09:30:00 | SPY | ETF | 123.89 | 123.9 | 123.57 | 123.59 | 6754647.0 |
| 2008-09-10 09:35:00 | SPY | ETF | 123.6 | 123.6 | 123.3 | 123.32 | 5629970.0 |
> showing 50 of 24,742 rows — these rows as CSV