PREVIEW / etf_5min / 2007-08-07
file: by_date/etf_5min/2007/2007-08-07.parquet size: 388 KB rows: 18,338
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-08-07 06:00:00 | SPY | ETF | 146.47 | 146.47 | 146.47 | 146.47 | 7500.0 |
| 2007-08-07 07:00:00 | SPY | ETF | 146.32 | 146.33 | 146.3 | 146.3 | 6000.0 |
| 2007-08-07 07:05:00 | SPY | ETF | 146.26 | 146.29 | 146.23 | 146.29 | 104800.0 |
| 2007-08-07 07:10:00 | SPY | ETF | 146.29 | 146.3 | 146.26 | 146.26 | 9300.0 |
| 2007-08-07 07:15:00 | SPY | ETF | 146.25 | 146.25 | 146.15 | 146.2 | 14700.0 |
| 2007-08-07 07:20:00 | SPY | ETF | 146.2 | 146.25 | 146.2 | 146.25 | 6000.0 |
| 2007-08-07 07:25:00 | SPY | ETF | 146.2 | 146.2 | 146.12 | 146.12 | 13200.0 |
| 2007-08-07 07:30:00 | SPY | ETF | 146.16 | 146.21 | 146.16 | 146.21 | 6800.0 |
| 2007-08-07 07:35:00 | SPY | ETF | 146.3 | 146.3 | 146.25 | 146.25 | 18700.0 |
| 2007-08-07 07:40:00 | SPY | ETF | 146.28 | 146.33 | 146.28 | 146.33 | 3800.0 |
| 2007-08-07 07:45:00 | SPY | ETF | 146.32 | 146.43 | 146.32 | 146.43 | 101000.0 |
| 2007-08-07 07:50:00 | SPY | ETF | 146.37 | 146.39 | 146.37 | 146.39 | 4700.0 |
| 2007-08-07 07:55:00 | SPY | ETF | 146.4 | 146.48 | 146.4 | 146.42 | 237000.0 |
| 2007-08-07 08:00:00 | SPY | ETF | 146.4 | 146.46 | 146.4 | 146.45 | 25300.0 |
| 2007-08-07 08:05:00 | SPY | ETF | 146.45 | 146.45 | 146.4 | 146.45 | 80700.0 |
| 2007-08-07 08:10:00 | SPY | ETF | 146.47 | 146.5 | 146.39 | 146.47 | 372200.0 |
| 2007-08-07 08:15:00 | SPY | ETF | 146.45 | 146.49 | 146.44 | 146.48 | 93300.0 |
| 2007-08-07 08:20:00 | SPY | ETF | 146.48 | 146.48 | 146.39 | 146.4 | 33700.0 |
| 2007-08-07 08:25:00 | SPY | ETF | 146.4 | 146.46 | 146.39 | 146.39 | 106600.0 |
| 2007-08-07 08:30:00 | SPY | ETF | 146.4 | 146.4 | 146.01 | 146.05 | 1208900.0 |
| 2007-08-07 08:35:00 | SPY | ETF | 146.04 | 146.14 | 145.98 | 146.1 | 247400.0 |
| 2007-08-07 08:40:00 | SPY | ETF | 146.11 | 146.11 | 145.97 | 145.98 | 326000.0 |
| 2007-08-07 08:45:00 | SPY | ETF | 146.01 | 146.04 | 145.92 | 145.95 | 423900.0 |
| 2007-08-07 08:50:00 | SPY | ETF | 145.94 | 146.07 | 145.94 | 146.07 | 196700.0 |
| 2007-08-07 08:55:00 | SPY | ETF | 146.06 | 146.06 | 145.94 | 146.02 | 208000.0 |
| 2007-08-07 09:00:00 | SPY | ETF | 146.02 | 146.09 | 145.97 | 145.99 | 195900.0 |
| 2007-08-07 09:05:00 | SPY | ETF | 145.98 | 145.98 | 145.88 | 145.93 | 595300.0 |
| 2007-08-07 09:10:00 | SPY | ETF | 145.93 | 145.96 | 145.85 | 145.85 | 626800.0 |
| 2007-08-07 09:15:00 | SPY | ETF | 145.85 | 145.93 | 145.84 | 145.93 | 1139800.0 |
| 2007-08-07 09:20:00 | SPY | ETF | 145.94 | 145.98 | 145.94 | 145.96 | 307500.0 |
| 2007-08-07 09:25:00 | SPY | ETF | 145.96 | 145.96 | 145.85 | 145.95 | 503800.0 |
| 2007-08-07 09:30:00 | SPY | ETF | 145.94 | 145.94 | 145.23 | 145.85 | 4552865.0 |
| 2007-08-07 09:35:00 | SPY | ETF | 145.85 | 145.99 | 145.69 | 145.87 | 4585056.0 |
| 2007-08-07 09:40:00 | SPY | ETF | 145.87 | 146.02 | 145.83 | 145.93 | 2167799.0 |
| 2007-08-07 09:45:00 | SPY | ETF | 145.935 | 146.16 | 145.9 | 145.99 | 3034147.0 |
| 2007-08-07 09:50:00 | SPY | ETF | 145.99 | 146.27 | 145.99 | 146.2 | 3825704.0 |
| 2007-08-07 09:55:00 | SPY | ETF | 146.19 | 146.4 | 146.17 | 146.4 | 3302509.0 |
| 2007-08-07 10:00:00 | SPY | ETF | 146.39 | 146.7 | 146.34 | 146.6 | 5719582.0 |
| 2007-08-07 10:05:00 | SPY | ETF | 146.6 | 146.8 | 146.58 | 146.75 | 2506853.0 |
| 2007-08-07 10:10:00 | SPY | ETF | 146.75 | 146.78 | 146.56 | 146.57 | 3197930.0 |
| 2007-08-07 10:15:00 | SPY | ETF | 146.57 | 146.85 | 146.56 | 146.66 | 2720436.0 |
| 2007-08-07 10:20:00 | SPY | ETF | 146.66 | 146.74 | 146.49 | 146.49 | 1709000.0 |
| 2007-08-07 10:25:00 | SPY | ETF | 146.49 | 146.64 | 146.47 | 146.51 | 1261127.0 |
| 2007-08-07 10:30:00 | SPY | ETF | 146.51 | 146.52 | 146.37 | 146.5 | 1470564.0 |
| 2007-08-07 10:35:00 | SPY | ETF | 146.49 | 146.51 | 146.29 | 146.3 | 1254100.0 |
| 2007-08-07 10:40:00 | SPY | ETF | 146.3 | 146.35 | 146.2 | 146.27 | 2715402.0 |
| 2007-08-07 10:45:00 | SPY | ETF | 146.27 | 146.51 | 146.26 | 146.5 | 972091.0 |
| 2007-08-07 10:50:00 | SPY | ETF | 146.48 | 146.57 | 146.45 | 146.45 | 1158408.0 |
| 2007-08-07 10:55:00 | SPY | ETF | 146.45 | 146.48 | 146.34 | 146.45 | 921800.0 |
| 2007-08-07 11:00:00 | SPY | ETF | 146.46 | 146.63 | 146.42 | 146.6 | 986100.0 |
> showing 50 of 18,338 rows — these rows as CSV