PREVIEW / etf_5min / 2007-12-27
file: by_date/etf_5min/2007/2007-12-27.parquet size: 397 KB rows: 19,654
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-27 06:30:00 | SPY | ETF | 149.41 | 149.41 | 149.41 | 149.41 | 2500.0 |
| 2007-12-27 06:35:00 | SPY | ETF | 149.43 | 149.43 | 149.43 | 149.43 | 2500.0 |
| 2007-12-27 06:55:00 | SPY | ETF | 149.43 | 149.43 | 149.43 | 149.43 | 1500.0 |
| 2007-12-27 07:00:00 | SPY | ETF | 149.5 | 149.54 | 149.5 | 149.5 | 1700.0 |
| 2007-12-27 07:05:00 | SPY | ETF | 149.5 | 149.53 | 149.5 | 149.53 | 15400.0 |
| 2007-12-27 07:20:00 | SPY | ETF | 149.58 | 149.59 | 149.58 | 149.59 | 5100.0 |
| 2007-12-27 07:25:00 | SPY | ETF | 149.58 | 149.63 | 149.58 | 149.61 | 14800.0 |
| 2007-12-27 07:30:00 | SPY | ETF | 149.63 | 149.63 | 149.63 | 149.63 | 1000.0 |
| 2007-12-27 07:35:00 | SPY | ETF | 149.6 | 149.6 | 149.58 | 149.58 | 1200.0 |
| 2007-12-27 07:40:00 | SPY | ETF | 149.57 | 149.57 | 149.57 | 149.57 | 2000.0 |
| 2007-12-27 07:45:00 | SPY | ETF | 149.55 | 149.61 | 149.55 | 149.61 | 25500.0 |
| 2007-12-27 07:50:00 | SPY | ETF | 149.59 | 149.6 | 149.59 | 149.59 | 500.0 |
| 2007-12-27 08:00:00 | SPY | ETF | 149.63 | 149.63 | 149.55 | 149.55 | 220100.0 |
| 2007-12-27 08:05:00 | SPY | ETF | 149.55 | 149.6 | 149.55 | 149.58 | 39100.0 |
| 2007-12-27 08:10:00 | SPY | ETF | 149.55 | 149.58 | 149.55 | 149.58 | 37600.0 |
| 2007-12-27 08:15:00 | SPY | ETF | 149.58 | 149.58 | 149.56 | 149.57 | 38800.0 |
| 2007-12-27 08:20:00 | SPY | ETF | 149.56 | 149.57 | 149.47 | 149.47 | 65100.0 |
| 2007-12-27 08:25:00 | SPY | ETF | 149.48 | 149.48 | 149.18 | 149.32 | 855900.0 |
| 2007-12-27 08:30:00 | SPY | ETF | 149.32 | 149.32 | 148.8 | 148.97 | 2357000.0 |
| 2007-12-27 08:35:00 | SPY | ETF | 148.98 | 149.06 | 148.82 | 148.83 | 346200.0 |
| 2007-12-27 08:40:00 | SPY | ETF | 148.82 | 148.88 | 148.73 | 148.83 | 1263400.0 |
| 2007-12-27 08:45:00 | SPY | ETF | 148.84 | 148.99 | 148.81 | 148.98 | 162100.0 |
| 2007-12-27 08:50:00 | SPY | ETF | 148.98 | 149.04 | 148.97 | 149.02 | 36200.0 |
| 2007-12-27 08:55:00 | SPY | ETF | 149.01 | 149.4 | 148.86 | 148.87 | 569300.0 |
| 2007-12-27 09:00:00 | SPY | ETF | 148.87 | 148.87 | 148.77 | 148.84 | 127700.0 |
| 2007-12-27 09:05:00 | SPY | ETF | 148.85 | 148.92 | 148.83 | 148.92 | 65500.0 |
| 2007-12-27 09:10:00 | SPY | ETF | 148.92 | 148.96 | 148.92 | 148.92 | 20900.0 |
| 2007-12-27 09:15:00 | SPY | ETF | 148.93 | 148.98 | 148.93 | 148.95 | 163300.0 |
| 2007-12-27 09:20:00 | SPY | ETF | 148.95 | 149.01 | 148.95 | 149.01 | 52900.0 |
| 2007-12-27 09:25:00 | SPY | ETF | 149.0 | 149.01 | 148.96 | 149.0 | 120200.0 |
| 2007-12-27 09:30:00 | SPY | ETF | 149.02 | 149.03 | 148.86 | 148.88 | 1893207.0 |
| 2007-12-27 09:35:00 | SPY | ETF | 148.88 | 149.0 | 148.77 | 148.82 | 1479994.0 |
| 2007-12-27 09:40:00 | SPY | ETF | 148.83 | 148.85 | 148.73 | 148.84 | 1640892.0 |
| 2007-12-27 09:45:00 | SPY | ETF | 148.84 | 148.89 | 148.78 | 148.8601 | 3940955.0 |
| 2007-12-27 09:50:00 | SPY | ETF | 148.86 | 148.99 | 148.86 | 148.89 | 559972.0 |
| 2007-12-27 09:55:00 | SPY | ETF | 148.88 | 148.93 | 148.58 | 148.6 | 1847966.0 |
| 2007-12-27 10:00:00 | SPY | ETF | 148.6 | 148.78 | 148.6 | 148.76 | 2362010.0 |
| 2007-12-27 10:05:00 | SPY | ETF | 148.76 | 148.85 | 148.73 | 148.8 | 1010392.0 |
| 2007-12-27 10:10:00 | SPY | ETF | 148.79 | 148.85 | 148.73 | 148.84 | 715378.0 |
| 2007-12-27 10:15:00 | SPY | ETF | 148.83 | 148.91 | 148.79 | 148.84 | 981550.0 |
| 2007-12-27 10:20:00 | SPY | ETF | 148.83 | 148.93 | 148.81 | 148.91 | 769650.0 |
| 2007-12-27 10:25:00 | SPY | ETF | 148.91 | 148.97 | 148.83 | 148.84 | 654500.0 |
| 2007-12-27 10:30:00 | SPY | ETF | 148.83 | 148.9 | 148.77 | 148.78 | 1188304.0 |
| 2007-12-27 10:35:00 | SPY | ETF | 148.78 | 148.8 | 148.54 | 148.54 | 1220873.0 |
| 2007-12-27 10:40:00 | SPY | ETF | 148.54 | 148.67 | 148.51 | 148.61 | 1454520.0 |
| 2007-12-27 10:45:00 | SPY | ETF | 148.61 | 148.66 | 148.49 | 148.53 | 1272880.0 |
| 2007-12-27 10:50:00 | SPY | ETF | 148.53 | 148.65 | 148.51 | 148.6 | 903600.0 |
| 2007-12-27 10:55:00 | SPY | ETF | 148.6 | 148.61 | 148.38 | 148.46 | 1373099.0 |
| 2007-12-27 11:00:00 | SPY | ETF | 148.46 | 148.57 | 148.35 | 148.38 | 3039200.0 |
| 2007-12-27 11:05:00 | SPY | ETF | 148.38 | 148.41 | 148.3 | 148.3 | 537550.0 |
> showing 50 of 19,654 rows — these rows as CSV