PREVIEW / etf_5min / 2013-11-15
file: by_date/etf_5min/2013/2013-11-15.parquet size: 966 KB rows: 41,559
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-11-15 04:00:00 | SPY | ETF | 179.4 | 179.5 | 179.4 | 179.49 | 750.0 |
| 2013-11-15 04:05:00 | SPY | ETF | 179.42 | 179.49 | 179.15 | 179.49 | 4500.0 |
| 2013-11-15 04:10:00 | SPY | ETF | 179.49 | 179.5 | 179.49 | 179.5 | 835.0 |
| 2013-11-15 04:15:00 | SPY | ETF | 179.5 | 179.5 | 179.5 | 179.5 | 600.0 |
| 2013-11-15 04:35:00 | SPY | ETF | 179.49 | 179.49 | 179.49 | 179.49 | 500.0 |
| 2013-11-15 04:40:00 | SPY | ETF | 179.5 | 179.5 | 179.49 | 179.49 | 600.0 |
| 2013-11-15 04:45:00 | SPY | ETF | 179.47 | 179.47 | 179.47 | 179.47 | 200.0 |
| 2013-11-15 04:50:00 | SPY | ETF | 179.44 | 179.48 | 179.44 | 179.48 | 25128.0 |
| 2013-11-15 05:00:00 | SPY | ETF | 179.49 | 179.49 | 179.49 | 179.49 | 200.0 |
| 2013-11-15 05:05:00 | SPY | ETF | 179.49 | 179.49 | 179.49 | 179.49 | 500.0 |
| 2013-11-15 05:10:00 | SPY | ETF | 179.49 | 179.49 | 179.49 | 179.49 | 109.0 |
| 2013-11-15 05:15:00 | SPY | ETF | 179.49 | 179.52 | 179.49 | 179.52 | 3000.0 |
| 2013-11-15 05:20:00 | SPY | ETF | 179.51 | 179.52 | 179.51 | 179.52 | 400.0 |
| 2013-11-15 05:25:00 | SPY | ETF | 179.52 | 179.52 | 179.52 | 179.52 | 100.0 |
| 2013-11-15 05:30:00 | SPY | ETF | 179.52 | 179.54 | 179.52 | 179.54 | 701.0 |
| 2013-11-15 05:35:00 | SPY | ETF | 179.56 | 179.56 | 179.56 | 179.56 | 100.0 |
| 2013-11-15 05:45:00 | SPY | ETF | 179.59 | 179.62 | 179.59 | 179.62 | 4906.0 |
| 2013-11-15 05:50:00 | SPY | ETF | 179.6 | 179.69 | 179.6 | 179.64 | 6194.0 |
| 2013-11-15 06:00:00 | SPY | ETF | 179.62 | 179.62 | 179.61 | 179.61 | 15500.0 |
| 2013-11-15 06:05:00 | SPY | ETF | 179.61 | 179.61 | 179.61 | 179.61 | 5000.0 |
| 2013-11-15 06:10:00 | SPY | ETF | 179.61 | 179.65 | 179.61 | 179.65 | 10900.0 |
| 2013-11-15 06:15:00 | SPY | ETF | 179.69 | 179.73 | 179.69 | 179.7 | 19300.0 |
| 2013-11-15 06:20:00 | SPY | ETF | 179.67 | 179.69 | 179.66 | 179.67 | 2200.0 |
| 2013-11-15 06:25:00 | SPY | ETF | 179.62 | 179.64 | 179.62 | 179.64 | 200.0 |
| 2013-11-15 06:30:00 | SPY | ETF | 179.64 | 179.69 | 179.64 | 179.69 | 300.0 |
| 2013-11-15 06:35:00 | SPY | ETF | 179.72 | 179.74 | 179.71 | 179.74 | 6200.0 |
| 2013-11-15 06:40:00 | SPY | ETF | 179.74 | 179.75 | 179.72 | 179.75 | 27200.0 |
| 2013-11-15 06:45:00 | SPY | ETF | 179.72 | 179.77 | 179.71 | 179.77 | 6164.0 |
| 2013-11-15 06:50:00 | SPY | ETF | 179.77 | 179.78 | 179.66 | 179.66 | 27506.0 |
| 2013-11-15 06:55:00 | SPY | ETF | 179.69 | 179.69 | 179.66 | 179.69 | 1100.0 |
| 2013-11-15 07:00:00 | SPY | ETF | 179.7 | 179.74 | 179.7 | 179.74 | 544.0 |
| 2013-11-15 07:05:00 | SPY | ETF | 179.74 | 179.78 | 179.71 | 179.74 | 13750.0 |
| 2013-11-15 07:10:00 | SPY | ETF | 179.72 | 179.74 | 179.67 | 179.7 | 3900.0 |
| 2013-11-15 07:15:00 | SPY | ETF | 179.7 | 179.7 | 179.61 | 179.64 | 54500.0 |
| 2013-11-15 07:20:00 | SPY | ETF | 179.64 | 179.67 | 179.61 | 179.67 | 60383.0 |
| 2013-11-15 07:25:00 | SPY | ETF | 179.62 | 179.65 | 179.62 | 179.64 | 5178.0 |
| 2013-11-15 07:30:00 | SPY | ETF | 179.62 | 179.66 | 179.61 | 179.66 | 9810.0 |
| 2013-11-15 07:35:00 | SPY | ETF | 179.63 | 179.7 | 179.62 | 179.68 | 28850.0 |
| 2013-11-15 07:40:00 | SPY | ETF | 179.66 | 179.67 | 179.63 | 179.65 | 2129.0 |
| 2013-11-15 07:45:00 | SPY | ETF | 179.62 | 179.64 | 179.61 | 179.64 | 8600.0 |
| 2013-11-15 07:50:00 | SPY | ETF | 179.64 | 179.74 | 179.64 | 179.72 | 42450.0 |
| 2013-11-15 07:55:00 | SPY | ETF | 179.72 | 179.73 | 179.7 | 179.71 | 34050.0 |
| 2013-11-15 08:00:00 | SPY | ETF | 179.69 | 179.73 | 179.63 | 179.67 | 146593.0 |
| 2013-11-15 08:05:00 | SPY | ETF | 179.66 | 179.7 | 179.64 | 179.7 | 98369.0 |
| 2013-11-15 08:10:00 | SPY | ETF | 179.69 | 179.7 | 179.64 | 179.66 | 140000.0 |
| 2013-11-15 08:15:00 | SPY | ETF | 179.66 | 179.71 | 179.64 | 179.7 | 82750.0 |
| 2013-11-15 08:20:00 | SPY | ETF | 179.7 | 179.72 | 179.69 | 179.69 | 9333.0 |
| 2013-11-15 08:25:00 | SPY | ETF | 179.68 | 179.7 | 179.62 | 179.64 | 30250.0 |
| 2013-11-15 08:30:00 | SPY | ETF | 179.67 | 179.68 | 179.6 | 179.6 | 50684.0 |
| 2013-11-15 08:35:00 | SPY | ETF | 179.6 | 179.65 | 179.58 | 179.65 | 116447.0 |
> showing 50 of 41,559 rows — these rows as CSV