PREVIEW / etf_5min / 2014-06-12
file: by_date/etf_5min/2014/2014-06-12.parquet size: 1013 KB rows: 42,058
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-12 04:00:00 | SPY | ETF | 195.11 | 195.11 | 195.11 | 195.11 | 216.0 |
| 2014-06-12 04:05:00 | SPY | ETF | 195.07 | 195.11 | 195.07 | 195.11 | 453.0 |
| 2014-06-12 04:10:00 | SPY | ETF | 195.12 | 195.12 | 195.12 | 195.12 | 350.0 |
| 2014-06-12 04:25:00 | SPY | ETF | 195.1 | 195.1 | 195.1 | 195.1 | 210.0 |
| 2014-06-12 04:30:00 | SPY | ETF | 195.15 | 195.15 | 195.15 | 195.15 | 100.0 |
| 2014-06-12 04:50:00 | SPY | ETF | 195.12 | 195.12 | 195.12 | 195.12 | 200.0 |
| 2014-06-12 04:55:00 | SPY | ETF | 195.19 | 195.19 | 195.19 | 195.19 | 288.0 |
| 2014-06-12 05:15:00 | SPY | ETF | 195.15 | 195.15 | 195.15 | 195.15 | 159.0 |
| 2014-06-12 05:25:00 | SPY | ETF | 195.17 | 195.17 | 195.17 | 195.17 | 250.0 |
| 2014-06-12 05:35:00 | SPY | ETF | 195.05 | 195.14 | 195.05 | 195.14 | 2200.0 |
| 2014-06-12 05:40:00 | SPY | ETF | 195.18 | 195.22 | 195.18 | 195.22 | 1022.0 |
| 2014-06-12 05:50:00 | SPY | ETF | 195.26 | 195.28 | 195.26 | 195.28 | 1300.0 |
| 2014-06-12 06:05:00 | SPY | ETF | 195.22 | 195.22 | 195.18 | 195.18 | 1041.0 |
| 2014-06-12 06:15:00 | SPY | ETF | 195.14 | 195.14 | 195.14 | 195.14 | 400.0 |
| 2014-06-12 06:20:00 | SPY | ETF | 195.17 | 195.18 | 195.17 | 195.18 | 5721.0 |
| 2014-06-12 06:25:00 | SPY | ETF | 195.12 | 195.12 | 195.12 | 195.12 | 150.0 |
| 2014-06-12 06:30:00 | SPY | ETF | 195.1 | 195.1 | 195.06 | 195.06 | 1800.0 |
| 2014-06-12 06:35:00 | SPY | ETF | 195.04 | 195.04 | 195.02 | 195.02 | 2299.0 |
| 2014-06-12 06:40:00 | SPY | ETF | 195.01 | 195.02 | 195.01 | 195.02 | 5500.0 |
| 2014-06-12 06:45:00 | SPY | ETF | 195.04 | 195.06 | 195.04 | 195.06 | 1161.0 |
| 2014-06-12 06:50:00 | SPY | ETF | 195.06 | 195.08 | 195.06 | 195.08 | 600.0 |
| 2014-06-12 06:55:00 | SPY | ETF | 195.07 | 195.07 | 195.05 | 195.05 | 15200.0 |
| 2014-06-12 07:00:00 | SPY | ETF | 195.07 | 195.07 | 195.07 | 195.07 | 100.0 |
| 2014-06-12 07:05:00 | SPY | ETF | 195.09 | 195.09 | 195.05 | 195.05 | 5200.0 |
| 2014-06-12 07:10:00 | SPY | ETF | 195.07 | 195.08 | 195.05 | 195.08 | 2513.0 |
| 2014-06-12 07:20:00 | SPY | ETF | 195.08 | 195.08 | 195.08 | 195.08 | 378.0 |
| 2014-06-12 07:25:00 | SPY | ETF | 195.06 | 195.06 | 195.03 | 195.03 | 1300.0 |
| 2014-06-12 07:30:00 | SPY | ETF | 195.04 | 195.1 | 195.04 | 195.1 | 2215.0 |
| 2014-06-12 07:35:00 | SPY | ETF | 195.14 | 195.16 | 195.1 | 195.1 | 16650.0 |
| 2014-06-12 07:40:00 | SPY | ETF | 195.11 | 195.14 | 195.1 | 195.14 | 26620.0 |
| 2014-06-12 07:45:00 | SPY | ETF | 195.14 | 195.16 | 195.14 | 195.16 | 9310.0 |
| 2014-06-12 07:50:00 | SPY | ETF | 195.12 | 195.12 | 195.1 | 195.1 | 1100.0 |
| 2014-06-12 07:55:00 | SPY | ETF | 195.1 | 195.1 | 195.05 | 195.07 | 63442.0 |
| 2014-06-12 08:00:00 | SPY | ETF | 195.16 | 195.16 | 195.03 | 195.06 | 46650.0 |
| 2014-06-12 08:05:00 | SPY | ETF | 195.05 | 195.08 | 195.05 | 195.08 | 20650.0 |
| 2014-06-12 08:10:00 | SPY | ETF | 195.06 | 195.06 | 195.02 | 195.05 | 53800.0 |
| 2014-06-12 08:15:00 | SPY | ETF | 195.04 | 195.05 | 195.02 | 195.03 | 33262.0 |
| 2014-06-12 08:20:00 | SPY | ETF | 195.03 | 195.04 | 194.97 | 194.97 | 32957.0 |
| 2014-06-12 08:25:00 | SPY | ETF | 194.97 | 195.03 | 194.95 | 195.03 | 23256.0 |
| 2014-06-12 08:30:00 | SPY | ETF | 194.96 | 194.99 | 194.56 | 194.87 | 378354.0 |
| 2014-06-12 08:35:00 | SPY | ETF | 194.87 | 194.95 | 194.85 | 194.93 | 87892.0 |
| 2014-06-12 08:40:00 | SPY | ETF | 194.92 | 194.93 | 194.89 | 194.93 | 67153.0 |
| 2014-06-12 08:45:00 | SPY | ETF | 194.94 | 194.95 | 194.89 | 194.9 | 25450.0 |
| 2014-06-12 08:50:00 | SPY | ETF | 194.9 | 194.9 | 194.85 | 194.88 | 65924.0 |
| 2014-06-12 08:55:00 | SPY | ETF | 194.85 | 194.87 | 194.75 | 194.76 | 103948.0 |
| 2014-06-12 09:00:00 | SPY | ETF | 194.77 | 194.77 | 194.73 | 194.77 | 75928.0 |
| 2014-06-12 09:05:00 | SPY | ETF | 194.76 | 194.8 | 194.6 | 194.64 | 92185.0 |
| 2014-06-12 09:10:00 | SPY | ETF | 194.64 | 194.71 | 194.62 | 194.68 | 134799.0 |
| 2014-06-12 09:15:00 | SPY | ETF | 194.69 | 194.7 | 194.66 | 194.66 | 105255.0 |
| 2014-06-12 09:20:00 | SPY | ETF | 194.66 | 194.68 | 194.64 | 194.68 | 95176.0 |
> showing 50 of 42,058 rows — these rows as CSV