PREVIEW / etf_5min / 2013-03-04
file: by_date/etf_5min/2013/2013-03-04.parquet size: 948 KB rows: 40,611
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-03-04 04:00:00 | SPY | ETF | 151.53 | 151.56 | 151.53 | 151.55 | 1920.0 |
| 2013-03-04 04:05:00 | SPY | ETF | 151.54 | 151.54 | 151.54 | 151.54 | 68700.0 |
| 2013-03-04 04:15:00 | SPY | ETF | 151.65 | 151.65 | 151.65 | 151.65 | 100.0 |
| 2013-03-04 04:20:00 | SPY | ETF | 151.69 | 151.69 | 151.69 | 151.69 | 3000.0 |
| 2013-03-04 04:30:00 | SPY | ETF | 151.68 | 151.68 | 151.61 | 151.61 | 5700.0 |
| 2013-03-04 04:45:00 | SPY | ETF | 151.56 | 151.56 | 151.54 | 151.56 | 5100.0 |
| 2013-03-04 04:55:00 | SPY | ETF | 151.6 | 151.6 | 151.6 | 151.6 | 400.0 |
| 2013-03-04 05:00:00 | SPY | ETF | 151.59 | 151.59 | 151.59 | 151.59 | 700.0 |
| 2013-03-04 05:10:00 | SPY | ETF | 151.51 | 151.51 | 151.49 | 151.5 | 775.0 |
| 2013-03-04 05:15:00 | SPY | ETF | 151.56 | 151.56 | 151.56 | 151.56 | 273.0 |
| 2013-03-04 05:30:00 | SPY | ETF | 151.69 | 151.69 | 151.69 | 151.69 | 11383.0 |
| 2013-03-04 05:35:00 | SPY | ETF | 151.69 | 151.69 | 151.69 | 151.69 | 267.0 |
| 2013-03-04 05:40:00 | SPY | ETF | 151.69 | 151.69 | 151.69 | 151.69 | 300.0 |
| 2013-03-04 05:45:00 | SPY | ETF | 151.66 | 151.66 | 151.66 | 151.66 | 500.0 |
| 2013-03-04 05:50:00 | SPY | ETF | 151.62 | 151.62 | 151.56 | 151.56 | 500.0 |
| 2013-03-04 06:00:00 | SPY | ETF | 151.54 | 151.59 | 151.54 | 151.59 | 800.0 |
| 2013-03-04 06:05:00 | SPY | ETF | 151.56 | 151.57 | 151.56 | 151.57 | 1200.0 |
| 2013-03-04 06:10:00 | SPY | ETF | 151.57 | 151.57 | 151.57 | 151.57 | 1280.0 |
| 2013-03-04 06:15:00 | SPY | ETF | 151.57 | 151.57 | 151.47 | 151.47 | 2900.0 |
| 2013-03-04 06:20:00 | SPY | ETF | 151.45 | 151.5 | 151.42 | 151.42 | 3200.0 |
| 2013-03-04 06:25:00 | SPY | ETF | 151.41 | 151.46 | 151.36 | 151.42 | 8299.0 |
| 2013-03-04 06:30:00 | SPY | ETF | 151.4 | 151.42 | 151.39 | 151.42 | 5500.0 |
| 2013-03-04 06:35:00 | SPY | ETF | 151.45 | 151.45 | 151.45 | 151.45 | 3000.0 |
| 2013-03-04 06:40:00 | SPY | ETF | 151.49 | 151.54 | 151.49 | 151.54 | 1000.0 |
| 2013-03-04 06:50:00 | SPY | ETF | 151.58 | 151.58 | 151.58 | 151.58 | 100.0 |
| 2013-03-04 06:55:00 | SPY | ETF | 151.62 | 151.63 | 151.6 | 151.6 | 1700.0 |
| 2013-03-04 07:00:00 | SPY | ETF | 151.63 | 151.63 | 151.59 | 151.6 | 31370.0 |
| 2013-03-04 07:05:00 | SPY | ETF | 151.59 | 151.63 | 151.59 | 151.63 | 4300.0 |
| 2013-03-04 07:10:00 | SPY | ETF | 151.62 | 151.62 | 151.55 | 151.55 | 10000.0 |
| 2013-03-04 07:15:00 | SPY | ETF | 151.56 | 151.6 | 151.53 | 151.6 | 53992.0 |
| 2013-03-04 07:20:00 | SPY | ETF | 151.58 | 151.71 | 151.58 | 151.69 | 103800.0 |
| 2013-03-04 07:25:00 | SPY | ETF | 151.73 | 151.74 | 151.69 | 151.74 | 17200.0 |
| 2013-03-04 07:30:00 | SPY | ETF | 151.77 | 151.94 | 151.77 | 151.93 | 43101.0 |
| 2013-03-04 07:35:00 | SPY | ETF | 151.93 | 152.03 | 151.92 | 152.02 | 89150.0 |
| 2013-03-04 07:40:00 | SPY | ETF | 152.02 | 152.08 | 151.96 | 151.96 | 128300.0 |
| 2013-03-04 07:45:00 | SPY | ETF | 151.98 | 151.98 | 151.85 | 151.85 | 64097.0 |
| 2013-03-04 07:50:00 | SPY | ETF | 151.86 | 151.92 | 151.86 | 151.88 | 40500.0 |
| 2013-03-04 07:55:00 | SPY | ETF | 151.87 | 151.94 | 151.85 | 151.92 | 79200.0 |
| 2013-03-04 08:00:00 | SPY | ETF | 151.6 | 151.95 | 151.59 | 151.88 | 20368.0 |
| 2013-03-04 08:05:00 | SPY | ETF | 151.87 | 151.9 | 151.46 | 151.88 | 430161.0 |
| 2013-03-04 08:10:00 | SPY | ETF | 151.87 | 151.91 | 151.87 | 151.88 | 8850.0 |
| 2013-03-04 08:15:00 | SPY | ETF | 151.87 | 151.87 | 151.82 | 151.84 | 47702.0 |
| 2013-03-04 08:20:00 | SPY | ETF | 151.84 | 151.89 | 151.795 | 151.88 | 35085.0 |
| 2013-03-04 08:25:00 | SPY | ETF | 151.87 | 151.99 | 151.87 | 151.97 | 40870.0 |
| 2013-03-04 08:30:00 | SPY | ETF | 151.95 | 151.97 | 151.94 | 151.96 | 51550.0 |
| 2013-03-04 08:35:00 | SPY | ETF | 151.97 | 152.0 | 151.89 | 151.92 | 123025.0 |
| 2013-03-04 08:40:00 | SPY | ETF | 151.92 | 151.96 | 151.9 | 151.96 | 48588.0 |
| 2013-03-04 08:45:00 | SPY | ETF | 151.97 | 152.01 | 151.92 | 151.92 | 40305.0 |
| 2013-03-04 08:50:00 | SPY | ETF | 151.92 | 151.92 | 151.83 | 151.89 | 81181.0 |
| 2013-03-04 08:55:00 | SPY | ETF | 151.88 | 151.88 | 151.84 | 151.85 | 30401.0 |
> showing 50 of 40,611 rows — these rows as CSV