PREVIEW / etf_5min / 2008-09-25
file: by_date/etf_5min/2008/2008-09-25.parquet size: 521 KB rows: 24,914
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-25 04:30:00 | SPY | ETF | 118.95 | 118.95 | 118.95 | 118.95 | 100.0 |
| 2008-09-25 04:40:00 | SPY | ETF | 119.24 | 119.24 | 119.24 | 119.24 | 100.0 |
| 2008-09-25 05:10:00 | SPY | ETF | 119.71 | 119.71 | 119.71 | 119.71 | 100.0 |
| 2008-09-25 05:50:00 | SPY | ETF | 119.77 | 119.77 | 119.77 | 119.77 | 1000.0 |
| 2008-09-25 05:55:00 | SPY | ETF | 119.65 | 119.65 | 119.65 | 119.65 | 2500.0 |
| 2008-09-25 06:20:00 | SPY | ETF | 119.76 | 119.78 | 119.75 | 119.75 | 10500.0 |
| 2008-09-25 06:25:00 | SPY | ETF | 119.77 | 119.77 | 119.77 | 119.77 | 1000.0 |
| 2008-09-25 06:30:00 | SPY | ETF | 119.74 | 119.74 | 119.11 | 119.41 | 31390.0 |
| 2008-09-25 06:35:00 | SPY | ETF | 119.17 | 119.37 | 119.15 | 119.3 | 82000.0 |
| 2008-09-25 06:40:00 | SPY | ETF | 119.48 | 119.48 | 119.18 | 119.18 | 34100.0 |
| 2008-09-25 06:45:00 | SPY | ETF | 119.2 | 119.33 | 119.2 | 119.3 | 2200.0 |
| 2008-09-25 06:50:00 | SPY | ETF | 119.21 | 119.26 | 119.11 | 119.18 | 26500.0 |
| 2008-09-25 06:55:00 | SPY | ETF | 119.18 | 119.18 | 119.11 | 119.11 | 8500.0 |
| 2008-09-25 07:00:00 | SPY | ETF | 119.14 | 119.2 | 119.0 | 119.0 | 34787.0 |
| 2008-09-25 07:05:00 | SPY | ETF | 119.05 | 119.09 | 118.86 | 118.9 | 51700.0 |
| 2008-09-25 07:10:00 | SPY | ETF | 118.9 | 119.17 | 118.9 | 119.14 | 56500.0 |
| 2008-09-25 07:15:00 | SPY | ETF | 119.15 | 119.23 | 119.1 | 119.23 | 71864.0 |
| 2008-09-25 07:20:00 | SPY | ETF | 119.21 | 119.21 | 119.09 | 119.1 | 100500.0 |
| 2008-09-25 07:25:00 | SPY | ETF | 118.99 | 119.02 | 118.98 | 119.02 | 15600.0 |
| 2008-09-25 07:30:00 | SPY | ETF | 119.0 | 119.0 | 118.91 | 118.95 | 71100.0 |
| 2008-09-25 07:35:00 | SPY | ETF | 118.97 | 119.09 | 118.9 | 118.9 | 165016.0 |
| 2008-09-25 07:40:00 | SPY | ETF | 118.9 | 118.95 | 118.83 | 118.85 | 179188.0 |
| 2008-09-25 07:45:00 | SPY | ETF | 118.83 | 118.83 | 118.6 | 118.7 | 287769.0 |
| 2008-09-25 07:50:00 | SPY | ETF | 118.7 | 118.94 | 118.62 | 118.85 | 135976.0 |
| 2008-09-25 07:55:00 | SPY | ETF | 118.86 | 119.22 | 118.85 | 119.2 | 270431.0 |
| 2008-09-25 08:00:00 | SPY | ETF | 119.17 | 119.6 | 118.84 | 119.58 | 2585342.0 |
| 2008-09-25 08:05:00 | SPY | ETF | 119.62 | 119.78 | 119.5 | 119.51 | 411118.0 |
| 2008-09-25 08:10:00 | SPY | ETF | 119.48 | 119.81 | 119.16 | 119.61 | 471171.0 |
| 2008-09-25 08:15:00 | SPY | ETF | 119.61 | 120.02 | 119.6 | 119.93 | 738174.0 |
| 2008-09-25 08:20:00 | SPY | ETF | 119.92 | 120.36 | 119.81 | 120.33 | 1688574.0 |
| 2008-09-25 08:25:00 | SPY | ETF | 120.35 | 120.37 | 119.95 | 119.95 | 1196540.0 |
| 2008-09-25 08:30:00 | SPY | ETF | 119.89 | 120.15 | 119.55 | 120.02 | 2000088.0 |
| 2008-09-25 08:35:00 | SPY | ETF | 120.02 | 120.22 | 119.88 | 120.03 | 973659.0 |
| 2008-09-25 08:40:00 | SPY | ETF | 120.03 | 120.05 | 119.73 | 119.76 | 724194.0 |
| 2008-09-25 08:45:00 | SPY | ETF | 119.77 | 119.88 | 119.63 | 119.75 | 964717.0 |
| 2008-09-25 08:50:00 | SPY | ETF | 119.74 | 119.83 | 119.68 | 119.68 | 199668.0 |
| 2008-09-25 08:55:00 | SPY | ETF | 119.69 | 119.73 | 119.54 | 119.59 | 353627.0 |
| 2008-09-25 09:00:00 | SPY | ETF | 119.59 | 119.8 | 119.54 | 119.61 | 443015.0 |
| 2008-09-25 09:05:00 | SPY | ETF | 119.61 | 119.85 | 119.49 | 119.5 | 431345.0 |
| 2008-09-25 09:10:00 | SPY | ETF | 119.5 | 119.6 | 119.19 | 119.27 | 789733.0 |
| 2008-09-25 09:15:00 | SPY | ETF | 119.27 | 119.37 | 119.18 | 119.33 | 368283.0 |
| 2008-09-25 09:20:00 | SPY | ETF | 119.32 | 119.48 | 119.18 | 119.47 | 466697.0 |
| 2008-09-25 09:25:00 | SPY | ETF | 119.48 | 119.6 | 119.46 | 119.56 | 269995.0 |
| 2008-09-25 09:30:00 | SPY | ETF | 119.56 | 119.66 | 119.18 | 119.54 | 4635407.0 |
| 2008-09-25 09:35:00 | SPY | ETF | 119.55 | 119.65 | 119.07 | 119.23 | 5465300.0 |
| 2008-09-25 09:40:00 | SPY | ETF | 119.23 | 119.86 | 119.23 | 119.64 | 7139060.0 |
| 2008-09-25 09:45:00 | SPY | ETF | 119.64 | 120.02 | 119.63 | 119.95 | 4210027.0 |
| 2008-09-25 09:50:00 | SPY | ETF | 119.95 | 120.43 | 119.95 | 120.19 | 5098616.0 |
| 2008-09-25 09:55:00 | SPY | ETF | 120.2 | 120.52 | 120.16 | 120.35 | 3665921.0 |
| 2008-09-25 10:00:00 | SPY | ETF | 120.38 | 120.41 | 119.96 | 120.0 | 6360723.0 |
> showing 50 of 24,914 rows — these rows as CSV