PREVIEW / etf_5min / 2007-06-20
file: by_date/etf_5min/2007/2007-06-20.parquet size: 351 KB rows: 16,903
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-06-20 04:15:00 | SPY | ETF | 153.49 | 153.49 | 153.49 | 153.49 | 400.0 |
| 2007-06-20 06:25:00 | SPY | ETF | 153.62 | 153.62 | 153.62 | 153.62 | 4500.0 |
| 2007-06-20 06:30:00 | SPY | ETF | 153.62 | 153.62 | 153.62 | 153.62 | 500.0 |
| 2007-06-20 06:40:00 | SPY | ETF | 153.6 | 153.6 | 153.6 | 153.6 | 2000.0 |
| 2007-06-20 06:50:00 | SPY | ETF | 153.59 | 153.59 | 153.59 | 153.59 | 100.0 |
| 2007-06-20 06:55:00 | SPY | ETF | 153.63 | 153.63 | 153.6 | 153.63 | 19500.0 |
| 2007-06-20 07:00:00 | SPY | ETF | 153.57 | 153.61 | 153.57 | 153.6 | 15200.0 |
| 2007-06-20 07:05:00 | SPY | ETF | 153.6 | 153.6 | 153.6 | 153.6 | 4900.0 |
| 2007-06-20 07:10:00 | SPY | ETF | 153.55 | 153.55 | 153.51 | 153.53 | 12300.0 |
| 2007-06-20 07:15:00 | SPY | ETF | 153.52 | 153.58 | 153.52 | 153.58 | 18200.0 |
| 2007-06-20 07:20:00 | SPY | ETF | 153.58 | 153.61 | 153.58 | 153.58 | 8500.0 |
| 2007-06-20 07:25:00 | SPY | ETF | 153.59 | 153.6 | 153.58 | 153.58 | 5300.0 |
| 2007-06-20 07:30:00 | SPY | ETF | 153.59 | 153.65 | 153.59 | 153.63 | 37900.0 |
| 2007-06-20 07:35:00 | SPY | ETF | 153.6 | 153.64 | 153.58 | 153.64 | 30200.0 |
| 2007-06-20 07:40:00 | SPY | ETF | 153.63 | 153.64 | 153.6 | 153.63 | 70600.0 |
| 2007-06-20 07:45:00 | SPY | ETF | 153.65 | 153.65 | 153.63 | 153.63 | 24900.0 |
| 2007-06-20 07:50:00 | SPY | ETF | 153.63 | 153.64 | 153.61 | 153.64 | 27600.0 |
| 2007-06-20 07:55:00 | SPY | ETF | 153.61 | 153.65 | 153.61 | 153.65 | 39000.0 |
| 2007-06-20 08:00:00 | SPY | ETF | 153.64 | 153.69 | 153.62 | 153.68 | 70000.0 |
| 2007-06-20 08:05:00 | SPY | ETF | 153.66 | 153.74 | 153.66 | 153.73 | 257800.0 |
| 2007-06-20 08:10:00 | SPY | ETF | 153.73 | 153.75 | 153.71 | 153.71 | 65800.0 |
| 2007-06-20 08:15:00 | SPY | ETF | 153.72 | 153.78 | 153.71 | 153.76 | 168300.0 |
| 2007-06-20 08:20:00 | SPY | ETF | 153.77 | 153.8 | 153.75 | 153.75 | 20100.0 |
| 2007-06-20 08:25:00 | SPY | ETF | 153.75 | 153.79 | 153.73 | 153.75 | 48100.0 |
| 2007-06-20 08:30:00 | SPY | ETF | 153.74 | 153.74 | 153.68 | 153.7 | 28900.0 |
| 2007-06-20 08:35:00 | SPY | ETF | 153.68 | 153.71 | 153.68 | 153.69 | 59000.0 |
| 2007-06-20 08:40:00 | SPY | ETF | 153.68 | 153.73 | 153.67 | 153.73 | 331700.0 |
| 2007-06-20 08:45:00 | SPY | ETF | 153.73 | 153.73 | 153.71 | 153.71 | 459000.0 |
| 2007-06-20 08:50:00 | SPY | ETF | 153.71 | 153.76 | 153.7 | 153.74 | 125000.0 |
| 2007-06-20 08:55:00 | SPY | ETF | 153.74 | 153.74 | 153.71 | 153.72 | 18300.0 |
| 2007-06-20 09:00:00 | SPY | ETF | 153.71 | 153.72 | 153.59 | 153.62 | 70900.0 |
| 2007-06-20 09:05:00 | SPY | ETF | 153.62 | 153.64 | 153.61 | 153.62 | 159200.0 |
| 2007-06-20 09:10:00 | SPY | ETF | 153.62 | 153.66 | 153.57 | 153.57 | 492000.0 |
| 2007-06-20 09:15:00 | SPY | ETF | 153.59 | 153.65 | 153.27 | 153.65 | 119800.0 |
| 2007-06-20 09:20:00 | SPY | ETF | 153.63 | 153.63 | 153.59 | 153.59 | 23900.0 |
| 2007-06-20 09:25:00 | SPY | ETF | 153.59 | 153.63 | 153.57 | 153.57 | 287200.0 |
| 2007-06-20 09:30:00 | SPY | ETF | 153.58 | 153.58 | 153.39 | 153.47 | 2052815.0 |
| 2007-06-20 09:35:00 | SPY | ETF | 153.47 | 153.48 | 153.33 | 153.37 | 4315600.0 |
| 2007-06-20 09:40:00 | SPY | ETF | 153.37 | 153.49 | 153.36 | 153.379 | 1910700.0 |
| 2007-06-20 09:45:00 | SPY | ETF | 153.37 | 153.41 | 153.04 | 153.08 | 3540430.0 |
| 2007-06-20 09:50:00 | SPY | ETF | 153.08 | 153.35 | 153.01 | 153.12 | 2977300.0 |
| 2007-06-20 09:55:00 | SPY | ETF | 153.13 | 153.21 | 152.96 | 152.98 | 1863380.0 |
| 2007-06-20 10:00:00 | SPY | ETF | 152.98 | 152.99 | 152.64 | 152.71 | 5278093.0 |
| 2007-06-20 10:05:00 | SPY | ETF | 152.71 | 152.91 | 152.71 | 152.91 | 2150300.0 |
| 2007-06-20 10:10:00 | SPY | ETF | 152.91 | 152.92 | 152.83 | 152.9 | 1180400.0 |
| 2007-06-20 10:15:00 | SPY | ETF | 152.91 | 152.98 | 152.875 | 152.98 | 1257580.0 |
| 2007-06-20 10:20:00 | SPY | ETF | 152.98 | 153.01 | 152.93 | 152.93 | 1786800.0 |
| 2007-06-20 10:25:00 | SPY | ETF | 152.93 | 153.05 | 152.87 | 153.03 | 2036400.0 |
| 2007-06-20 10:30:00 | SPY | ETF | 153.04 | 153.35 | 152.94 | 153.33 | 4369024.0 |
| 2007-06-20 10:35:00 | SPY | ETF | 153.32 | 153.34 | 153.21 | 153.25 | 2364433.0 |
> showing 50 of 16,903 rows — these rows as CSV