PREVIEW / etf_5min / 2010-08-03
file: by_date/etf_5min/2010/2010-08-03.parquet size: 756 KB rows: 33,535
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-03 04:00:00 | SPY | ETF | 112.52 | 112.52 | 112.37 | 112.4 | 22900.0 |
| 2010-08-03 04:05:00 | SPY | ETF | 112.48 | 112.49 | 112.48 | 112.49 | 200.0 |
| 2010-08-03 04:25:00 | SPY | ETF | 112.47 | 112.47 | 112.47 | 112.47 | 200.0 |
| 2010-08-03 04:35:00 | SPY | ETF | 112.44 | 112.44 | 112.44 | 112.44 | 100.0 |
| 2010-08-03 04:55:00 | SPY | ETF | 112.47 | 112.47 | 112.47 | 112.47 | 1000.0 |
| 2010-08-03 05:10:00 | SPY | ETF | 112.5 | 112.5 | 112.5 | 112.5 | 100.0 |
| 2010-08-03 05:30:00 | SPY | ETF | 112.5 | 112.5 | 112.5 | 112.5 | 200.0 |
| 2010-08-03 05:35:00 | SPY | ETF | 112.58 | 112.6 | 112.58 | 112.6 | 300.0 |
| 2010-08-03 05:40:00 | SPY | ETF | 112.55 | 112.55 | 112.55 | 112.55 | 100.0 |
| 2010-08-03 05:45:00 | SPY | ETF | 112.55 | 112.55 | 112.5 | 112.5 | 1856.0 |
| 2010-08-03 06:00:00 | SPY | ETF | 112.62 | 112.62 | 112.62 | 112.62 | 100.0 |
| 2010-08-03 06:05:00 | SPY | ETF | 112.65 | 112.65 | 112.65 | 112.65 | 100.0 |
| 2010-08-03 06:10:00 | SPY | ETF | 112.67 | 112.67 | 112.67 | 112.67 | 100.0 |
| 2010-08-03 06:15:00 | SPY | ETF | 112.72 | 112.72 | 112.7 | 112.7 | 650.0 |
| 2010-08-03 06:20:00 | SPY | ETF | 112.7 | 112.7 | 112.68 | 112.68 | 2800.0 |
| 2010-08-03 06:30:00 | SPY | ETF | 112.68 | 112.68 | 112.65 | 112.65 | 2300.0 |
| 2010-08-03 06:35:00 | SPY | ETF | 112.6 | 112.6 | 112.57 | 112.57 | 3200.0 |
| 2010-08-03 06:40:00 | SPY | ETF | 112.57 | 112.57 | 112.57 | 112.57 | 1025.0 |
| 2010-08-03 06:45:00 | SPY | ETF | 112.63 | 112.63 | 112.63 | 112.63 | 100.0 |
| 2010-08-03 06:55:00 | SPY | ETF | 112.57 | 112.57 | 112.52 | 112.52 | 4100.0 |
| 2010-08-03 07:00:00 | SPY | ETF | 112.52 | 112.59 | 112.51 | 112.56 | 87600.0 |
| 2010-08-03 07:05:00 | SPY | ETF | 112.57 | 112.59 | 112.55 | 112.55 | 22900.0 |
| 2010-08-03 07:10:00 | SPY | ETF | 112.55 | 112.55 | 112.45 | 112.45 | 42400.0 |
| 2010-08-03 07:15:00 | SPY | ETF | 112.42 | 112.42 | 112.35 | 112.39 | 20300.0 |
| 2010-08-03 07:20:00 | SPY | ETF | 112.39 | 112.39 | 112.31 | 112.32 | 18000.0 |
| 2010-08-03 07:25:00 | SPY | ETF | 112.34 | 112.37 | 112.31 | 112.34 | 28100.0 |
| 2010-08-03 07:30:00 | SPY | ETF | 112.36 | 112.39 | 112.35 | 112.36 | 37600.0 |
| 2010-08-03 07:35:00 | SPY | ETF | 112.36 | 112.49 | 112.36 | 112.49 | 83580.0 |
| 2010-08-03 07:40:00 | SPY | ETF | 112.46 | 112.47 | 112.43 | 112.47 | 700.0 |
| 2010-08-03 07:45:00 | SPY | ETF | 112.48 | 112.49 | 112.43 | 112.48 | 58250.0 |
| 2010-08-03 07:50:00 | SPY | ETF | 112.47 | 112.47 | 112.43 | 112.43 | 34825.0 |
| 2010-08-03 07:55:00 | SPY | ETF | 112.47 | 112.52 | 112.46 | 112.51 | 117812.0 |
| 2010-08-03 08:00:00 | SPY | ETF | 112.52 | 112.6 | 112.35 | 112.58 | 78246.0 |
| 2010-08-03 08:05:00 | SPY | ETF | 112.58 | 112.59 | 112.51 | 112.52 | 137182.0 |
| 2010-08-03 08:10:00 | SPY | ETF | 112.52 | 112.54 | 112.5 | 112.52 | 62200.0 |
| 2010-08-03 08:15:00 | SPY | ETF | 112.52 | 112.54 | 112.5 | 112.52 | 133550.0 |
| 2010-08-03 08:20:00 | SPY | ETF | 112.52 | 112.54 | 112.48 | 112.5 | 55796.0 |
| 2010-08-03 08:25:00 | SPY | ETF | 112.49 | 112.51 | 112.48 | 112.48 | 68750.0 |
| 2010-08-03 08:30:00 | SPY | ETF | 112.45 | 112.5 | 112.32 | 112.45 | 309360.0 |
| 2010-08-03 08:35:00 | SPY | ETF | 112.44 | 112.47 | 112.41 | 112.43 | 149043.0 |
| 2010-08-03 08:40:00 | SPY | ETF | 112.42 | 112.54 | 112.42 | 112.54 | 157837.0 |
| 2010-08-03 08:45:00 | SPY | ETF | 112.55 | 112.55 | 112.49 | 112.51 | 51618.0 |
| 2010-08-03 08:50:00 | SPY | ETF | 112.52 | 112.64 | 112.5 | 112.62 | 124321.0 |
| 2010-08-03 08:55:00 | SPY | ETF | 112.63 | 112.64 | 112.57 | 112.59 | 163847.0 |
| 2010-08-03 09:00:00 | SPY | ETF | 112.59 | 112.59 | 112.42 | 112.42 | 74268.0 |
| 2010-08-03 09:05:00 | SPY | ETF | 112.53 | 112.54 | 112.44 | 112.46 | 82274.0 |
| 2010-08-03 09:10:00 | SPY | ETF | 112.47 | 112.48 | 112.43 | 112.47 | 140118.0 |
| 2010-08-03 09:15:00 | SPY | ETF | 112.47 | 112.47 | 112.42 | 112.46 | 89961.0 |
| 2010-08-03 09:20:00 | SPY | ETF | 112.45 | 112.47 | 112.42 | 112.45 | 182233.0 |
| 2010-08-03 09:25:00 | SPY | ETF | 112.45 | 112.48 | 112.39 | 112.47 | 178009.0 |
> showing 50 of 33,535 rows — these rows as CSV