PREVIEW / etf_5min / 2012-10-12
file: by_date/etf_5min/2012/2012-10-12.parquet size: 801 KB rows: 33,176
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-12 04:00:00 | SPY | ETF | 143.84 | 143.84 | 143.84 | 143.84 | 100.0 |
| 2012-10-12 04:05:00 | SPY | ETF | 143.83 | 143.83 | 143.83 | 143.83 | 100.0 |
| 2012-10-12 04:10:00 | SPY | ETF | 143.86 | 143.86 | 143.86 | 143.86 | 100.0 |
| 2012-10-12 04:15:00 | SPY | ETF | 143.81 | 143.81 | 143.81 | 143.81 | 100.0 |
| 2012-10-12 04:25:00 | SPY | ETF | 143.67 | 143.67 | 143.67 | 143.67 | 200.0 |
| 2012-10-12 04:30:00 | SPY | ETF | 143.68 | 143.68 | 143.68 | 143.68 | 100.0 |
| 2012-10-12 05:00:00 | SPY | ETF | 143.77 | 143.8 | 143.77 | 143.8 | 3575.0 |
| 2012-10-12 05:05:00 | SPY | ETF | 143.69 | 143.69 | 143.64 | 143.64 | 15000.0 |
| 2012-10-12 05:25:00 | SPY | ETF | 143.58 | 143.58 | 143.58 | 143.58 | 100.0 |
| 2012-10-12 05:40:00 | SPY | ETF | 143.72 | 143.72 | 143.67 | 143.67 | 10100.0 |
| 2012-10-12 05:45:00 | SPY | ETF | 143.66 | 143.66 | 143.66 | 143.66 | 10100.0 |
| 2012-10-12 05:50:00 | SPY | ETF | 143.69 | 143.72 | 143.69 | 143.72 | 200.0 |
| 2012-10-12 06:05:00 | SPY | ETF | 143.68 | 143.72 | 143.68 | 143.72 | 200.0 |
| 2012-10-12 06:10:00 | SPY | ETF | 143.69 | 143.72 | 143.69 | 143.72 | 26000.0 |
| 2012-10-12 06:15:00 | SPY | ETF | 143.76 | 143.79 | 143.76 | 143.79 | 11100.0 |
| 2012-10-12 06:20:00 | SPY | ETF | 143.78 | 143.79 | 143.77 | 143.79 | 71500.0 |
| 2012-10-12 06:25:00 | SPY | ETF | 143.81 | 143.81 | 143.8 | 143.8 | 5400.0 |
| 2012-10-12 06:30:00 | SPY | ETF | 143.81 | 143.81 | 143.78 | 143.78 | 5100.0 |
| 2012-10-12 06:40:00 | SPY | ETF | 143.82 | 143.82 | 143.82 | 143.82 | 2500.0 |
| 2012-10-12 06:45:00 | SPY | ETF | 143.78 | 143.83 | 143.78 | 143.83 | 32600.0 |
| 2012-10-12 06:50:00 | SPY | ETF | 143.84 | 143.84 | 143.84 | 143.84 | 258.0 |
| 2012-10-12 06:55:00 | SPY | ETF | 143.8 | 143.94 | 143.8 | 143.89 | 117375.0 |
| 2012-10-12 07:00:00 | SPY | ETF | 143.89 | 143.9 | 143.75 | 143.76 | 32738.0 |
| 2012-10-12 07:05:00 | SPY | ETF | 143.76 | 143.86 | 143.75 | 143.86 | 24997.0 |
| 2012-10-12 07:10:00 | SPY | ETF | 143.88 | 143.88 | 143.78 | 143.78 | 6453.0 |
| 2012-10-12 07:15:00 | SPY | ETF | 143.79 | 143.79 | 143.78 | 143.78 | 25000.0 |
| 2012-10-12 07:20:00 | SPY | ETF | 143.76 | 143.76 | 143.76 | 143.76 | 300.0 |
| 2012-10-12 07:25:00 | SPY | ETF | 143.76 | 143.8 | 143.76 | 143.8 | 1500.0 |
| 2012-10-12 07:30:00 | SPY | ETF | 143.83 | 143.91 | 143.82 | 143.87 | 52400.0 |
| 2012-10-12 07:35:00 | SPY | ETF | 143.84 | 143.84 | 143.75 | 143.77 | 7050.0 |
| 2012-10-12 07:40:00 | SPY | ETF | 143.77 | 143.84 | 143.74 | 143.84 | 60600.0 |
| 2012-10-12 07:45:00 | SPY | ETF | 143.84 | 143.87 | 143.84 | 143.87 | 4735.0 |
| 2012-10-12 07:50:00 | SPY | ETF | 143.88 | 143.88 | 143.86 | 143.88 | 4200.0 |
| 2012-10-12 07:55:00 | SPY | ETF | 143.89 | 144.02 | 143.89 | 144.01 | 152521.0 |
| 2012-10-12 08:00:00 | SPY | ETF | 144.01 | 144.01 | 143.9 | 143.91 | 55731.0 |
| 2012-10-12 08:05:00 | SPY | ETF | 143.93 | 143.93 | 143.86 | 143.88 | 79474.0 |
| 2012-10-12 08:10:00 | SPY | ETF | 143.87 | 143.89 | 143.84 | 143.84 | 27802.0 |
| 2012-10-12 08:15:00 | SPY | ETF | 143.83 | 143.9 | 143.83 | 143.89 | 47924.0 |
| 2012-10-12 08:20:00 | SPY | ETF | 143.88 | 143.88 | 143.81 | 143.87 | 87220.0 |
| 2012-10-12 08:25:00 | SPY | ETF | 143.85 | 143.86 | 143.78 | 143.78 | 124552.0 |
| 2012-10-12 08:30:00 | SPY | ETF | 143.8 | 143.82 | 143.7 | 143.82 | 209428.0 |
| 2012-10-12 08:35:00 | SPY | ETF | 143.82 | 143.82 | 143.69 | 143.77 | 129374.0 |
| 2012-10-12 08:40:00 | SPY | ETF | 143.75 | 143.76 | 143.65 | 143.69 | 131303.0 |
| 2012-10-12 08:45:00 | SPY | ETF | 143.69 | 143.76 | 143.63 | 143.64 | 145564.0 |
| 2012-10-12 08:50:00 | SPY | ETF | 143.66 | 143.78 | 143.66 | 143.76 | 152944.0 |
| 2012-10-12 08:55:00 | SPY | ETF | 143.75 | 143.78 | 143.68 | 143.71 | 243131.0 |
| 2012-10-12 09:00:00 | SPY | ETF | 143.69 | 143.69 | 143.57 | 143.57 | 96653.0 |
| 2012-10-12 09:05:00 | SPY | ETF | 143.57 | 143.6 | 143.46 | 143.46 | 176905.0 |
| 2012-10-12 09:10:00 | SPY | ETF | 143.49 | 143.55 | 143.47 | 143.49 | 93899.0 |
| 2012-10-12 09:15:00 | SPY | ETF | 143.49 | 143.54 | 143.48 | 143.54 | 143303.0 |
> showing 50 of 33,176 rows — these rows as CSV