PREVIEW / etf_30min / 2004-01-07
file: by_date/etf_30min/2004/2004-01-07.parquet size: 34 KB rows: 1,149
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-07 08:00:00 | SPY | ETF | 112.43 | 112.53 | 112.42 | 112.51 | 11300.0 |
| 2004-01-07 08:30:00 | SPY | ETF | 112.46 | 112.46 | 112.46 | 112.46 | 300.0 |
| 2004-01-07 09:00:00 | SPY | ETF | 112.47 | 112.47 | 112.36 | 112.36 | 52900.0 |
| 2004-01-07 09:30:00 | SPY | ETF | 112.39 | 112.55 | 112.15 | 112.16 | 3655400.0 |
| 2004-01-07 10:00:00 | SPY | ETF | 112.15 | 112.2 | 111.89 | 112.03 | 4762000.0 |
| 2004-01-07 10:30:00 | SPY | ETF | 112.03 | 112.18 | 112.02 | 112.16 | 1636900.0 |
| 2004-01-07 11:00:00 | SPY | ETF | 112.15 | 112.19 | 112.08 | 112.12 | 1130800.0 |
| 2004-01-07 11:30:00 | SPY | ETF | 112.12 | 112.52 | 112.06 | 112.45 | 2255700.0 |
| 2004-01-07 12:00:00 | SPY | ETF | 112.44 | 112.78 | 112.43 | 112.67 | 1858200.0 |
| 2004-01-07 12:30:00 | SPY | ETF | 112.67 | 112.73 | 112.6 | 112.67 | 1294100.0 |
| 2004-01-07 13:00:00 | SPY | ETF | 112.67 | 112.77 | 112.56 | 112.72 | 1167100.0 |
| 2004-01-07 13:30:00 | SPY | ETF | 112.71 | 112.8 | 112.43 | 112.51 | 1280500.0 |
| 2004-01-07 14:00:00 | SPY | ETF | 112.51 | 112.55 | 112.29 | 112.31 | 1584200.0 |
| 2004-01-07 14:30:00 | SPY | ETF | 112.31 | 112.6 | 112.3 | 112.58 | 1419900.0 |
| 2004-01-07 15:00:00 | SPY | ETF | 112.58 | 112.62 | 112.34 | 112.52 | 845800.0 |
| 2004-01-07 15:30:00 | SPY | ETF | 112.53 | 112.92 | 112.48 | 112.9 | 3038300.0 |
| 2004-01-07 16:00:00 | SPY | ETF | 112.89 | 113.06 | 112.86 | 112.98 | 2619900.0 |
| 2004-01-07 16:30:00 | SPY | ETF | 112.98 | 112.98 | 112.94 | 112.98 | 19600.0 |
| 2004-01-07 17:00:00 | SPY | ETF | 112.97 | 112.99 | 112.97 | 112.98 | 1900.0 |
| 2004-01-07 17:30:00 | SPY | ETF | 112.98 | 113.01 | 112.96 | 112.98 | 6100.0 |
| 2004-01-07 18:00:00 | SPY | ETF | 112.98 | 112.98 | 112.93 | 112.93 | 9400.0 |
| 2004-01-07 19:00:00 | SPY | ETF | 112.91 | 113.0 | 112.91 | 113.0 | 600.0 |
| 2004-01-07 19:30:00 | SPY | ETF | 113.0 | 113.0 | 112.99 | 112.99 | 1500.0 |
| 2004-01-07 08:00:00 | QQQ | ETF | 37.24 | 37.3 | 37.24 | 37.28 | 23400.0 |
| 2004-01-07 08:30:00 | QQQ | ETF | 37.28 | 37.28 | 37.26 | 37.26 | 31900.0 |
| 2004-01-07 09:00:00 | QQQ | ETF | 37.26 | 37.27 | 37.24 | 37.26 | 47900.0 |
| 2004-01-07 09:30:00 | QQQ | ETF | 37.27 | 37.34 | 37.18 | 37.181 | 7673900.0 |
| 2004-01-07 10:00:00 | QQQ | ETF | 37.18 | 37.2 | 37.07 | 37.13 | 7884300.0 |
| 2004-01-07 10:30:00 | QQQ | ETF | 37.14 | 37.25 | 37.12 | 37.24 | 4564300.0 |
| 2004-01-07 11:00:00 | QQQ | ETF | 37.242 | 37.27 | 37.21 | 37.22 | 2670500.0 |
| 2004-01-07 11:30:00 | QQQ | ETF | 37.22 | 37.41 | 37.18 | 37.39 | 5768200.0 |
| 2004-01-07 12:00:00 | QQQ | ETF | 37.391 | 37.58 | 37.37 | 37.521 | 6170000.0 |
| 2004-01-07 12:30:00 | QQQ | ETF | 37.52 | 37.55 | 37.48 | 37.506 | 2937500.0 |
| 2004-01-07 13:00:00 | QQQ | ETF | 37.51 | 37.58 | 37.47 | 37.549 | 2826800.0 |
| 2004-01-07 13:30:00 | QQQ | ETF | 37.54 | 37.62 | 37.45 | 37.47 | 3924100.0 |
| 2004-01-07 14:00:00 | QQQ | ETF | 37.474 | 37.51 | 37.361 | 37.41 | 4870700.0 |
| 2004-01-07 14:30:00 | QQQ | ETF | 37.43 | 37.58 | 37.38 | 37.57 | 3396600.0 |
| 2004-01-07 15:00:00 | QQQ | ETF | 37.56 | 37.581 | 37.44 | 37.531 | 3098600.0 |
| 2004-01-07 15:30:00 | QQQ | ETF | 37.52 | 37.624 | 37.5 | 37.61 | 6221600.0 |
| 2004-01-07 16:00:00 | QQQ | ETF | 37.61 | 37.68 | 37.58 | 37.66 | 3163300.0 |
| 2004-01-07 16:30:00 | QQQ | ETF | 37.668 | 37.68 | 37.64 | 37.66 | 286100.0 |
| 2004-01-07 17:00:00 | QQQ | ETF | 37.67 | 37.69 | 37.65 | 37.67 | 103300.0 |
| 2004-01-07 17:30:00 | QQQ | ETF | 37.68 | 37.71 | 37.68 | 37.69 | 2263100.0 |
| 2004-01-07 18:00:00 | QQQ | ETF | 37.7 | 37.7 | 37.68 | 37.69 | 15500.0 |
| 2004-01-07 18:30:00 | QQQ | ETF | 37.68 | 37.7 | 37.67 | 37.68 | 28000.0 |
| 2004-01-07 19:00:00 | QQQ | ETF | 37.67 | 37.69 | 37.67 | 37.67 | 3700.0 |
| 2004-01-07 19:30:00 | QQQ | ETF | 37.68 | 37.68 | 37.67 | 37.67 | 5200.0 |
| 2004-01-07 08:30:00 | IWM | ETF | 56.6 | 56.6 | 56.6 | 56.6 | 4000.0 |
| 2004-01-07 09:00:00 | IWM | ETF | 56.54 | 56.575 | 56.525 | 56.575 | 10000.0 |
| 2004-01-07 09:30:00 | IWM | ETF | 56.661 | 56.995 | 56.66 | 56.695 | 550400.0 |
> showing 50 of 1,149 rows — these rows as CSV