PREVIEW / etf_5min / 2010-06-03
file: by_date/etf_5min/2010/2010-06-03.parquet size: 792 KB rows: 33,127
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-06-03 04:15:00 | SPY | ETF | 110.87 | 110.93 | 110.87 | 110.87 | 4000.0 |
| 2010-06-03 04:20:00 | SPY | ETF | 110.92 | 110.92 | 110.92 | 110.92 | 500.0 |
| 2010-06-03 04:25:00 | SPY | ETF | 110.85 | 110.85 | 110.84 | 110.84 | 3100.0 |
| 2010-06-03 04:30:00 | SPY | ETF | 110.84 | 110.84 | 110.83 | 110.83 | 200.0 |
| 2010-06-03 04:40:00 | SPY | ETF | 110.87 | 110.87 | 110.87 | 110.87 | 100.0 |
| 2010-06-03 04:45:00 | SPY | ETF | 110.92 | 110.94 | 110.92 | 110.94 | 200.0 |
| 2010-06-03 04:50:00 | SPY | ETF | 110.94 | 110.95 | 110.94 | 110.95 | 3000.0 |
| 2010-06-03 04:55:00 | SPY | ETF | 110.9 | 110.9 | 110.9 | 110.9 | 200.0 |
| 2010-06-03 05:10:00 | SPY | ETF | 110.83 | 110.83 | 110.75 | 110.75 | 1300.0 |
| 2010-06-03 05:15:00 | SPY | ETF | 110.7 | 110.7 | 110.7 | 110.7 | 100.0 |
| 2010-06-03 05:20:00 | SPY | ETF | 110.74 | 110.8 | 110.74 | 110.8 | 1600.0 |
| 2010-06-03 05:35:00 | SPY | ETF | 110.8 | 110.84 | 110.8 | 110.84 | 200.0 |
| 2010-06-03 05:40:00 | SPY | ETF | 110.85 | 110.85 | 110.82 | 110.82 | 4500.0 |
| 2010-06-03 05:45:00 | SPY | ETF | 110.82 | 110.82 | 110.82 | 110.82 | 605.0 |
| 2010-06-03 05:50:00 | SPY | ETF | 110.82 | 110.83 | 110.82 | 110.83 | 5395.0 |
| 2010-06-03 06:00:00 | SPY | ETF | 110.83 | 110.83 | 110.79 | 110.79 | 5100.0 |
| 2010-06-03 06:15:00 | SPY | ETF | 110.58 | 110.58 | 110.58 | 110.58 | 5576.0 |
| 2010-06-03 06:20:00 | SPY | ETF | 110.6 | 110.6 | 110.58 | 110.59 | 5000.0 |
| 2010-06-03 06:30:00 | SPY | ETF | 110.62 | 110.62 | 110.62 | 110.62 | 100.0 |
| 2010-06-03 06:35:00 | SPY | ETF | 110.63 | 110.64 | 110.63 | 110.64 | 3200.0 |
| 2010-06-03 06:40:00 | SPY | ETF | 110.67 | 110.7 | 110.66 | 110.7 | 5000.0 |
| 2010-06-03 06:50:00 | SPY | ETF | 110.6 | 110.6 | 110.6 | 110.6 | 1220.0 |
| 2010-06-03 06:55:00 | SPY | ETF | 110.51 | 110.51 | 110.45 | 110.45 | 2700.0 |
| 2010-06-03 07:00:00 | SPY | ETF | 110.47 | 110.56 | 110.47 | 110.56 | 4300.0 |
| 2010-06-03 07:05:00 | SPY | ETF | 110.57 | 110.59 | 110.51 | 110.51 | 17260.0 |
| 2010-06-03 07:10:00 | SPY | ETF | 110.56 | 110.58 | 110.55 | 110.55 | 35600.0 |
| 2010-06-03 07:15:00 | SPY | ETF | 110.57 | 110.67 | 110.54 | 110.64 | 21600.0 |
| 2010-06-03 07:20:00 | SPY | ETF | 110.61 | 110.66 | 110.54 | 110.55 | 245218.0 |
| 2010-06-03 07:25:00 | SPY | ETF | 110.54 | 110.54 | 110.41 | 110.45 | 107474.0 |
| 2010-06-03 07:30:00 | SPY | ETF | 110.45 | 110.57 | 110.45 | 110.57 | 156113.0 |
| 2010-06-03 07:35:00 | SPY | ETF | 110.57 | 110.62 | 110.55 | 110.61 | 69668.0 |
| 2010-06-03 07:40:00 | SPY | ETF | 110.58 | 110.61 | 110.54 | 110.61 | 58705.0 |
| 2010-06-03 07:45:00 | SPY | ETF | 110.55 | 110.65 | 110.45 | 110.65 | 689100.0 |
| 2010-06-03 07:50:00 | SPY | ETF | 110.6 | 110.67 | 110.6 | 110.62 | 29575.0 |
| 2010-06-03 07:55:00 | SPY | ETF | 110.62 | 110.62 | 110.55 | 110.59 | 195230.0 |
| 2010-06-03 08:00:00 | SPY | ETF | 110.55 | 110.59 | 110.49 | 110.59 | 104502.0 |
| 2010-06-03 08:05:00 | SPY | ETF | 110.6 | 110.6 | 110.54 | 110.57 | 1232250.0 |
| 2010-06-03 08:10:00 | SPY | ETF | 110.56 | 110.65 | 110.53 | 110.59 | 182019.0 |
| 2010-06-03 08:15:00 | SPY | ETF | 110.58 | 110.6 | 110.35 | 110.55 | 292538.0 |
| 2010-06-03 08:20:00 | SPY | ETF | 110.55 | 110.7 | 110.53 | 110.64 | 158080.0 |
| 2010-06-03 08:25:00 | SPY | ETF | 110.65 | 110.7 | 110.54 | 110.65 | 115603.0 |
| 2010-06-03 08:30:00 | SPY | ETF | 110.67 | 110.7 | 110.56 | 110.65 | 254830.0 |
| 2010-06-03 08:35:00 | SPY | ETF | 110.67 | 110.67 | 110.53 | 110.54 | 102068.0 |
| 2010-06-03 08:40:00 | SPY | ETF | 110.55 | 110.64 | 110.54 | 110.63 | 47003.0 |
| 2010-06-03 08:45:00 | SPY | ETF | 110.63 | 110.8 | 110.63 | 110.74 | 216265.0 |
| 2010-06-03 08:50:00 | SPY | ETF | 110.75 | 110.79 | 110.66 | 110.68 | 745592.0 |
| 2010-06-03 08:55:00 | SPY | ETF | 110.68 | 110.74 | 110.66 | 110.7 | 718047.0 |
| 2010-06-03 09:00:00 | SPY | ETF | 110.71 | 110.71 | 110.64 | 110.66 | 71644.0 |
| 2010-06-03 09:05:00 | SPY | ETF | 110.67 | 110.7 | 110.6 | 110.66 | 64724.0 |
| 2010-06-03 09:10:00 | SPY | ETF | 110.68 | 110.74 | 110.62 | 110.71 | 134561.0 |
> showing 50 of 33,127 rows — these rows as CSV