PREVIEW / etf_5min / 2007-12-12
file: by_date/etf_5min/2007/2007-12-12.parquet size: 452 KB rows: 20,989
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-12 04:10:00 | SPY | ETF | 149.27 | 149.27 | 149.24 | 149.24 | 7000.0 |
| 2007-12-12 04:15:00 | SPY | ETF | 149.24 | 149.24 | 149.24 | 149.24 | 5900.0 |
| 2007-12-12 04:30:00 | SPY | ETF | 149.27 | 149.27 | 149.27 | 149.27 | 1000.0 |
| 2007-12-12 04:35:00 | SPY | ETF | 149.3 | 149.44 | 149.3 | 149.37 | 17200.0 |
| 2007-12-12 04:40:00 | SPY | ETF | 149.37 | 149.41 | 149.37 | 149.41 | 1500.0 |
| 2007-12-12 04:55:00 | SPY | ETF | 149.22 | 149.22 | 149.22 | 149.22 | 1000.0 |
| 2007-12-12 05:00:00 | SPY | ETF | 149.3 | 149.3 | 149.3 | 149.3 | 1000.0 |
| 2007-12-12 05:30:00 | SPY | ETF | 149.14 | 149.14 | 149.13 | 149.13 | 1500.0 |
| 2007-12-12 06:05:00 | SPY | ETF | 149.22 | 149.22 | 149.22 | 149.22 | 700.0 |
| 2007-12-12 06:10:00 | SPY | ETF | 149.29 | 149.34 | 149.29 | 149.31 | 27400.0 |
| 2007-12-12 06:15:00 | SPY | ETF | 149.29 | 149.31 | 149.29 | 149.31 | 29500.0 |
| 2007-12-12 06:25:00 | SPY | ETF | 149.32 | 149.4 | 149.32 | 149.4 | 54500.0 |
| 2007-12-12 06:30:00 | SPY | ETF | 149.45 | 149.46 | 149.45 | 149.45 | 21900.0 |
| 2007-12-12 06:35:00 | SPY | ETF | 149.45 | 149.45 | 149.45 | 149.45 | 53000.0 |
| 2007-12-12 06:40:00 | SPY | ETF | 149.49 | 149.49 | 149.41 | 149.43 | 45500.0 |
| 2007-12-12 06:45:00 | SPY | ETF | 149.42 | 149.5 | 149.42 | 149.5 | 26200.0 |
| 2007-12-12 06:50:00 | SPY | ETF | 149.56 | 149.56 | 149.45 | 149.45 | 102000.0 |
| 2007-12-12 06:55:00 | SPY | ETF | 149.47 | 149.49 | 149.47 | 149.49 | 20600.0 |
| 2007-12-12 07:00:00 | SPY | ETF | 149.45 | 149.45 | 149.33 | 149.38 | 155300.0 |
| 2007-12-12 07:05:00 | SPY | ETF | 149.38 | 149.38 | 149.2 | 149.2 | 199800.0 |
| 2007-12-12 07:10:00 | SPY | ETF | 149.16 | 149.24 | 149.1 | 149.13 | 130900.0 |
| 2007-12-12 07:15:00 | SPY | ETF | 149.12 | 149.17 | 149.12 | 149.14 | 170500.0 |
| 2007-12-12 07:20:00 | SPY | ETF | 149.14 | 149.17 | 149.11 | 149.11 | 115400.0 |
| 2007-12-12 07:25:00 | SPY | ETF | 149.14 | 149.23 | 149.14 | 149.16 | 393100.0 |
| 2007-12-12 07:30:00 | SPY | ETF | 149.18 | 149.21 | 149.13 | 149.19 | 129900.0 |
| 2007-12-12 07:35:00 | SPY | ETF | 149.15 | 149.5 | 149.15 | 149.43 | 229300.0 |
| 2007-12-12 07:40:00 | SPY | ETF | 149.43 | 149.55 | 149.4 | 149.48 | 280000.0 |
| 2007-12-12 07:45:00 | SPY | ETF | 149.53 | 149.74 | 149.53 | 149.67 | 233900.0 |
| 2007-12-12 07:50:00 | SPY | ETF | 149.67 | 149.74 | 149.6 | 149.65 | 332300.0 |
| 2007-12-12 07:55:00 | SPY | ETF | 149.66 | 149.68 | 149.52 | 149.58 | 241800.0 |
| 2007-12-12 08:00:00 | SPY | ETF | 149.59 | 149.68 | 149.49 | 149.66 | 452800.0 |
| 2007-12-12 08:05:00 | SPY | ETF | 149.65 | 149.66 | 148.26 | 148.33 | 479000.0 |
| 2007-12-12 08:10:00 | SPY | ETF | 149.46 | 149.49 | 148.424 | 149.19 | 750600.0 |
| 2007-12-12 08:15:00 | SPY | ETF | 149.2 | 149.43 | 149.07 | 149.19 | 778500.0 |
| 2007-12-12 08:20:00 | SPY | ETF | 149.19 | 149.34 | 149.08 | 149.22 | 1106300.0 |
| 2007-12-12 08:25:00 | SPY | ETF | 149.23 | 149.43 | 149.22 | 149.42 | 360400.0 |
| 2007-12-12 08:30:00 | SPY | ETF | 149.4 | 149.66 | 149.29 | 149.47 | 670500.0 |
| 2007-12-12 08:35:00 | SPY | ETF | 149.46 | 149.64 | 149.46 | 149.57 | 635200.0 |
| 2007-12-12 08:40:00 | SPY | ETF | 149.58 | 149.65 | 149.49 | 149.51 | 675800.0 |
| 2007-12-12 08:45:00 | SPY | ETF | 149.51 | 149.54 | 149.45 | 149.52 | 698300.0 |
| 2007-12-12 08:50:00 | SPY | ETF | 149.5 | 149.56 | 149.43 | 149.51 | 341600.0 |
| 2007-12-12 08:55:00 | SPY | ETF | 149.52 | 149.57 | 149.4 | 149.41 | 1085700.0 |
| 2007-12-12 09:00:00 | SPY | ETF | 149.4 | 152.0 | 149.4 | 151.32 | 16167159.0 |
| 2007-12-12 09:05:00 | SPY | ETF | 151.3 | 151.34 | 150.99 | 151.02 | 7896978.0 |
| 2007-12-12 09:10:00 | SPY | ETF | 151.02 | 151.29 | 150.92 | 151.09 | 5165403.0 |
| 2007-12-12 09:15:00 | SPY | ETF | 151.09 | 151.3 | 151.0 | 151.18 | 1703768.0 |
| 2007-12-12 09:20:00 | SPY | ETF | 151.18 | 151.67 | 151.16 | 151.64 | 1448982.0 |
| 2007-12-12 09:25:00 | SPY | ETF | 151.65 | 151.81 | 151.43 | 151.51 | 1328806.0 |
| 2007-12-12 09:30:00 | SPY | ETF | 151.54 | 151.65 | 151.27 | 151.63 | 6956312.0 |
| 2007-12-12 09:35:00 | SPY | ETF | 151.64 | 151.75 | 151.13 | 151.18 | 7157539.0 |
> showing 50 of 20,989 rows — these rows as CSV