PREVIEW / etf_5min / 2014-06-18
file: by_date/etf_5min/2014/2014-06-18.parquet size: 994 KB rows: 41,783
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-18 04:30:00 | SPY | ETF | 194.83 | 194.83 | 194.83 | 194.83 | 500.0 |
| 2014-06-18 05:50:00 | SPY | ETF | 194.74 | 194.74 | 194.74 | 194.74 | 850.0 |
| 2014-06-18 06:05:00 | SPY | ETF | 194.78 | 194.78 | 194.78 | 194.78 | 216.0 |
| 2014-06-18 06:10:00 | SPY | ETF | 194.78 | 194.78 | 194.78 | 194.78 | 500.0 |
| 2014-06-18 06:25:00 | SPY | ETF | 194.76 | 194.76 | 194.76 | 194.76 | 300.0 |
| 2014-06-18 06:30:00 | SPY | ETF | 194.76 | 194.76 | 194.76 | 194.76 | 600.0 |
| 2014-06-18 06:40:00 | SPY | ETF | 194.79 | 194.79 | 194.79 | 194.79 | 100.0 |
| 2014-06-18 06:45:00 | SPY | ETF | 194.78 | 194.81 | 194.78 | 194.81 | 700.0 |
| 2014-06-18 06:50:00 | SPY | ETF | 194.82 | 194.82 | 194.82 | 194.82 | 190.0 |
| 2014-06-18 06:55:00 | SPY | ETF | 194.83 | 194.83 | 194.83 | 194.83 | 27529.0 |
| 2014-06-18 07:00:00 | SPY | ETF | 194.79 | 194.8 | 194.78 | 194.8 | 1727.0 |
| 2014-06-18 07:05:00 | SPY | ETF | 194.8 | 194.81 | 194.78 | 194.78 | 56300.0 |
| 2014-06-18 07:10:00 | SPY | ETF | 194.78 | 194.81 | 194.77 | 194.78 | 26800.0 |
| 2014-06-18 07:15:00 | SPY | ETF | 194.77 | 194.77 | 194.77 | 194.77 | 150.0 |
| 2014-06-18 07:20:00 | SPY | ETF | 194.78 | 194.83 | 194.78 | 194.83 | 178973.0 |
| 2014-06-18 07:25:00 | SPY | ETF | 194.82 | 194.84 | 194.82 | 194.83 | 50200.0 |
| 2014-06-18 07:30:00 | SPY | ETF | 194.85 | 194.85 | 194.82 | 194.82 | 58212.0 |
| 2014-06-18 07:35:00 | SPY | ETF | 194.83 | 194.83 | 194.82 | 194.83 | 25303.0 |
| 2014-06-18 07:40:00 | SPY | ETF | 194.82 | 194.85 | 194.79 | 194.79 | 14704.0 |
| 2014-06-18 07:45:00 | SPY | ETF | 194.8 | 194.81 | 194.8 | 194.8 | 9603.0 |
| 2014-06-18 07:50:00 | SPY | ETF | 194.78 | 194.81 | 194.75 | 194.8 | 24359.0 |
| 2014-06-18 07:55:00 | SPY | ETF | 194.77 | 194.78 | 194.72 | 194.74 | 32288.0 |
| 2014-06-18 08:00:00 | SPY | ETF | 194.75 | 194.81 | 194.74 | 194.75 | 7508.0 |
| 2014-06-18 08:05:00 | SPY | ETF | 194.77 | 194.78 | 194.75 | 194.75 | 26440.0 |
| 2014-06-18 08:10:00 | SPY | ETF | 194.76 | 194.79 | 194.76 | 194.79 | 11272.0 |
| 2014-06-18 08:15:00 | SPY | ETF | 194.79 | 194.79 | 194.76 | 194.78 | 14600.0 |
| 2014-06-18 08:20:00 | SPY | ETF | 194.8 | 194.8 | 194.77 | 194.77 | 2200.0 |
| 2014-06-18 08:25:00 | SPY | ETF | 194.78 | 194.78 | 194.75 | 194.75 | 3911.0 |
| 2014-06-18 08:30:00 | SPY | ETF | 194.75 | 194.77 | 194.73 | 194.76 | 29413.0 |
| 2014-06-18 08:35:00 | SPY | ETF | 194.76 | 194.76 | 194.73 | 194.75 | 16981.0 |
| 2014-06-18 08:40:00 | SPY | ETF | 194.75 | 194.75 | 194.73 | 194.73 | 19794.0 |
| 2014-06-18 08:45:00 | SPY | ETF | 194.72 | 194.75 | 194.72 | 194.74 | 30550.0 |
| 2014-06-18 08:50:00 | SPY | ETF | 194.75 | 194.82 | 194.74 | 194.81 | 14320.0 |
| 2014-06-18 08:55:00 | SPY | ETF | 194.81 | 194.84 | 194.81 | 194.82 | 45610.0 |
| 2014-06-18 09:00:00 | SPY | ETF | 194.82 | 194.83 | 194.78 | 194.78 | 33323.0 |
| 2014-06-18 09:05:00 | SPY | ETF | 194.78 | 194.79 | 194.74 | 194.78 | 46145.0 |
| 2014-06-18 09:10:00 | SPY | ETF | 194.78 | 194.8 | 194.75 | 194.8 | 27302.0 |
| 2014-06-18 09:15:00 | SPY | ETF | 194.8 | 194.83 | 194.8 | 194.82 | 34195.0 |
| 2014-06-18 09:20:00 | SPY | ETF | 194.82 | 194.86 | 194.8 | 194.86 | 42444.0 |
| 2014-06-18 09:25:00 | SPY | ETF | 194.85 | 194.87 | 194.81 | 194.84 | 247651.0 |
| 2014-06-18 09:30:00 | SPY | ETF | 194.83 | 194.93 | 194.68 | 194.74 | 1972146.0 |
| 2014-06-18 09:35:00 | SPY | ETF | 194.73 | 194.99 | 194.7 | 194.99 | 1483315.0 |
| 2014-06-18 09:40:00 | SPY | ETF | 194.985 | 195.02 | 194.89 | 194.94 | 1383231.0 |
| 2014-06-18 09:45:00 | SPY | ETF | 194.94 | 195.02 | 194.84 | 194.97 | 976848.0 |
| 2014-06-18 09:50:00 | SPY | ETF | 194.97 | 195.0 | 194.9 | 194.98 | 932415.0 |
| 2014-06-18 09:55:00 | SPY | ETF | 194.985 | 195.08 | 194.95 | 195.02 | 955325.0 |
| 2014-06-18 10:00:00 | SPY | ETF | 195.02 | 195.07 | 194.93 | 194.95 | 1062384.0 |
| 2014-06-18 10:05:00 | SPY | ETF | 194.94 | 195.01 | 194.81 | 194.85 | 1057837.0 |
| 2014-06-18 10:10:00 | SPY | ETF | 194.85 | 194.88 | 194.75 | 194.84 | 1055147.0 |
| 2014-06-18 10:15:00 | SPY | ETF | 194.84 | 194.96 | 194.83 | 194.925 | 856294.0 |
> showing 50 of 41,783 rows — these rows as CSV