PREVIEW / etf_5min / 2007-11-14
file: by_date/etf_5min/2007/2007-11-14.parquet size: 398 KB rows: 19,663
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-11-14 04:10:00 | SPY | ETF | 148.27 | 148.27 | 148.27 | 148.27 | 2000.0 |
| 2007-11-14 04:15:00 | SPY | ETF | 148.27 | 148.27 | 148.27 | 148.27 | 1000.0 |
| 2007-11-14 04:35:00 | SPY | ETF | 148.47 | 148.47 | 148.47 | 148.47 | 1000.0 |
| 2007-11-14 04:55:00 | SPY | ETF | 148.34 | 148.34 | 148.34 | 148.34 | 2000.0 |
| 2007-11-14 05:25:00 | SPY | ETF | 148.34 | 148.34 | 148.34 | 148.34 | 1000.0 |
| 2007-11-14 05:40:00 | SPY | ETF | 148.39 | 148.39 | 148.39 | 148.39 | 25000.0 |
| 2007-11-14 05:45:00 | SPY | ETF | 148.48 | 148.49 | 148.48 | 148.49 | 26000.0 |
| 2007-11-14 05:55:00 | SPY | ETF | 148.42 | 148.42 | 148.42 | 148.42 | 12500.0 |
| 2007-11-14 06:35:00 | SPY | ETF | 148.07 | 148.07 | 148.07 | 148.07 | 50000.0 |
| 2007-11-14 06:40:00 | SPY | ETF | 147.97 | 147.97 | 147.96 | 147.96 | 15000.0 |
| 2007-11-14 06:55:00 | SPY | ETF | 147.91 | 147.91 | 147.91 | 147.91 | 15000.0 |
| 2007-11-14 07:00:00 | SPY | ETF | 147.94 | 147.95 | 147.67 | 147.67 | 112500.0 |
| 2007-11-14 07:05:00 | SPY | ETF | 147.65 | 147.77 | 147.65 | 147.77 | 8100.0 |
| 2007-11-14 07:10:00 | SPY | ETF | 147.68 | 147.69 | 147.61 | 147.65 | 350800.0 |
| 2007-11-14 07:15:00 | SPY | ETF | 147.72 | 147.72 | 147.58 | 147.65 | 129600.0 |
| 2007-11-14 07:20:00 | SPY | ETF | 147.65 | 147.79 | 147.65 | 147.79 | 34100.0 |
| 2007-11-14 07:25:00 | SPY | ETF | 147.79 | 147.8 | 147.73 | 147.73 | 64500.0 |
| 2007-11-14 07:30:00 | SPY | ETF | 147.79 | 147.83 | 147.79 | 147.81 | 26700.0 |
| 2007-11-14 07:35:00 | SPY | ETF | 147.81 | 147.81 | 147.73 | 147.79 | 39800.0 |
| 2007-11-14 07:40:00 | SPY | ETF | 147.8 | 147.95 | 147.77 | 147.95 | 84200.0 |
| 2007-11-14 07:45:00 | SPY | ETF | 147.93 | 148.06 | 147.93 | 148.06 | 85400.0 |
| 2007-11-14 07:50:00 | SPY | ETF | 148.05 | 148.1 | 148.03 | 148.09 | 206000.0 |
| 2007-11-14 07:55:00 | SPY | ETF | 148.09 | 148.15 | 148.06 | 148.15 | 126600.0 |
| 2007-11-14 08:00:00 | SPY | ETF | 148.14 | 148.36 | 147.8 | 148.09 | 2295600.0 |
| 2007-11-14 08:05:00 | SPY | ETF | 148.11 | 148.11 | 147.62 | 148.06 | 1011700.0 |
| 2007-11-14 08:10:00 | SPY | ETF | 148.09 | 148.26 | 148.07 | 148.26 | 1200200.0 |
| 2007-11-14 08:15:00 | SPY | ETF | 148.26 | 148.33 | 148.25 | 148.25 | 244500.0 |
| 2007-11-14 08:20:00 | SPY | ETF | 148.25 | 148.35 | 148.25 | 148.34 | 119200.0 |
| 2007-11-14 08:25:00 | SPY | ETF | 148.35 | 148.57 | 148.35 | 148.56 | 476100.0 |
| 2007-11-14 08:30:00 | SPY | ETF | 148.59 | 149.25 | 148.56 | 149.01 | 9260800.0 |
| 2007-11-14 08:35:00 | SPY | ETF | 149.02 | 149.09 | 148.92 | 149.07 | 1434300.0 |
| 2007-11-14 08:40:00 | SPY | ETF | 149.07 | 149.4 | 149.07 | 149.39 | 1962400.0 |
| 2007-11-14 08:45:00 | SPY | ETF | 149.4 | 149.41 | 149.2 | 149.2 | 575900.0 |
| 2007-11-14 08:50:00 | SPY | ETF | 149.2 | 149.2 | 149.08 | 149.11 | 896900.0 |
| 2007-11-14 08:55:00 | SPY | ETF | 149.13 | 149.21 | 149.06 | 149.1 | 630300.0 |
| 2007-11-14 09:00:00 | SPY | ETF | 149.09 | 149.19 | 149.02 | 149.17 | 653600.0 |
| 2007-11-14 09:05:00 | SPY | ETF | 149.14 | 149.23 | 149.09 | 149.23 | 233300.0 |
| 2007-11-14 09:10:00 | SPY | ETF | 149.23 | 149.25 | 149.1 | 149.18 | 916200.0 |
| 2007-11-14 09:15:00 | SPY | ETF | 149.19 | 149.26 | 149.17 | 149.18 | 302700.0 |
| 2007-11-14 09:20:00 | SPY | ETF | 149.19 | 149.25 | 149.1 | 149.23 | 721500.0 |
| 2007-11-14 09:25:00 | SPY | ETF | 149.24 | 149.26 | 149.22 | 149.22 | 562700.0 |
| 2007-11-14 09:30:00 | SPY | ETF | 149.22 | 149.26 | 148.95 | 149.1 | 5559214.0 |
| 2007-11-14 09:35:00 | SPY | ETF | 149.1 | 149.36 | 149.02 | 149.34 | 4147996.0 |
| 2007-11-14 09:40:00 | SPY | ETF | 149.34 | 149.4 | 148.97 | 149.04 | 6146750.0 |
| 2007-11-14 09:45:00 | SPY | ETF | 149.04 | 149.16 | 148.79 | 148.8 | 4924172.0 |
| 2007-11-14 09:50:00 | SPY | ETF | 148.81 | 148.86 | 148.64 | 148.68 | 3621992.0 |
| 2007-11-14 09:55:00 | SPY | ETF | 148.68 | 149.1 | 148.51 | 148.66 | 4595515.0 |
| 2007-11-14 10:00:00 | SPY | ETF | 148.66 | 148.95 | 148.6 | 148.76 | 4144201.0 |
| 2007-11-14 10:05:00 | SPY | ETF | 148.75 | 148.82 | 148.43 | 148.48 | 2969305.0 |
| 2007-11-14 10:10:00 | SPY | ETF | 148.47 | 148.75 | 148.3 | 148.73 | 7184963.0 |
> showing 50 of 19,663 rows — these rows as CSV