PREVIEW / etf_5min / 2007-03-08
file: by_date/etf_5min/2007/2007-03-08.parquet size: 300 KB rows: 14,649
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-03-08 04:15:00 | SPY | ETF | 140.41 | 140.41 | 140.41 | 140.41 | 400.0 |
| 2007-03-08 04:40:00 | SPY | ETF | 140.5 | 140.54 | 140.5 | 140.54 | 5800.0 |
| 2007-03-08 06:10:00 | SPY | ETF | 140.66 | 140.66 | 140.66 | 140.66 | 9000.0 |
| 2007-03-08 06:35:00 | SPY | ETF | 140.55 | 140.55 | 140.52 | 140.52 | 14500.0 |
| 2007-03-08 06:45:00 | SPY | ETF | 140.56 | 140.56 | 140.5 | 140.5 | 2100.0 |
| 2007-03-08 06:50:00 | SPY | ETF | 140.5 | 140.5 | 140.49 | 140.49 | 50000.0 |
| 2007-03-08 06:55:00 | SPY | ETF | 140.5 | 140.59 | 140.5 | 140.5 | 57700.0 |
| 2007-03-08 07:00:00 | SPY | ETF | 140.51 | 140.62 | 140.5 | 140.62 | 201500.0 |
| 2007-03-08 07:05:00 | SPY | ETF | 140.62 | 140.67 | 140.59 | 140.67 | 269700.0 |
| 2007-03-08 07:10:00 | SPY | ETF | 140.67 | 140.67 | 140.61 | 140.61 | 118400.0 |
| 2007-03-08 07:15:00 | SPY | ETF | 140.62 | 140.62 | 140.59 | 140.59 | 7500.0 |
| 2007-03-08 07:20:00 | SPY | ETF | 140.6 | 140.6 | 140.58 | 140.58 | 44100.0 |
| 2007-03-08 07:25:00 | SPY | ETF | 140.6 | 140.6 | 140.58 | 140.58 | 11900.0 |
| 2007-03-08 07:30:00 | SPY | ETF | 140.6 | 140.65 | 140.58 | 140.61 | 73700.0 |
| 2007-03-08 07:35:00 | SPY | ETF | 140.6 | 140.69 | 140.58 | 140.66 | 181900.0 |
| 2007-03-08 07:40:00 | SPY | ETF | 140.67 | 140.73 | 140.66 | 140.7 | 212500.0 |
| 2007-03-08 07:45:00 | SPY | ETF | 140.7 | 140.72 | 140.66 | 140.66 | 174500.0 |
| 2007-03-08 07:50:00 | SPY | ETF | 140.66 | 140.67 | 140.62 | 140.66 | 39700.0 |
| 2007-03-08 07:55:00 | SPY | ETF | 140.63 | 140.7 | 140.63 | 140.65 | 34200.0 |
| 2007-03-08 08:00:00 | SPY | ETF | 140.62 | 140.7 | 140.59 | 140.64 | 115100.0 |
| 2007-03-08 08:05:00 | SPY | ETF | 140.65 | 140.67 | 140.61 | 140.65 | 25600.0 |
| 2007-03-08 08:10:00 | SPY | ETF | 140.65 | 140.7 | 140.65 | 140.7 | 67700.0 |
| 2007-03-08 08:15:00 | SPY | ETF | 140.69 | 140.74 | 140.66 | 140.69 | 931900.0 |
| 2007-03-08 08:20:00 | SPY | ETF | 140.67 | 140.69 | 140.62 | 140.64 | 133800.0 |
| 2007-03-08 08:25:00 | SPY | ETF | 140.6 | 140.7 | 140.58 | 140.6 | 1162200.0 |
| 2007-03-08 08:30:00 | SPY | ETF | 140.59 | 140.71 | 140.59 | 140.68 | 232300.0 |
| 2007-03-08 08:35:00 | SPY | ETF | 140.67 | 140.69 | 140.67 | 140.67 | 40500.0 |
| 2007-03-08 08:40:00 | SPY | ETF | 140.67 | 140.67 | 140.5 | 140.53 | 503000.0 |
| 2007-03-08 08:45:00 | SPY | ETF | 140.51 | 140.54 | 140.47 | 140.5 | 219700.0 |
| 2007-03-08 08:50:00 | SPY | ETF | 140.51 | 140.56 | 140.47 | 140.54 | 111400.0 |
| 2007-03-08 08:55:00 | SPY | ETF | 140.54 | 140.62 | 140.54 | 140.6 | 150800.0 |
| 2007-03-08 09:00:00 | SPY | ETF | 140.58 | 140.59 | 140.54 | 140.55 | 14000.0 |
| 2007-03-08 09:05:00 | SPY | ETF | 140.55 | 140.58 | 140.55 | 140.57 | 12200.0 |
| 2007-03-08 09:10:00 | SPY | ETF | 140.57 | 140.6 | 140.51 | 140.51 | 114000.0 |
| 2007-03-08 09:15:00 | SPY | ETF | 140.52 | 140.53 | 140.47 | 140.51 | 40200.0 |
| 2007-03-08 09:20:00 | SPY | ETF | 140.52 | 140.52 | 140.47 | 140.48 | 114600.0 |
| 2007-03-08 09:25:00 | SPY | ETF | 140.49 | 140.58 | 139.78 | 140.53 | 112600.0 |
| 2007-03-08 09:30:00 | SPY | ETF | 140.54 | 140.84 | 140.48 | 140.55 | 2302000.0 |
| 2007-03-08 09:35:00 | SPY | ETF | 140.54 | 140.78 | 140.5 | 140.72 | 2038100.0 |
| 2007-03-08 09:40:00 | SPY | ETF | 140.71 | 140.82 | 140.5 | 140.72 | 1860700.0 |
| 2007-03-08 09:45:00 | SPY | ETF | 140.73 | 140.78 | 140.6 | 140.6 | 2132900.0 |
| 2007-03-08 09:50:00 | SPY | ETF | 140.6 | 140.79 | 140.6 | 140.65 | 2427900.0 |
| 2007-03-08 09:55:00 | SPY | ETF | 140.65 | 140.82 | 140.59 | 140.59 | 1495800.0 |
| 2007-03-08 10:00:00 | SPY | ETF | 140.6 | 140.72 | 140.58 | 140.71 | 886500.0 |
| 2007-03-08 10:05:00 | SPY | ETF | 140.71 | 140.8 | 140.67 | 140.76 | 1190400.0 |
| 2007-03-08 10:10:00 | SPY | ETF | 140.76 | 140.82 | 140.68 | 140.8 | 1743400.0 |
| 2007-03-08 10:15:00 | SPY | ETF | 140.8 | 140.95 | 140.75 | 140.95 | 2034300.0 |
| 2007-03-08 10:20:00 | SPY | ETF | 140.95 | 141.02 | 140.6 | 140.99 | 3772300.0 |
| 2007-03-08 10:25:00 | SPY | ETF | 140.98 | 141.09 | 140.92 | 141.06 | 3455900.0 |
| 2007-03-08 10:30:00 | SPY | ETF | 141.06 | 141.09 | 140.775 | 141.03 | 2080200.0 |
> showing 50 of 14,649 rows — these rows as CSV