PREVIEW / etf_30min / 2004-03-17
file: by_date/etf_30min/2004/2004-03-17.parquet size: 36 KB rows: 1,208
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-03-17 08:00:00 | SPY | ETF | 112.1 | 112.26 | 112.1 | 112.25 | 27900.0 |
| 2004-03-17 08:30:00 | SPY | ETF | 112.23 | 112.29 | 112.22 | 112.24 | 45000.0 |
| 2004-03-17 09:00:00 | SPY | ETF | 112.24 | 112.31 | 112.2 | 112.22 | 159500.0 |
| 2004-03-17 09:30:00 | SPY | ETF | 112.18 | 112.66 | 112.1 | 112.47 | 6988600.0 |
| 2004-03-17 10:00:00 | SPY | ETF | 112.47 | 112.7 | 112.4 | 112.64 | 3663900.0 |
| 2004-03-17 10:30:00 | SPY | ETF | 112.64 | 112.75 | 112.42 | 112.5 | 2276400.0 |
| 2004-03-17 11:00:00 | SPY | ETF | 112.49 | 112.96 | 112.47 | 112.92 | 2939900.0 |
| 2004-03-17 11:30:00 | SPY | ETF | 112.9 | 113.01 | 112.88 | 112.93 | 2179300.0 |
| 2004-03-17 12:00:00 | SPY | ETF | 112.93 | 113.02 | 112.81 | 112.85 | 2356000.0 |
| 2004-03-17 12:30:00 | SPY | ETF | 112.85 | 112.92 | 112.83 | 112.87 | 1102600.0 |
| 2004-03-17 13:00:00 | SPY | ETF | 112.88 | 112.94 | 112.72 | 112.94 | 1050300.0 |
| 2004-03-17 13:30:00 | SPY | ETF | 112.94 | 113.03 | 112.79 | 112.87 | 1885900.0 |
| 2004-03-17 14:00:00 | SPY | ETF | 112.87 | 113.06 | 112.86 | 112.94 | 2285300.0 |
| 2004-03-17 14:30:00 | SPY | ETF | 112.92 | 113.13 | 112.85 | 113.06 | 1982400.0 |
| 2004-03-17 15:00:00 | SPY | ETF | 113.07 | 113.17 | 112.99 | 113.16 | 2006200.0 |
| 2004-03-17 15:30:00 | SPY | ETF | 113.17 | 113.25 | 112.99 | 113.0 | 3693500.0 |
| 2004-03-17 16:00:00 | SPY | ETF | 112.98 | 113.06 | 112.96 | 113.01 | 3503600.0 |
| 2004-03-17 16:30:00 | SPY | ETF | 113.03 | 113.08 | 113.0 | 113.05 | 91800.0 |
| 2004-03-17 17:00:00 | SPY | ETF | 113.03 | 113.05 | 112.99 | 113.05 | 28400.0 |
| 2004-03-17 17:30:00 | SPY | ETF | 113.0 | 113.08 | 113.0 | 113.06 | 253900.0 |
| 2004-03-17 18:00:00 | SPY | ETF | 113.08 | 113.09 | 113.04 | 113.06 | 11800.0 |
| 2004-03-17 18:30:00 | SPY | ETF | 113.1 | 113.13 | 113.1 | 113.13 | 7300.0 |
| 2004-03-17 19:00:00 | SPY | ETF | 113.13 | 113.13 | 113.1 | 113.1 | 4500.0 |
| 2004-03-17 19:30:00 | SPY | ETF | 113.01 | 113.01 | 112.99 | 112.99 | 4200.0 |
| 2004-03-17 08:00:00 | QQQ | ETF | 35.1 | 35.22 | 35.1 | 35.19 | 151700.0 |
| 2004-03-17 08:30:00 | QQQ | ETF | 35.19 | 35.22 | 35.18 | 35.2 | 213400.0 |
| 2004-03-17 09:00:00 | QQQ | ETF | 35.2 | 35.22 | 35.17 | 35.21 | 304100.0 |
| 2004-03-17 09:30:00 | QQQ | ETF | 35.21 | 35.41 | 35.18 | 35.33 | 20113000.0 |
| 2004-03-17 10:00:00 | QQQ | ETF | 35.33 | 35.45 | 35.32 | 35.401 | 8072600.0 |
| 2004-03-17 10:30:00 | QQQ | ETF | 35.41 | 35.47 | 35.29 | 35.37 | 5794600.0 |
| 2004-03-17 11:00:00 | QQQ | ETF | 35.368 | 35.491 | 35.36 | 35.47 | 6028300.0 |
| 2004-03-17 11:30:00 | QQQ | ETF | 35.47 | 35.55 | 35.44 | 35.46 | 6067100.0 |
| 2004-03-17 12:00:00 | QQQ | ETF | 35.454 | 35.5 | 35.41 | 35.42 | 3977600.0 |
| 2004-03-17 12:30:00 | QQQ | ETF | 35.428 | 35.47 | 35.39 | 35.4 | 1998500.0 |
| 2004-03-17 13:00:00 | QQQ | ETF | 35.4 | 35.482 | 35.36 | 35.46 | 2908500.0 |
| 2004-03-17 13:30:00 | QQQ | ETF | 35.46 | 35.502 | 35.4 | 35.43 | 5025600.0 |
| 2004-03-17 14:00:00 | QQQ | ETF | 35.43 | 35.53 | 35.42 | 35.46 | 4899400.0 |
| 2004-03-17 14:30:00 | QQQ | ETF | 35.45 | 35.52 | 35.42 | 35.51 | 4034800.0 |
| 2004-03-17 15:00:00 | QQQ | ETF | 35.514 | 35.55 | 35.46 | 35.51 | 5195100.0 |
| 2004-03-17 15:30:00 | QQQ | ETF | 35.52 | 35.62 | 35.48 | 35.5 | 9804100.0 |
| 2004-03-17 16:00:00 | QQQ | ETF | 35.51 | 35.54 | 35.49 | 35.49 | 3819900.0 |
| 2004-03-17 16:30:00 | QQQ | ETF | 35.5 | 35.52 | 35.49 | 35.49 | 278900.0 |
| 2004-03-17 17:00:00 | QQQ | ETF | 35.505 | 35.51 | 35.48 | 35.48 | 91000.0 |
| 2004-03-17 17:30:00 | QQQ | ETF | 35.5 | 35.52 | 35.49 | 35.51 | 269000.0 |
| 2004-03-17 18:00:00 | QQQ | ETF | 35.51 | 35.53 | 35.51 | 35.53 | 5900.0 |
| 2004-03-17 18:30:00 | QQQ | ETF | 35.52 | 35.53 | 35.51 | 35.51 | 1200.0 |
| 2004-03-17 19:00:00 | QQQ | ETF | 35.52 | 35.52 | 35.52 | 35.52 | 800.0 |
| 2004-03-17 19:30:00 | QQQ | ETF | 35.52 | 35.52 | 35.51 | 35.51 | 300.0 |
| 2004-03-17 09:00:00 | IWM | ETF | 56.99 | 57.0 | 56.99 | 57.0 | 26000.0 |
| 2004-03-17 09:30:00 | IWM | ETF | 56.96 | 57.36 | 56.9 | 57.2 | 4177000.0 |
> showing 50 of 1,208 rows — these rows as CSV