PREVIEW / etf_5min / 2008-06-18
file: by_date/etf_5min/2008/2008-06-18.parquet size: 495 KB rows: 23,341
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-06-18 04:15:00 | SPY | ETF | 135.44 | 135.44 | 135.44 | 135.44 | 100.0 |
| 2008-06-18 04:50:00 | SPY | ETF | 135.52 | 135.52 | 135.52 | 135.52 | 100.0 |
| 2008-06-18 05:05:00 | SPY | ETF | 135.66 | 135.66 | 135.66 | 135.66 | 100.0 |
| 2008-06-18 06:15:00 | SPY | ETF | 135.33 | 135.33 | 135.33 | 135.33 | 100.0 |
| 2008-06-18 06:20:00 | SPY | ETF | 135.11 | 135.11 | 135.11 | 135.11 | 300.0 |
| 2008-06-18 06:25:00 | SPY | ETF | 135.02 | 135.02 | 134.98 | 134.98 | 1200.0 |
| 2008-06-18 06:35:00 | SPY | ETF | 135.06 | 135.09 | 135.06 | 135.09 | 25000.0 |
| 2008-06-18 06:50:00 | SPY | ETF | 135.06 | 135.15 | 135.06 | 135.15 | 11000.0 |
| 2008-06-18 06:55:00 | SPY | ETF | 135.15 | 135.15 | 135.05 | 135.1 | 25200.0 |
| 2008-06-18 07:00:00 | SPY | ETF | 135.1 | 135.1 | 134.92 | 134.92 | 23800.0 |
| 2008-06-18 07:05:00 | SPY | ETF | 134.8 | 134.89 | 134.76 | 134.88 | 123300.0 |
| 2008-06-18 07:10:00 | SPY | ETF | 134.83 | 134.96 | 134.82 | 134.91 | 7500.0 |
| 2008-06-18 07:15:00 | SPY | ETF | 134.97 | 134.99 | 134.92 | 134.95 | 161300.0 |
| 2008-06-18 07:20:00 | SPY | ETF | 134.95 | 135.0 | 134.89 | 134.89 | 149620.0 |
| 2008-06-18 07:25:00 | SPY | ETF | 134.9 | 134.98 | 134.9 | 134.96 | 169000.0 |
| 2008-06-18 07:30:00 | SPY | ETF | 134.96 | 135.0 | 134.96 | 135.0 | 89100.0 |
| 2008-06-18 07:35:00 | SPY | ETF | 135.0 | 135.01 | 134.98 | 134.98 | 166400.0 |
| 2008-06-18 07:40:00 | SPY | ETF | 135.01 | 135.01 | 134.87 | 134.91 | 87800.0 |
| 2008-06-18 07:45:00 | SPY | ETF | 134.9 | 134.96 | 134.9 | 134.93 | 35994.0 |
| 2008-06-18 07:50:00 | SPY | ETF | 134.9 | 134.96 | 134.83 | 134.85 | 160309.0 |
| 2008-06-18 07:55:00 | SPY | ETF | 134.83 | 134.83 | 134.49 | 134.56 | 934259.0 |
| 2008-06-18 08:00:00 | SPY | ETF | 134.57 | 134.74 | 134.54 | 134.55 | 821261.0 |
| 2008-06-18 08:05:00 | SPY | ETF | 134.56 | 134.58 | 134.36 | 134.36 | 1117603.0 |
| 2008-06-18 08:10:00 | SPY | ETF | 134.37 | 135.74 | 134.35 | 134.53 | 734144.0 |
| 2008-06-18 08:15:00 | SPY | ETF | 134.52 | 134.66 | 134.51 | 134.56 | 831547.0 |
| 2008-06-18 08:20:00 | SPY | ETF | 134.57 | 134.59 | 134.5 | 134.58 | 346918.0 |
| 2008-06-18 08:25:00 | SPY | ETF | 134.59 | 134.68 | 134.57 | 134.67 | 243914.0 |
| 2008-06-18 08:30:00 | SPY | ETF | 134.68 | 134.7 | 134.61 | 134.65 | 362616.0 |
| 2008-06-18 08:35:00 | SPY | ETF | 134.66 | 134.66 | 134.59 | 134.62 | 90053.0 |
| 2008-06-18 08:40:00 | SPY | ETF | 134.63 | 134.65 | 134.58 | 134.58 | 233016.0 |
| 2008-06-18 08:45:00 | SPY | ETF | 134.6 | 134.67 | 134.58 | 134.65 | 277831.0 |
| 2008-06-18 08:50:00 | SPY | ETF | 134.64 | 134.68 | 134.64 | 134.68 | 92033.0 |
| 2008-06-18 08:55:00 | SPY | ETF | 134.68 | 134.71 | 134.67 | 134.68 | 214500.0 |
| 2008-06-18 09:00:00 | SPY | ETF | 134.69 | 134.69 | 134.57 | 134.57 | 165009.0 |
| 2008-06-18 09:05:00 | SPY | ETF | 134.56 | 134.65 | 134.56 | 134.64 | 46165.0 |
| 2008-06-18 09:10:00 | SPY | ETF | 134.65 | 134.67 | 134.63 | 134.64 | 45286.0 |
| 2008-06-18 09:15:00 | SPY | ETF | 134.64 | 134.69 | 134.63 | 134.67 | 55459.0 |
| 2008-06-18 09:20:00 | SPY | ETF | 134.67 | 134.69 | 134.58 | 134.63 | 351592.0 |
| 2008-06-18 09:25:00 | SPY | ETF | 134.62 | 134.73 | 134.61 | 134.71 | 512145.0 |
| 2008-06-18 09:30:00 | SPY | ETF | 134.69 | 134.79 | 134.59 | 134.61 | 4099135.0 |
| 2008-06-18 09:35:00 | SPY | ETF | 134.62 | 134.97 | 134.59 | 134.91 | 5542798.0 |
| 2008-06-18 09:40:00 | SPY | ETF | 134.91 | 135.08 | 134.85 | 135.0 | 2861513.0 |
| 2008-06-18 09:45:00 | SPY | ETF | 135.0 | 135.05 | 134.73 | 134.76 | 4929576.0 |
| 2008-06-18 09:50:00 | SPY | ETF | 134.75 | 134.8 | 134.65 | 134.72 | 3422452.0 |
| 2008-06-18 09:55:00 | SPY | ETF | 134.7 | 134.73 | 134.51 | 134.541 | 3131417.0 |
| 2008-06-18 10:00:00 | SPY | ETF | 134.55 | 134.62 | 134.45 | 134.61 | 3079341.0 |
| 2008-06-18 10:05:00 | SPY | ETF | 134.61 | 134.69 | 134.55 | 134.65 | 2402622.0 |
| 2008-06-18 10:10:00 | SPY | ETF | 134.66 | 134.68 | 134.5 | 134.58 | 2056388.0 |
| 2008-06-18 10:15:00 | SPY | ETF | 134.57 | 134.71 | 134.55 | 134.69 | 2271635.0 |
| 2008-06-18 10:20:00 | SPY | ETF | 134.7 | 134.79 | 134.58 | 134.63 | 2257134.0 |
> showing 50 of 23,341 rows — these rows as CSV