PREVIEW / etf_5min / 2009-12-16
file: by_date/etf_5min/2009/2009-12-16.parquet size: 708 KB rows: 30,255
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-16 04:15:00 | SPY | ETF | 111.89 | 111.89 | 111.89 | 111.89 | 200.0 |
| 2009-12-16 04:20:00 | SPY | ETF | 111.94 | 111.94 | 111.94 | 111.94 | 1000.0 |
| 2009-12-16 04:30:00 | SPY | ETF | 111.89 | 111.89 | 111.89 | 111.89 | 100.0 |
| 2009-12-16 04:35:00 | SPY | ETF | 111.86 | 111.86 | 111.86 | 111.86 | 500.0 |
| 2009-12-16 04:40:00 | SPY | ETF | 111.84 | 111.84 | 111.84 | 111.84 | 100.0 |
| 2009-12-16 04:45:00 | SPY | ETF | 111.87 | 111.87 | 111.87 | 111.87 | 100.0 |
| 2009-12-16 05:00:00 | SPY | ETF | 112.0 | 112.0 | 112.0 | 112.0 | 100.0 |
| 2009-12-16 05:05:00 | SPY | ETF | 112.04 | 112.06 | 112.04 | 112.05 | 741.0 |
| 2009-12-16 05:10:00 | SPY | ETF | 112.04 | 112.12 | 112.04 | 112.12 | 921.0 |
| 2009-12-16 05:15:00 | SPY | ETF | 112.09 | 112.09 | 112.09 | 112.09 | 500.0 |
| 2009-12-16 05:35:00 | SPY | ETF | 112.04 | 112.04 | 112.04 | 112.04 | 1000.0 |
| 2009-12-16 05:50:00 | SPY | ETF | 112.03 | 112.06 | 112.03 | 112.06 | 400.0 |
| 2009-12-16 05:55:00 | SPY | ETF | 112.07 | 112.1 | 112.07 | 112.1 | 2000.0 |
| 2009-12-16 06:05:00 | SPY | ETF | 112.07 | 112.07 | 112.07 | 112.07 | 500.0 |
| 2009-12-16 06:10:00 | SPY | ETF | 112.06 | 112.06 | 112.05 | 112.05 | 600.0 |
| 2009-12-16 06:15:00 | SPY | ETF | 112.02 | 112.02 | 112.02 | 112.02 | 100.0 |
| 2009-12-16 06:20:00 | SPY | ETF | 112.07 | 112.07 | 112.02 | 112.02 | 5100.0 |
| 2009-12-16 06:30:00 | SPY | ETF | 112.0 | 112.0 | 112.0 | 112.0 | 600.0 |
| 2009-12-16 06:35:00 | SPY | ETF | 112.04 | 112.04 | 112.02 | 112.02 | 1100.0 |
| 2009-12-16 06:40:00 | SPY | ETF | 112.0 | 112.05 | 112.0 | 112.03 | 3100.0 |
| 2009-12-16 06:45:00 | SPY | ETF | 112.03 | 112.03 | 111.95 | 111.95 | 1300.0 |
| 2009-12-16 06:50:00 | SPY | ETF | 111.95 | 111.95 | 111.9 | 111.9 | 1000.0 |
| 2009-12-16 06:55:00 | SPY | ETF | 111.9 | 111.9 | 111.9 | 111.9 | 200.0 |
| 2009-12-16 07:00:00 | SPY | ETF | 111.87 | 111.93 | 111.87 | 111.93 | 23072.0 |
| 2009-12-16 07:05:00 | SPY | ETF | 111.9 | 111.93 | 111.88 | 111.88 | 19976.0 |
| 2009-12-16 07:10:00 | SPY | ETF | 111.9 | 111.92 | 111.89 | 111.89 | 4000.0 |
| 2009-12-16 07:15:00 | SPY | ETF | 111.89 | 111.91 | 111.87 | 111.87 | 9200.0 |
| 2009-12-16 07:20:00 | SPY | ETF | 111.92 | 111.94 | 111.92 | 111.94 | 11000.0 |
| 2009-12-16 07:25:00 | SPY | ETF | 111.92 | 111.92 | 111.89 | 111.89 | 12000.0 |
| 2009-12-16 07:30:00 | SPY | ETF | 111.91 | 111.91 | 111.87 | 111.89 | 34422.0 |
| 2009-12-16 07:35:00 | SPY | ETF | 111.89 | 111.94 | 111.89 | 111.94 | 17850.0 |
| 2009-12-16 07:40:00 | SPY | ETF | 111.92 | 111.94 | 111.89 | 111.91 | 7550.0 |
| 2009-12-16 07:45:00 | SPY | ETF | 111.89 | 111.91 | 111.86 | 111.86 | 7600.0 |
| 2009-12-16 07:50:00 | SPY | ETF | 111.86 | 111.86 | 111.83 | 111.83 | 74450.0 |
| 2009-12-16 07:55:00 | SPY | ETF | 111.86 | 111.89 | 111.86 | 111.88 | 4166.0 |
| 2009-12-16 08:00:00 | SPY | ETF | 111.86 | 111.87 | 111.82 | 111.83 | 59868.0 |
| 2009-12-16 08:05:00 | SPY | ETF | 111.83 | 111.83 | 111.74 | 111.74 | 26200.0 |
| 2009-12-16 08:10:00 | SPY | ETF | 111.73 | 111.78 | 111.73 | 111.78 | 62560.0 |
| 2009-12-16 08:15:00 | SPY | ETF | 111.78 | 112.16 | 111.75 | 111.75 | 110854.0 |
| 2009-12-16 08:20:00 | SPY | ETF | 111.75 | 111.78 | 111.75 | 111.76 | 74758.0 |
| 2009-12-16 08:25:00 | SPY | ETF | 111.76 | 111.76 | 111.73 | 111.76 | 93891.0 |
| 2009-12-16 08:30:00 | SPY | ETF | 111.77 | 111.85 | 111.76 | 111.83 | 254477.0 |
| 2009-12-16 08:35:00 | SPY | ETF | 111.83 | 111.84 | 111.79 | 111.79 | 54096.0 |
| 2009-12-16 08:40:00 | SPY | ETF | 111.8 | 111.85 | 111.8 | 111.81 | 140748.0 |
| 2009-12-16 08:45:00 | SPY | ETF | 111.81 | 111.83 | 111.79 | 111.81 | 63148.0 |
| 2009-12-16 08:50:00 | SPY | ETF | 111.8 | 111.82 | 111.79 | 111.81 | 284699.0 |
| 2009-12-16 08:55:00 | SPY | ETF | 111.81 | 111.82 | 111.78 | 111.8 | 63073.0 |
| 2009-12-16 09:00:00 | SPY | ETF | 111.8 | 111.8 | 111.73 | 111.73 | 116898.0 |
| 2009-12-16 09:05:00 | SPY | ETF | 111.73 | 111.78 | 111.69 | 111.78 | 179913.0 |
| 2009-12-16 09:10:00 | SPY | ETF | 111.78 | 111.8 | 111.77 | 111.78 | 50227.0 |
> showing 50 of 30,255 rows — these rows as CSV