PREVIEW / etf_5min / 2007-09-10
file: by_date/etf_5min/2007/2007-09-10.parquet size: 371 KB rows: 17,444
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-09-10 05:10:00 | SPY | ETF | 146.42 | 146.42 | 146.42 | 146.42 | 300.0 |
| 2007-09-10 06:20:00 | SPY | ETF | 146.04 | 146.04 | 146.04 | 146.04 | 300.0 |
| 2007-09-10 06:30:00 | SPY | ETF | 146.03 | 146.1 | 146.03 | 146.1 | 2000.0 |
| 2007-09-10 06:35:00 | SPY | ETF | 146.05 | 146.15 | 146.05 | 146.15 | 19900.0 |
| 2007-09-10 06:40:00 | SPY | ETF | 146.09 | 146.09 | 146.09 | 146.09 | 5000.0 |
| 2007-09-10 06:45:00 | SPY | ETF | 146.05 | 146.06 | 146.05 | 146.06 | 12500.0 |
| 2007-09-10 06:50:00 | SPY | ETF | 146.08 | 146.08 | 146.08 | 146.08 | 2300.0 |
| 2007-09-10 06:55:00 | SPY | ETF | 146.15 | 146.22 | 146.15 | 146.22 | 44000.0 |
| 2007-09-10 07:00:00 | SPY | ETF | 146.33 | 146.35 | 146.23 | 146.28 | 63800.0 |
| 2007-09-10 07:05:00 | SPY | ETF | 146.35 | 146.38 | 146.28 | 146.38 | 8200.0 |
| 2007-09-10 07:10:00 | SPY | ETF | 146.36 | 146.44 | 146.3 | 146.31 | 20500.0 |
| 2007-09-10 07:15:00 | SPY | ETF | 146.21 | 146.21 | 146.18 | 146.18 | 4900.0 |
| 2007-09-10 07:20:00 | SPY | ETF | 146.18 | 146.18 | 146.13 | 146.13 | 15000.0 |
| 2007-09-10 07:25:00 | SPY | ETF | 146.13 | 146.18 | 146.09 | 146.13 | 13700.0 |
| 2007-09-10 07:30:00 | SPY | ETF | 146.15 | 146.15 | 146.15 | 146.15 | 5000.0 |
| 2007-09-10 07:35:00 | SPY | ETF | 146.15 | 146.28 | 146.09 | 146.23 | 216200.0 |
| 2007-09-10 07:40:00 | SPY | ETF | 146.21 | 146.21 | 146.11 | 146.11 | 90000.0 |
| 2007-09-10 07:45:00 | SPY | ETF | 146.13 | 146.13 | 146.02 | 146.02 | 82200.0 |
| 2007-09-10 07:50:00 | SPY | ETF | 146.02 | 146.03 | 145.93 | 145.96 | 162200.0 |
| 2007-09-10 07:55:00 | SPY | ETF | 145.93 | 145.96 | 145.87 | 145.9 | 150400.0 |
| 2007-09-10 08:00:00 | SPY | ETF | 145.93 | 146.24 | 145.9 | 146.03 | 264600.0 |
| 2007-09-10 08:05:00 | SPY | ETF | 146.03 | 146.28 | 146.02 | 146.28 | 46900.0 |
| 2007-09-10 08:10:00 | SPY | ETF | 146.29 | 146.3 | 146.1 | 146.16 | 140200.0 |
| 2007-09-10 08:15:00 | SPY | ETF | 146.15 | 146.18 | 146.0 | 146.09 | 165200.0 |
| 2007-09-10 08:20:00 | SPY | ETF | 146.08 | 146.14 | 145.9 | 146.08 | 603700.0 |
| 2007-09-10 08:25:00 | SPY | ETF | 146.08 | 146.19 | 146.08 | 146.19 | 112400.0 |
| 2007-09-10 08:30:00 | SPY | ETF | 146.17 | 146.28 | 146.17 | 146.22 | 159400.0 |
| 2007-09-10 08:35:00 | SPY | ETF | 146.21 | 146.21 | 146.15 | 146.17 | 92900.0 |
| 2007-09-10 08:40:00 | SPY | ETF | 146.16 | 146.29 | 146.16 | 146.27 | 81400.0 |
| 2007-09-10 08:45:00 | SPY | ETF | 146.27 | 146.33 | 146.17 | 146.27 | 222700.0 |
| 2007-09-10 08:50:00 | SPY | ETF | 146.28 | 146.36 | 146.23 | 146.32 | 1043600.0 |
| 2007-09-10 08:55:00 | SPY | ETF | 146.32 | 146.43 | 146.31 | 146.4 | 258800.0 |
| 2007-09-10 09:00:00 | SPY | ETF | 146.4 | 146.8 | 146.4 | 146.62 | 2216800.0 |
| 2007-09-10 09:05:00 | SPY | ETF | 146.65 | 146.76 | 146.58 | 146.63 | 333000.0 |
| 2007-09-10 09:10:00 | SPY | ETF | 146.63 | 146.63 | 146.54 | 146.56 | 127900.0 |
| 2007-09-10 09:15:00 | SPY | ETF | 146.58 | 146.58 | 146.47 | 146.48 | 119500.0 |
| 2007-09-10 09:20:00 | SPY | ETF | 146.48 | 146.5 | 146.07 | 146.44 | 10157200.0 |
| 2007-09-10 09:25:00 | SPY | ETF | 146.46 | 146.53 | 146.4 | 146.5 | 136500.0 |
| 2007-09-10 09:30:00 | SPY | ETF | 146.52 | 146.72 | 146.37 | 146.58 | 3373172.0 |
| 2007-09-10 09:35:00 | SPY | ETF | 146.58 | 146.58 | 146.27 | 146.349 | 1628300.0 |
| 2007-09-10 09:40:00 | SPY | ETF | 146.35 | 146.39 | 146.21 | 146.25 | 1663700.0 |
| 2007-09-10 09:45:00 | SPY | ETF | 146.25 | 146.31 | 146.1 | 146.29 | 1886300.0 |
| 2007-09-10 09:50:00 | SPY | ETF | 146.29 | 146.38 | 146.03 | 146.08 | 1551300.0 |
| 2007-09-10 09:55:00 | SPY | ETF | 146.09 | 146.18 | 145.96 | 145.97 | 1756000.0 |
| 2007-09-10 10:00:00 | SPY | ETF | 145.97 | 146.05 | 145.86 | 145.9 | 2504300.0 |
| 2007-09-10 10:05:00 | SPY | ETF | 145.9 | 146.11 | 145.87 | 145.925 | 1594700.0 |
| 2007-09-10 10:10:00 | SPY | ETF | 145.93 | 145.93 | 145.69 | 145.74 | 4512600.0 |
| 2007-09-10 10:15:00 | SPY | ETF | 145.73 | 145.8 | 145.62 | 145.77 | 2252700.0 |
| 2007-09-10 10:20:00 | SPY | ETF | 145.77 | 145.93 | 145.75 | 145.93 | 1487300.0 |
| 2007-09-10 10:25:00 | SPY | ETF | 145.92 | 145.93 | 145.49 | 145.49 | 1988700.0 |
> showing 50 of 17,444 rows — these rows as CSV