PREVIEW / etf_5min / 2013-12-20
file: by_date/etf_5min/2013/2013-12-20.parquet size: 1.0 MB rows: 44,920
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-20 04:00:00 | SPY | ETF | 180.68 | 180.94 | 180.68 | 180.75 | 2264.0 |
| 2013-12-20 04:05:00 | SPY | ETF | 180.69 | 180.74 | 180.69 | 180.74 | 1608.0 |
| 2013-12-20 04:10:00 | SPY | ETF | 180.75 | 180.75 | 180.75 | 180.75 | 234.0 |
| 2013-12-20 04:15:00 | SPY | ETF | 180.75 | 181.02 | 180.75 | 180.79 | 2578.0 |
| 2013-12-20 04:20:00 | SPY | ETF | 180.82 | 180.82 | 180.82 | 180.82 | 578.0 |
| 2013-12-20 04:30:00 | SPY | ETF | 180.87 | 180.87 | 180.87 | 180.87 | 320.0 |
| 2013-12-20 04:35:00 | SPY | ETF | 180.93 | 180.94 | 180.82 | 180.82 | 1299.0 |
| 2013-12-20 04:40:00 | SPY | ETF | 180.84 | 180.84 | 180.71 | 180.71 | 1050.0 |
| 2013-12-20 04:50:00 | SPY | ETF | 180.79 | 180.79 | 180.79 | 180.79 | 100.0 |
| 2013-12-20 05:05:00 | SPY | ETF | 180.82 | 180.82 | 180.79 | 180.79 | 520.0 |
| 2013-12-20 05:10:00 | SPY | ETF | 180.85 | 180.85 | 180.82 | 180.82 | 600.0 |
| 2013-12-20 05:15:00 | SPY | ETF | 180.79 | 180.79 | 180.79 | 180.79 | 500.0 |
| 2013-12-20 05:20:00 | SPY | ETF | 180.79 | 180.79 | 180.79 | 180.79 | 600.0 |
| 2013-12-20 05:30:00 | SPY | ETF | 180.8 | 180.8 | 180.8 | 180.8 | 700.0 |
| 2013-12-20 05:35:00 | SPY | ETF | 180.85 | 180.85 | 180.85 | 180.85 | 117.0 |
| 2013-12-20 05:40:00 | SPY | ETF | 180.79 | 180.79 | 180.79 | 180.79 | 100.0 |
| 2013-12-20 05:45:00 | SPY | ETF | 180.76 | 180.77 | 180.75 | 180.77 | 2900.0 |
| 2013-12-20 05:50:00 | SPY | ETF | 180.71 | 180.71 | 180.7 | 180.7 | 600.0 |
| 2013-12-20 05:55:00 | SPY | ETF | 180.73 | 180.73 | 180.73 | 180.73 | 100.0 |
| 2013-12-20 06:10:00 | SPY | ETF | 180.79 | 180.79 | 180.76 | 180.76 | 300.0 |
| 2013-12-20 06:25:00 | SPY | ETF | 180.79 | 180.81 | 180.79 | 180.81 | 200.0 |
| 2013-12-20 06:30:00 | SPY | ETF | 180.79 | 180.8 | 180.79 | 180.79 | 700.0 |
| 2013-12-20 06:40:00 | SPY | ETF | 180.76 | 180.76 | 180.7 | 180.7 | 2180.0 |
| 2013-12-20 06:45:00 | SPY | ETF | 180.69 | 180.71 | 180.63 | 180.63 | 6555.0 |
| 2013-12-20 06:50:00 | SPY | ETF | 180.67 | 180.67 | 180.67 | 180.67 | 205.0 |
| 2013-12-20 07:00:00 | SPY | ETF | 180.68 | 180.72 | 180.65 | 180.65 | 6849.0 |
| 2013-12-20 07:05:00 | SPY | ETF | 180.69 | 181.6 | 180.57 | 180.64 | 49885.0 |
| 2013-12-20 07:10:00 | SPY | ETF | 180.66 | 180.89 | 180.64 | 180.64 | 6073.0 |
| 2013-12-20 07:15:00 | SPY | ETF | 180.65 | 180.78 | 180.61 | 180.66 | 30960.0 |
| 2013-12-20 07:20:00 | SPY | ETF | 180.64 | 180.77 | 180.59 | 180.61 | 32559.0 |
| 2013-12-20 07:25:00 | SPY | ETF | 180.62 | 180.63 | 180.51 | 180.51 | 3655.0 |
| 2013-12-20 07:30:00 | SPY | ETF | 180.51 | 180.55 | 180.51 | 180.55 | 14075.0 |
| 2013-12-20 07:35:00 | SPY | ETF | 180.55 | 180.55 | 180.54 | 180.54 | 54900.0 |
| 2013-12-20 07:40:00 | SPY | ETF | 180.54 | 180.56 | 180.54 | 180.56 | 20715.0 |
| 2013-12-20 07:45:00 | SPY | ETF | 180.56 | 180.58 | 180.55 | 180.58 | 51300.0 |
| 2013-12-20 07:50:00 | SPY | ETF | 180.58 | 180.61 | 180.56 | 180.61 | 154296.0 |
| 2013-12-20 07:55:00 | SPY | ETF | 180.61 | 180.61 | 180.57 | 180.58 | 69200.0 |
| 2013-12-20 08:00:00 | SPY | ETF | 180.59 | 180.67 | 180.57 | 180.64 | 253537.0 |
| 2013-12-20 08:05:00 | SPY | ETF | 180.63 | 180.64 | 180.59 | 180.61 | 118685.0 |
| 2013-12-20 08:10:00 | SPY | ETF | 180.6 | 180.62 | 180.53 | 180.6 | 178077.0 |
| 2013-12-20 08:15:00 | SPY | ETF | 180.62 | 180.66 | 180.57 | 180.63 | 157895.0 |
| 2013-12-20 08:20:00 | SPY | ETF | 180.63 | 180.66 | 180.6 | 180.65 | 78887.0 |
| 2013-12-20 08:25:00 | SPY | ETF | 180.65 | 180.65 | 180.6 | 180.61 | 267820.0 |
| 2013-12-20 08:30:00 | SPY | ETF | 180.61 | 180.83 | 180.58 | 180.81 | 384360.0 |
| 2013-12-20 08:35:00 | SPY | ETF | 180.82 | 180.86 | 180.79 | 180.81 | 126146.0 |
| 2013-12-20 08:40:00 | SPY | ETF | 180.81 | 180.81 | 180.71 | 180.8 | 172144.0 |
| 2013-12-20 08:45:00 | SPY | ETF | 180.8 | 180.82 | 180.77 | 180.8 | 77666.0 |
| 2013-12-20 08:50:00 | SPY | ETF | 180.78 | 180.8 | 180.77 | 180.79 | 26522.0 |
| 2013-12-20 08:55:00 | SPY | ETF | 180.78 | 180.79 | 180.74 | 180.79 | 99102.0 |
| 2013-12-20 09:00:00 | SPY | ETF | 180.79 | 180.82 | 180.77 | 180.82 | 87237.0 |
> showing 50 of 44,920 rows — these rows as CSV