PREVIEW / etf_5min / 2007-12-06
file: by_date/etf_5min/2007/2007-12-06.parquet size: 430 KB rows: 21,058
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-06 04:25:00 | SPY | ETF | 149.1 | 149.1 | 149.04 | 149.04 | 2100.0 |
| 2007-12-06 04:45:00 | SPY | ETF | 149.14 | 149.14 | 149.14 | 149.14 | 1000.0 |
| 2007-12-06 06:00:00 | SPY | ETF | 149.36 | 149.36 | 149.36 | 149.36 | 12500.0 |
| 2007-12-06 06:05:00 | SPY | ETF | 149.36 | 149.36 | 149.36 | 149.36 | 10000.0 |
| 2007-12-06 06:10:00 | SPY | ETF | 149.43 | 149.43 | 149.43 | 149.43 | 12500.0 |
| 2007-12-06 06:30:00 | SPY | ETF | 149.49 | 149.58 | 149.49 | 149.58 | 20100.0 |
| 2007-12-06 06:35:00 | SPY | ETF | 149.56 | 149.56 | 149.53 | 149.53 | 6700.0 |
| 2007-12-06 06:55:00 | SPY | ETF | 149.45 | 149.48 | 149.35 | 149.45 | 47800.0 |
| 2007-12-06 07:00:00 | SPY | ETF | 149.66 | 149.67 | 149.5 | 149.63 | 158500.0 |
| 2007-12-06 07:05:00 | SPY | ETF | 149.62 | 149.62 | 149.5 | 149.5 | 20400.0 |
| 2007-12-06 07:10:00 | SPY | ETF | 149.57 | 149.57 | 149.45 | 149.45 | 142000.0 |
| 2007-12-06 07:15:00 | SPY | ETF | 149.45 | 149.45 | 149.35 | 149.35 | 44100.0 |
| 2007-12-06 07:20:00 | SPY | ETF | 149.42 | 149.45 | 149.37 | 149.37 | 51600.0 |
| 2007-12-06 07:25:00 | SPY | ETF | 149.4 | 149.4 | 149.36 | 149.36 | 206800.0 |
| 2007-12-06 07:30:00 | SPY | ETF | 149.36 | 149.36 | 149.26 | 149.33 | 123200.0 |
| 2007-12-06 07:35:00 | SPY | ETF | 149.33 | 149.35 | 149.27 | 149.27 | 26100.0 |
| 2007-12-06 07:40:00 | SPY | ETF | 149.31 | 149.32 | 149.26 | 149.26 | 22400.0 |
| 2007-12-06 07:45:00 | SPY | ETF | 149.28 | 149.28 | 149.05 | 149.07 | 212700.0 |
| 2007-12-06 07:50:00 | SPY | ETF | 149.1 | 149.11 | 149.0 | 149.05 | 219900.0 |
| 2007-12-06 07:55:00 | SPY | ETF | 149.06 | 149.17 | 149.05 | 149.17 | 188800.0 |
| 2007-12-06 08:00:00 | SPY | ETF | 149.17 | 149.35 | 149.11 | 149.11 | 108900.0 |
| 2007-12-06 08:05:00 | SPY | ETF | 149.19 | 149.2 | 149.05 | 149.05 | 51400.0 |
| 2007-12-06 08:10:00 | SPY | ETF | 149.1 | 149.12 | 149.07 | 149.08 | 46300.0 |
| 2007-12-06 08:15:00 | SPY | ETF | 149.07 | 149.12 | 149.06 | 149.1 | 34300.0 |
| 2007-12-06 08:20:00 | SPY | ETF | 149.11 | 149.11 | 149.01 | 149.05 | 26000.0 |
| 2007-12-06 08:25:00 | SPY | ETF | 149.04 | 149.05 | 148.97 | 149.01 | 195500.0 |
| 2007-12-06 08:30:00 | SPY | ETF | 149.05 | 149.2 | 148.99 | 149.15 | 144900.0 |
| 2007-12-06 08:35:00 | SPY | ETF | 149.13 | 149.15 | 149.01 | 149.01 | 46000.0 |
| 2007-12-06 08:40:00 | SPY | ETF | 149.01 | 149.02 | 148.74 | 148.74 | 437300.0 |
| 2007-12-06 08:45:00 | SPY | ETF | 148.75 | 148.79 | 148.71 | 148.72 | 226100.0 |
| 2007-12-06 08:50:00 | SPY | ETF | 148.71 | 148.8 | 148.7 | 148.8 | 144800.0 |
| 2007-12-06 08:55:00 | SPY | ETF | 148.8 | 148.8 | 148.42 | 148.43 | 394300.0 |
| 2007-12-06 09:00:00 | SPY | ETF | 148.42 | 148.54 | 148.39 | 148.51 | 425900.0 |
| 2007-12-06 09:05:00 | SPY | ETF | 148.48 | 148.51 | 148.38 | 148.5 | 224100.0 |
| 2007-12-06 09:10:00 | SPY | ETF | 148.49 | 148.54 | 148.47 | 148.49 | 223000.0 |
| 2007-12-06 09:15:00 | SPY | ETF | 148.49 | 148.56 | 148.49 | 148.56 | 82100.0 |
| 2007-12-06 09:20:00 | SPY | ETF | 148.57 | 148.57 | 148.5 | 148.54 | 71400.0 |
| 2007-12-06 09:25:00 | SPY | ETF | 148.54 | 148.62 | 148.52 | 148.61 | 51200.0 |
| 2007-12-06 09:30:00 | SPY | ETF | 148.63 | 148.75 | 148.57 | 148.74 | 1197190.0 |
| 2007-12-06 09:35:00 | SPY | ETF | 148.72 | 148.91 | 148.71 | 148.88 | 1977022.0 |
| 2007-12-06 09:40:00 | SPY | ETF | 148.8795 | 149.02 | 148.87 | 148.92 | 2061300.0 |
| 2007-12-06 09:45:00 | SPY | ETF | 148.92 | 149.17 | 148.89 | 149.15 | 2064639.0 |
| 2007-12-06 09:50:00 | SPY | ETF | 149.16 | 149.23 | 149.06 | 149.16 | 1573000.0 |
| 2007-12-06 09:55:00 | SPY | ETF | 149.16 | 149.34 | 149.14 | 149.16 | 2208966.0 |
| 2007-12-06 10:00:00 | SPY | ETF | 149.16 | 149.28 | 149.07 | 149.24 | 1586553.0 |
| 2007-12-06 10:05:00 | SPY | ETF | 149.24 | 149.24 | 149.11 | 149.24 | 1199250.0 |
| 2007-12-06 10:10:00 | SPY | ETF | 149.24 | 149.44 | 149.21 | 149.24 | 3437627.0 |
| 2007-12-06 10:15:00 | SPY | ETF | 149.23 | 149.31 | 149.1 | 149.14 | 1128954.0 |
| 2007-12-06 10:20:00 | SPY | ETF | 149.13 | 149.32 | 149.04 | 149.05 | 2872474.0 |
| 2007-12-06 10:25:00 | SPY | ETF | 149.05 | 149.2 | 149.0 | 149.11 | 1683000.0 |
> showing 50 of 21,058 rows — these rows as CSV