PREVIEW / etf_5min / 2008-04-11
file: by_date/etf_5min/2008/2008-04-11.parquet size: 441 KB rows: 21,335
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-04-11 04:15:00 | SPY | ETF | 136.52 | 136.52 | 136.52 | 136.52 | 1000.0 |
| 2008-04-11 05:10:00 | SPY | ETF | 136.43 | 136.43 | 136.43 | 136.43 | 100.0 |
| 2008-04-11 05:25:00 | SPY | ETF | 136.45 | 136.45 | 136.45 | 136.45 | 100.0 |
| 2008-04-11 05:30:00 | SPY | ETF | 136.39 | 136.39 | 136.36 | 136.36 | 300.0 |
| 2008-04-11 05:55:00 | SPY | ETF | 136.41 | 136.41 | 136.41 | 136.41 | 5000.0 |
| 2008-04-11 06:00:00 | SPY | ETF | 136.43 | 136.43 | 136.41 | 136.41 | 5600.0 |
| 2008-04-11 06:15:00 | SPY | ETF | 136.49 | 136.49 | 136.49 | 136.49 | 5000.0 |
| 2008-04-11 06:20:00 | SPY | ETF | 136.47 | 136.47 | 136.47 | 136.47 | 5000.0 |
| 2008-04-11 06:30:00 | SPY | ETF | 136.44 | 136.44 | 135.7 | 135.78 | 60700.0 |
| 2008-04-11 06:35:00 | SPY | ETF | 135.7 | 135.72 | 135.46 | 135.57 | 91000.0 |
| 2008-04-11 06:40:00 | SPY | ETF | 135.52 | 135.62 | 135.49 | 135.53 | 220300.0 |
| 2008-04-11 06:45:00 | SPY | ETF | 135.51 | 135.51 | 135.35 | 135.37 | 70300.0 |
| 2008-04-11 06:50:00 | SPY | ETF | 135.43 | 135.45 | 135.2 | 135.26 | 120400.0 |
| 2008-04-11 06:55:00 | SPY | ETF | 135.23 | 135.38 | 135.2 | 135.28 | 146800.0 |
| 2008-04-11 07:00:00 | SPY | ETF | 135.35 | 135.35 | 135.23 | 135.27 | 140300.0 |
| 2008-04-11 07:05:00 | SPY | ETF | 135.27 | 135.28 | 135.16 | 135.24 | 85200.0 |
| 2008-04-11 07:10:00 | SPY | ETF | 135.17 | 135.18 | 134.98 | 135.18 | 619800.0 |
| 2008-04-11 07:15:00 | SPY | ETF | 135.12 | 135.17 | 135.0 | 135.11 | 162800.0 |
| 2008-04-11 07:20:00 | SPY | ETF | 135.11 | 135.15 | 135.0 | 135.01 | 71100.0 |
| 2008-04-11 07:25:00 | SPY | ETF | 135.0 | 135.03 | 134.65 | 134.81 | 360100.0 |
| 2008-04-11 07:30:00 | SPY | ETF | 134.82 | 135.04 | 134.8 | 134.91 | 180300.0 |
| 2008-04-11 07:35:00 | SPY | ETF | 134.9 | 135.13 | 134.9 | 135.13 | 67000.0 |
| 2008-04-11 07:40:00 | SPY | ETF | 135.12 | 135.2 | 134.93 | 134.93 | 362200.0 |
| 2008-04-11 07:45:00 | SPY | ETF | 134.99 | 135.01 | 134.78 | 134.92 | 154900.0 |
| 2008-04-11 07:50:00 | SPY | ETF | 134.95 | 135.0 | 134.81 | 134.95 | 99700.0 |
| 2008-04-11 07:55:00 | SPY | ETF | 134.95 | 135.03 | 134.9 | 134.96 | 183300.0 |
| 2008-04-11 08:00:00 | SPY | ETF | 134.96 | 135.5 | 134.8 | 134.92 | 2911600.0 |
| 2008-04-11 08:05:00 | SPY | ETF | 134.94 | 134.95 | 134.82 | 134.83 | 105067.0 |
| 2008-04-11 08:10:00 | SPY | ETF | 134.8 | 134.81 | 134.57 | 134.63 | 700400.0 |
| 2008-04-11 08:15:00 | SPY | ETF | 134.65 | 135.73 | 134.6 | 134.6 | 409319.0 |
| 2008-04-11 08:20:00 | SPY | ETF | 134.6 | 134.63 | 134.5 | 134.51 | 1198781.0 |
| 2008-04-11 08:25:00 | SPY | ETF | 134.5 | 134.55 | 134.45 | 134.48 | 971575.0 |
| 2008-04-11 08:30:00 | SPY | ETF | 134.5 | 134.61 | 134.36 | 134.6 | 601764.0 |
| 2008-04-11 08:35:00 | SPY | ETF | 134.61 | 134.68 | 134.56 | 134.56 | 299200.0 |
| 2008-04-11 08:40:00 | SPY | ETF | 134.58 | 134.69 | 134.56 | 134.66 | 81900.0 |
| 2008-04-11 08:45:00 | SPY | ETF | 134.7 | 134.7 | 134.54 | 134.55 | 175300.0 |
| 2008-04-11 08:50:00 | SPY | ETF | 134.54 | 134.55 | 134.45 | 134.55 | 138600.0 |
| 2008-04-11 08:55:00 | SPY | ETF | 134.56 | 134.64 | 134.52 | 134.55 | 284500.0 |
| 2008-04-11 09:00:00 | SPY | ETF | 134.56 | 134.63 | 134.55 | 134.62 | 196700.0 |
| 2008-04-11 09:05:00 | SPY | ETF | 134.62 | 134.63 | 134.53 | 134.57 | 154400.0 |
| 2008-04-11 09:10:00 | SPY | ETF | 134.56 | 134.6 | 134.43 | 134.44 | 679889.0 |
| 2008-04-11 09:15:00 | SPY | ETF | 134.44 | 134.47 | 134.41 | 134.42 | 114100.0 |
| 2008-04-11 09:20:00 | SPY | ETF | 134.42 | 134.46 | 134.37 | 134.44 | 181900.0 |
| 2008-04-11 09:25:00 | SPY | ETF | 134.44 | 134.47 | 134.38 | 134.47 | 198500.0 |
| 2008-04-11 09:30:00 | SPY | ETF | 134.48 | 134.6 | 134.35 | 134.49 | 2791199.0 |
| 2008-04-11 09:35:00 | SPY | ETF | 134.48 | 134.64 | 134.29 | 134.33 | 5789274.0 |
| 2008-04-11 09:40:00 | SPY | ETF | 134.34 | 134.5901 | 134.32 | 134.36 | 3486904.0 |
| 2008-04-11 09:45:00 | SPY | ETF | 134.36 | 134.63 | 134.29 | 134.62 | 3385110.0 |
| 2008-04-11 09:50:00 | SPY | ETF | 134.61 | 134.7 | 134.51 | 134.67 | 3728825.0 |
| 2008-04-11 09:55:00 | SPY | ETF | 134.688 | 134.688 | 134.31 | 134.4 | 8467217.0 |
> showing 50 of 21,335 rows — these rows as CSV