PREVIEW / etf_5min / 2014-06-17
file: by_date/etf_5min/2014/2014-06-17.parquet size: 957 KB rows: 41,359
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-17 04:00:00 | SPY | ETF | 194.75 | 194.75 | 194.75 | 194.75 | 100.0 |
| 2014-06-17 04:05:00 | SPY | ETF | 194.77 | 194.77 | 194.77 | 194.77 | 200.0 |
| 2014-06-17 04:10:00 | SPY | ETF | 194.85 | 194.85 | 194.85 | 194.85 | 100.0 |
| 2014-06-17 05:10:00 | SPY | ETF | 194.66 | 194.66 | 194.66 | 194.66 | 247.0 |
| 2014-06-17 05:20:00 | SPY | ETF | 194.8 | 194.8 | 194.8 | 194.8 | 100.0 |
| 2014-06-17 05:25:00 | SPY | ETF | 194.8 | 194.8 | 194.8 | 194.8 | 2706.0 |
| 2014-06-17 05:35:00 | SPY | ETF | 194.72 | 194.79 | 194.72 | 194.79 | 7900.0 |
| 2014-06-17 05:40:00 | SPY | ETF | 194.72 | 194.72 | 194.72 | 194.72 | 410.0 |
| 2014-06-17 05:45:00 | SPY | ETF | 194.68 | 194.68 | 194.68 | 194.68 | 617.0 |
| 2014-06-17 05:50:00 | SPY | ETF | 194.71 | 194.71 | 194.71 | 194.71 | 3000.0 |
| 2014-06-17 05:55:00 | SPY | ETF | 194.67 | 194.67 | 194.6 | 194.6 | 1800.0 |
| 2014-06-17 06:00:00 | SPY | ETF | 194.56 | 194.6 | 194.56 | 194.6 | 909.0 |
| 2014-06-17 06:05:00 | SPY | ETF | 194.56 | 194.56 | 194.56 | 194.56 | 404.0 |
| 2014-06-17 06:10:00 | SPY | ETF | 194.53 | 194.56 | 194.52 | 194.56 | 900.0 |
| 2014-06-17 06:15:00 | SPY | ETF | 194.55 | 194.55 | 194.43 | 194.44 | 41911.0 |
| 2014-06-17 06:20:00 | SPY | ETF | 194.4 | 194.4 | 194.36 | 194.4 | 2000.0 |
| 2014-06-17 06:25:00 | SPY | ETF | 194.36 | 194.36 | 194.36 | 194.36 | 521.0 |
| 2014-06-17 06:30:00 | SPY | ETF | 194.36 | 194.39 | 194.33 | 194.39 | 700.0 |
| 2014-06-17 06:35:00 | SPY | ETF | 194.35 | 194.37 | 194.35 | 194.37 | 1212.0 |
| 2014-06-17 06:40:00 | SPY | ETF | 194.34 | 194.34 | 194.34 | 194.34 | 1420.0 |
| 2014-06-17 06:45:00 | SPY | ETF | 194.35 | 194.35 | 194.33 | 194.33 | 1400.0 |
| 2014-06-17 06:50:00 | SPY | ETF | 194.32 | 194.37 | 194.32 | 194.32 | 25574.0 |
| 2014-06-17 06:55:00 | SPY | ETF | 194.33 | 194.33 | 194.33 | 194.33 | 230.0 |
| 2014-06-17 07:00:00 | SPY | ETF | 194.32 | 194.39 | 194.32 | 194.39 | 3400.0 |
| 2014-06-17 07:05:00 | SPY | ETF | 194.4 | 194.49 | 194.39 | 194.49 | 54350.0 |
| 2014-06-17 07:15:00 | SPY | ETF | 194.48 | 194.58 | 194.48 | 194.58 | 4088.0 |
| 2014-06-17 07:20:00 | SPY | ETF | 194.58 | 194.61 | 194.55 | 194.57 | 55504.0 |
| 2014-06-17 07:25:00 | SPY | ETF | 194.57 | 194.63 | 194.57 | 194.63 | 27100.0 |
| 2014-06-17 07:30:00 | SPY | ETF | 194.6 | 194.63 | 194.6 | 194.62 | 26549.0 |
| 2014-06-17 07:35:00 | SPY | ETF | 194.61 | 194.61 | 194.55 | 194.57 | 20706.0 |
| 2014-06-17 07:40:00 | SPY | ETF | 194.55 | 194.55 | 194.53 | 194.53 | 2706.0 |
| 2014-06-17 07:45:00 | SPY | ETF | 194.52 | 194.56 | 194.52 | 194.53 | 1896.0 |
| 2014-06-17 07:50:00 | SPY | ETF | 194.54 | 194.54 | 194.52 | 194.53 | 4365.0 |
| 2014-06-17 08:00:00 | SPY | ETF | 194.52 | 194.65 | 194.51 | 194.53 | 19762.0 |
| 2014-06-17 08:05:00 | SPY | ETF | 194.635 | 194.635 | 194.53 | 194.54 | 31200.0 |
| 2014-06-17 08:10:00 | SPY | ETF | 194.53 | 194.53 | 194.5 | 194.5 | 22919.0 |
| 2014-06-17 08:15:00 | SPY | ETF | 194.5 | 194.52 | 194.49 | 194.5 | 26585.0 |
| 2014-06-17 08:20:00 | SPY | ETF | 194.53 | 194.56 | 194.52 | 194.53 | 34264.0 |
| 2014-06-17 08:25:00 | SPY | ETF | 194.54 | 194.55 | 194.51 | 194.51 | 8716.0 |
| 2014-06-17 08:30:00 | SPY | ETF | 194.51 | 194.51 | 193.94 | 194.04 | 495649.0 |
| 2014-06-17 08:35:00 | SPY | ETF | 194.03 | 194.1 | 194.03 | 194.04 | 64896.0 |
| 2014-06-17 08:40:00 | SPY | ETF | 194.02 | 194.07 | 193.96 | 194.02 | 207867.0 |
| 2014-06-17 08:45:00 | SPY | ETF | 194.0 | 194.0 | 193.76 | 193.84 | 228127.0 |
| 2014-06-17 08:50:00 | SPY | ETF | 193.84 | 193.91 | 193.8 | 193.9 | 153479.0 |
| 2014-06-17 08:55:00 | SPY | ETF | 193.89 | 193.95 | 193.89 | 193.94 | 85942.0 |
| 2014-06-17 09:00:00 | SPY | ETF | 193.91 | 194.0 | 193.87 | 193.98 | 76626.0 |
| 2014-06-17 09:05:00 | SPY | ETF | 193.98 | 194.03 | 193.93 | 194.03 | 157792.0 |
| 2014-06-17 09:10:00 | SPY | ETF | 194.03 | 194.03 | 193.98 | 193.98 | 44789.0 |
| 2014-06-17 09:15:00 | SPY | ETF | 193.98 | 194.04 | 193.98 | 194.03 | 37185.0 |
| 2014-06-17 09:20:00 | SPY | ETF | 194.04 | 194.1 | 194.04 | 194.07 | 160456.0 |
> showing 50 of 41,359 rows — these rows as CSV