PREVIEW / etf_5min / 2006-06-09
file: by_date/etf_5min/2006/2006-06-09.parquet size: 201 KB rows: 9,688
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-09 04:55:00 | SPY | ETF | 126.15 | 126.15 | 126.15 | 126.15 | 3000.0 |
| 2006-06-09 05:45:00 | SPY | ETF | 126.01 | 126.01 | 126.01 | 126.01 | 19100.0 |
| 2006-06-09 05:50:00 | SPY | ETF | 126.08 | 126.08 | 126.08 | 126.08 | 900.0 |
| 2006-06-09 05:55:00 | SPY | ETF | 126.11 | 126.13 | 126.11 | 126.11 | 30000.0 |
| 2006-06-09 06:00:00 | SPY | ETF | 126.06 | 126.06 | 126.06 | 126.06 | 25000.0 |
| 2006-06-09 06:05:00 | SPY | ETF | 126.15 | 126.16 | 126.15 | 126.16 | 50000.0 |
| 2006-06-09 06:45:00 | SPY | ETF | 126.15 | 126.16 | 126.15 | 126.16 | 30000.0 |
| 2006-06-09 07:00:00 | SPY | ETF | 126.26 | 126.26 | 126.26 | 126.26 | 300.0 |
| 2006-06-09 07:05:00 | SPY | ETF | 126.28 | 126.28 | 126.27 | 126.28 | 1100.0 |
| 2006-06-09 07:10:00 | SPY | ETF | 126.35 | 126.35 | 126.35 | 126.35 | 100.0 |
| 2006-06-09 07:15:00 | SPY | ETF | 126.35 | 126.43 | 126.35 | 126.38 | 8100.0 |
| 2006-06-09 07:25:00 | SPY | ETF | 126.3 | 126.35 | 126.3 | 126.35 | 2800.0 |
| 2006-06-09 07:30:00 | SPY | ETF | 126.3 | 126.34 | 126.3 | 126.34 | 5700.0 |
| 2006-06-09 07:35:00 | SPY | ETF | 126.3 | 126.3 | 126.3 | 126.3 | 500.0 |
| 2006-06-09 07:40:00 | SPY | ETF | 126.3 | 126.3 | 126.3 | 126.3 | 2000.0 |
| 2006-06-09 07:45:00 | SPY | ETF | 126.3 | 126.33 | 126.3 | 126.33 | 7000.0 |
| 2006-06-09 08:00:00 | SPY | ETF | 126.3 | 126.49 | 126.25 | 126.31 | 142300.0 |
| 2006-06-09 08:05:00 | SPY | ETF | 126.26 | 126.33 | 126.26 | 126.28 | 36600.0 |
| 2006-06-09 08:10:00 | SPY | ETF | 126.28 | 126.32 | 126.28 | 126.3 | 58800.0 |
| 2006-06-09 08:15:00 | SPY | ETF | 126.29 | 126.4 | 126.29 | 126.37 | 420400.0 |
| 2006-06-09 08:20:00 | SPY | ETF | 126.34 | 126.34 | 126.29 | 126.31 | 30400.0 |
| 2006-06-09 08:25:00 | SPY | ETF | 126.3 | 126.35 | 126.29 | 126.33 | 137700.0 |
| 2006-06-09 08:30:00 | SPY | ETF | 126.33 | 126.33 | 126.05 | 126.19 | 569900.0 |
| 2006-06-09 08:35:00 | SPY | ETF | 126.18 | 126.23 | 126.06 | 126.23 | 91200.0 |
| 2006-06-09 08:40:00 | SPY | ETF | 126.16 | 126.295 | 126.13 | 126.22 | 338600.0 |
| 2006-06-09 08:45:00 | SPY | ETF | 126.2 | 126.24 | 126.14 | 126.2 | 124300.0 |
| 2006-06-09 08:50:00 | SPY | ETF | 126.19 | 126.2 | 126.18 | 126.2 | 409100.0 |
| 2006-06-09 08:55:00 | SPY | ETF | 126.22 | 126.24 | 126.21 | 126.24 | 33300.0 |
| 2006-06-09 09:00:00 | SPY | ETF | 126.23 | 126.31 | 126.23 | 126.3 | 109700.0 |
| 2006-06-09 09:05:00 | SPY | ETF | 126.3 | 126.35 | 126.29 | 126.32 | 154200.0 |
| 2006-06-09 09:10:00 | SPY | ETF | 126.33 | 126.34 | 126.33 | 126.34 | 19600.0 |
| 2006-06-09 09:15:00 | SPY | ETF | 126.33 | 126.33 | 125.76 | 126.31 | 31300.0 |
| 2006-06-09 09:20:00 | SPY | ETF | 126.31 | 126.37 | 126.31 | 126.36 | 15500.0 |
| 2006-06-09 09:25:00 | SPY | ETF | 126.33 | 126.38 | 126.31 | 126.35 | 183400.0 |
| 2006-06-09 09:30:00 | SPY | ETF | 126.36 | 126.42 | 126.17 | 126.17 | 2324600.0 |
| 2006-06-09 09:35:00 | SPY | ETF | 126.17 | 126.2 | 126.0 | 126.09 | 2099200.0 |
| 2006-06-09 09:40:00 | SPY | ETF | 126.08 | 126.13 | 125.91 | 126.13 | 1693300.0 |
| 2006-06-09 09:45:00 | SPY | ETF | 126.13 | 126.44 | 126.09 | 126.38 | 2714200.0 |
| 2006-06-09 09:50:00 | SPY | ETF | 126.37 | 126.46 | 126.23 | 126.43 | 1222600.0 |
| 2006-06-09 09:55:00 | SPY | ETF | 126.43 | 126.61 | 126.36 | 126.48 | 1885100.0 |
| 2006-06-09 10:00:00 | SPY | ETF | 126.47 | 126.58 | 126.35 | 126.39 | 1878000.0 |
| 2006-06-09 10:05:00 | SPY | ETF | 126.39 | 126.44 | 126.22 | 126.44 | 1022000.0 |
| 2006-06-09 10:10:00 | SPY | ETF | 126.44 | 126.5 | 126.32 | 126.3499 | 743600.0 |
| 2006-06-09 10:15:00 | SPY | ETF | 126.35 | 126.4 | 126.22 | 126.39 | 869100.0 |
| 2006-06-09 10:20:00 | SPY | ETF | 126.39 | 126.52 | 126.34 | 126.45 | 720200.0 |
| 2006-06-09 10:25:00 | SPY | ETF | 126.44 | 126.54 | 126.4 | 126.54 | 706100.0 |
| 2006-06-09 10:30:00 | SPY | ETF | 126.5 | 126.6 | 126.42 | 126.45 | 1164700.0 |
| 2006-06-09 10:35:00 | SPY | ETF | 126.44 | 126.57 | 126.43 | 126.54 | 985500.0 |
| 2006-06-09 10:40:00 | SPY | ETF | 126.54 | 126.67 | 126.45 | 126.51 | 2112200.0 |
| 2006-06-09 10:45:00 | SPY | ETF | 126.51 | 126.56 | 126.37 | 126.45 | 1945800.0 |
> showing 50 of 9,688 rows — these rows as CSV