PREVIEW / etf_30min / 2005-01-12
file: by_date/etf_30min/2005/2005-01-12.parquet size: 42 KB rows: 1,418
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-12 08:00:00 | SPY | ETF | 118.49 | 118.6 | 118.49 | 118.55 | 85100.0 |
| 2005-01-12 08:30:00 | SPY | ETF | 118.55 | 118.55 | 118.37 | 118.38 | 93300.0 |
| 2005-01-12 09:00:00 | SPY | ETF | 118.38 | 118.44 | 118.36 | 118.4 | 290700.0 |
| 2005-01-12 09:30:00 | SPY | ETF | 118.4 | 118.45 | 117.91 | 117.98 | 9354500.0 |
| 2005-01-12 10:00:00 | SPY | ETF | 117.98 | 118.33 | 117.85 | 118.03 | 7383000.0 |
| 2005-01-12 10:30:00 | SPY | ETF | 118.03 | 118.1 | 117.52 | 117.69 | 9373300.0 |
| 2005-01-12 11:00:00 | SPY | ETF | 117.68 | 117.93 | 117.63 | 117.91 | 4987200.0 |
| 2005-01-12 11:30:00 | SPY | ETF | 117.9 | 118.41 | 117.9 | 118.27 | 6837500.0 |
| 2005-01-12 12:00:00 | SPY | ETF | 118.27 | 118.45 | 118.13 | 118.43 | 3950300.0 |
| 2005-01-12 12:30:00 | SPY | ETF | 118.43 | 118.46 | 118.16 | 118.17 | 2697500.0 |
| 2005-01-12 13:00:00 | SPY | ETF | 118.16 | 118.39 | 118.12 | 118.12 | 1356200.0 |
| 2005-01-12 13:30:00 | SPY | ETF | 118.12 | 118.21 | 117.9 | 118.03 | 3628200.0 |
| 2005-01-12 14:00:00 | SPY | ETF | 118.03 | 118.35 | 117.97 | 118.2 | 3093000.0 |
| 2005-01-12 14:30:00 | SPY | ETF | 118.21 | 118.29 | 118.05 | 118.24 | 2567400.0 |
| 2005-01-12 15:00:00 | SPY | ETF | 118.24 | 118.42 | 118.15 | 118.36 | 3455500.0 |
| 2005-01-12 15:30:00 | SPY | ETF | 118.36 | 118.84 | 118.31 | 118.8 | 9201100.0 |
| 2005-01-12 16:00:00 | SPY | ETF | 118.77 | 118.78 | 118.53 | 118.65 | 1964100.0 |
| 2005-01-12 16:30:00 | SPY | ETF | 118.65 | 118.87 | 118.57 | 118.79 | 560300.0 |
| 2005-01-12 17:00:00 | SPY | ETF | 118.81 | 118.85 | 118.78 | 118.79 | 442800.0 |
| 2005-01-12 17:30:00 | SPY | ETF | 118.74 | 118.79 | 118.57 | 118.79 | 1253100.0 |
| 2005-01-12 18:00:00 | SPY | ETF | 118.78 | 118.81 | 118.76 | 118.78 | 15200.0 |
| 2005-01-12 18:30:00 | SPY | ETF | 118.8 | 118.8 | 118.75 | 118.75 | 3800.0 |
| 2005-01-12 09:30:00 | QQQ | ETF | 38.43 | 38.5 | 38.2 | 38.27 | 20428200.0 |
| 2005-01-12 10:00:00 | QQQ | ETF | 38.27 | 38.45 | 38.19 | 38.24 | 10472700.0 |
| 2005-01-12 10:30:00 | QQQ | ETF | 38.24 | 38.31 | 38.01 | 38.07 | 16320300.0 |
| 2005-01-12 11:00:00 | QQQ | ETF | 38.07 | 38.38 | 38.02 | 38.19 | 8420900.0 |
| 2005-01-12 11:30:00 | QQQ | ETF | 38.18 | 38.35 | 38.16 | 38.31 | 10028400.0 |
| 2005-01-12 12:00:00 | QQQ | ETF | 38.31 | 38.4 | 38.15 | 38.38 | 6903500.0 |
| 2005-01-12 12:30:00 | QQQ | ETF | 38.38 | 38.4 | 38.23 | 38.26 | 3698200.0 |
| 2005-01-12 13:00:00 | QQQ | ETF | 38.25 | 38.4 | 38.25 | 38.26 | 3388000.0 |
| 2005-01-12 13:30:00 | QQQ | ETF | 38.26 | 38.31 | 38.15 | 38.19 | 4757200.0 |
| 2005-01-12 14:00:00 | QQQ | ETF | 38.19 | 38.34 | 38.17 | 38.28 | 4361400.0 |
| 2005-01-12 14:30:00 | QQQ | ETF | 38.28 | 38.32 | 38.22 | 38.29 | 4156300.0 |
| 2005-01-12 15:00:00 | QQQ | ETF | 38.29 | 38.43 | 38.25 | 38.38 | 6595800.0 |
| 2005-01-12 15:30:00 | QQQ | ETF | 38.38 | 38.6 | 38.34 | 38.58 | 14640000.0 |
| 2005-01-12 08:30:00 | IWM | ETF | 61.04 | 61.04 | 60.935 | 60.935 | 29400.0 |
| 2005-01-12 09:00:00 | IWM | ETF | 60.915 | 60.95 | 60.915 | 60.92 | 9400.0 |
| 2005-01-12 09:30:00 | IWM | ETF | 60.89 | 61.06 | 60.53 | 60.53 | 3401800.0 |
| 2005-01-12 10:00:00 | IWM | ETF | 60.53 | 60.755 | 60.405 | 60.505 | 1874400.0 |
| 2005-01-12 10:30:00 | IWM | ETF | 60.495 | 60.535 | 60.13 | 60.21 | 2229600.0 |
| 2005-01-12 11:00:00 | IWM | ETF | 60.205 | 60.345 | 60.165 | 60.33 | 1747600.0 |
| 2005-01-12 11:30:00 | IWM | ETF | 60.34 | 60.71 | 60.34 | 60.605 | 2241200.0 |
| 2005-01-12 12:00:00 | IWM | ETF | 60.6 | 60.7 | 60.485 | 60.68 | 1662200.0 |
| 2005-01-12 12:30:00 | IWM | ETF | 60.675 | 60.735 | 60.525 | 60.54 | 1687400.0 |
| 2005-01-12 13:00:00 | IWM | ETF | 60.525 | 60.61 | 60.46 | 60.46 | 1062000.0 |
| 2005-01-12 13:30:00 | IWM | ETF | 60.45 | 60.5 | 60.33 | 60.395 | 926400.0 |
| 2005-01-12 14:00:00 | IWM | ETF | 60.38 | 60.625 | 60.375 | 60.545 | 1360600.0 |
| 2005-01-12 14:30:00 | IWM | ETF | 60.545 | 60.575 | 60.46 | 60.525 | 862200.0 |
| 2005-01-12 15:00:00 | IWM | ETF | 60.525 | 60.63 | 60.495 | 60.57 | 1251200.0 |
| 2005-01-12 15:30:00 | IWM | ETF | 60.57 | 61.25 | 60.55 | 61.17 | 3459200.0 |
> showing 50 of 1,418 rows — these rows as CSV