PREVIEW / etf_30min / 2006-03-15
file: by_date/etf_30min/2006/2006-03-15.parquet size: 61 KB rows: 2,187
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-03-15 06:30:00 | SPY | ETF | 130.19 | 130.19 | 130.18 | 130.19 | 28000.0 |
| 2006-03-15 07:00:00 | SPY | ETF | 130.2 | 130.2 | 130.16 | 130.2 | 54200.0 |
| 2006-03-15 07:30:00 | SPY | ETF | 130.17 | 130.17 | 130.11 | 130.11 | 49600.0 |
| 2006-03-15 08:00:00 | SPY | ETF | 130.13 | 130.3 | 130.12 | 130.22 | 288600.0 |
| 2006-03-15 08:30:00 | SPY | ETF | 130.24 | 130.28 | 130.1 | 130.16 | 436400.0 |
| 2006-03-15 09:00:00 | SPY | ETF | 130.18 | 130.21 | 130.14 | 130.14 | 23000.0 |
| 2006-03-15 09:30:00 | SPY | ETF | 130.15 | 130.25 | 129.98 | 130.18 | 5152200.0 |
| 2006-03-15 10:00:00 | SPY | ETF | 130.18 | 130.22 | 129.98 | 130.11 | 2864400.0 |
| 2006-03-15 10:30:00 | SPY | ETF | 130.09 | 130.23 | 129.9 | 129.97 | 3623400.0 |
| 2006-03-15 11:00:00 | SPY | ETF | 129.97 | 130.12 | 129.93 | 130.06 | 3226000.0 |
| 2006-03-15 11:30:00 | SPY | ETF | 130.05 | 130.08 | 129.85 | 129.95 | 2241600.0 |
| 2006-03-15 12:00:00 | SPY | ETF | 129.93 | 130.14 | 129.87 | 130.03 | 1688900.0 |
| 2006-03-15 12:30:00 | SPY | ETF | 130.0376 | 130.2 | 130.02 | 130.1 | 1460400.0 |
| 2006-03-15 13:00:00 | SPY | ETF | 130.1 | 130.16 | 130.04 | 130.1 | 854300.0 |
| 2006-03-15 13:30:00 | SPY | ETF | 130.1 | 130.29 | 130.08 | 130.24 | 1828000.0 |
| 2006-03-15 14:00:00 | SPY | ETF | 130.23 | 130.7 | 130.15 | 130.67 | 7992100.0 |
| 2006-03-15 14:30:00 | SPY | ETF | 130.67 | 130.76 | 130.55 | 130.57 | 4154400.0 |
| 2006-03-15 15:00:00 | SPY | ETF | 130.57 | 130.85 | 130.56 | 130.76 | 3829000.0 |
| 2006-03-15 15:30:00 | SPY | ETF | 130.76 | 130.86 | 130.67 | 130.77 | 5269200.0 |
| 2006-03-15 16:00:00 | SPY | ETF | 130.76 | 130.8 | 129.9 | 130.72 | 1024300.0 |
| 2006-03-15 16:30:00 | SPY | ETF | 130.72 | 130.76 | 130.65 | 130.65 | 4749500.0 |
| 2006-03-15 17:00:00 | SPY | ETF | 130.66 | 130.68 | 130.61 | 130.66 | 224600.0 |
| 2006-03-15 17:30:00 | SPY | ETF | 130.63 | 130.65 | 130.63 | 130.65 | 500.0 |
| 2006-03-15 18:00:00 | SPY | ETF | 130.65 | 130.66 | 130.62 | 130.62 | 8500.0 |
| 2006-03-15 19:30:00 | SPY | ETF | 130.62 | 130.62 | 130.6 | 130.6 | 8900.0 |
| 2006-03-15 09:30:00 | QQQ | ETF | 41.53 | 41.58 | 41.43 | 41.55 | 9166100.0 |
| 2006-03-15 10:00:00 | QQQ | ETF | 41.56 | 41.56 | 41.39 | 41.49 | 5715700.0 |
| 2006-03-15 10:30:00 | QQQ | ETF | 41.5 | 41.57 | 41.37 | 41.4 | 7030900.0 |
| 2006-03-15 11:00:00 | QQQ | ETF | 41.39 | 41.44 | 41.36 | 41.39 | 8494200.0 |
| 2006-03-15 11:30:00 | QQQ | ETF | 41.4 | 41.41 | 41.32 | 41.37 | 5521600.0 |
| 2006-03-15 12:00:00 | QQQ | ETF | 41.37 | 41.48 | 41.34 | 41.39 | 5572300.0 |
| 2006-03-15 12:30:00 | QQQ | ETF | 41.39 | 41.48 | 41.37 | 41.45 | 2007900.0 |
| 2006-03-15 13:00:00 | QQQ | ETF | 41.45 | 41.45 | 41.41 | 41.43 | 950800.0 |
| 2006-03-15 13:30:00 | QQQ | ETF | 41.43 | 41.49 | 41.4 | 41.47 | 2518600.0 |
| 2006-03-15 14:00:00 | QQQ | ETF | 41.47 | 41.64 | 41.44 | 41.59 | 8518600.0 |
| 2006-03-15 14:30:00 | QQQ | ETF | 41.6 | 41.63 | 41.52 | 41.52 | 4818400.0 |
| 2006-03-15 15:00:00 | QQQ | ETF | 41.53 | 41.68 | 41.49 | 41.65 | 9148700.0 |
| 2006-03-15 15:30:00 | QQQ | ETF | 41.66 | 41.71 | 41.63 | 41.71 | 9367700.0 |
| 2006-03-15 08:00:00 | IWM | ETF | 73.29 | 73.36 | 73.29 | 73.32 | 3900.0 |
| 2006-03-15 08:30:00 | IWM | ETF | 73.32 | 73.37 | 73.27 | 73.27 | 101100.0 |
| 2006-03-15 09:00:00 | IWM | ETF | 73.28 | 73.31 | 73.26 | 73.28 | 21600.0 |
| 2006-03-15 09:30:00 | IWM | ETF | 73.3 | 73.36 | 73.08 | 73.29 | 3171900.0 |
| 2006-03-15 10:00:00 | IWM | ETF | 73.31 | 73.45 | 73.22 | 73.32 | 1138800.0 |
| 2006-03-15 10:30:00 | IWM | ETF | 73.31 | 73.47 | 73.14 | 73.18 | 1342900.0 |
| 2006-03-15 11:00:00 | IWM | ETF | 73.19 | 73.3 | 73.15 | 73.17 | 2476000.0 |
| 2006-03-15 11:30:00 | IWM | ETF | 73.17 | 73.19 | 73.04 | 73.09 | 1951300.0 |
| 2006-03-15 12:00:00 | IWM | ETF | 73.1 | 73.5 | 73.07 | 73.24 | 3278500.0 |
| 2006-03-15 12:30:00 | IWM | ETF | 73.25 | 73.46 | 73.24 | 73.38 | 718200.0 |
| 2006-03-15 13:00:00 | IWM | ETF | 73.38 | 73.4481 | 73.33 | 73.41 | 505300.0 |
| 2006-03-15 13:30:00 | IWM | ETF | 73.41 | 73.63 | 73.4 | 73.62 | 1419400.0 |
> showing 50 of 2,187 rows — these rows as CSV