PREVIEW / etf_30min / 2004-09-10
file: by_date/etf_30min/2004/2004-09-10.parquet size: 34 KB rows: 1,127
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-09-10 08:00:00 | SPY | ETF | 112.43 | 112.5 | 112.4 | 112.46 | 24100.0 |
| 2004-09-10 08:30:00 | SPY | ETF | 112.46 | 112.65 | 112.46 | 112.54 | 83300.0 |
| 2004-09-10 09:00:00 | SPY | ETF | 112.54 | 112.56 | 112.5 | 112.51 | 18000.0 |
| 2004-09-10 09:30:00 | SPY | ETF | 112.52 | 112.54 | 112.09 | 112.29 | 4119500.0 |
| 2004-09-10 10:00:00 | SPY | ETF | 112.28 | 112.55 | 112.18 | 112.41 | 2371500.0 |
| 2004-09-10 10:30:00 | SPY | ETF | 112.42 | 112.67 | 112.28 | 112.3 | 2447600.0 |
| 2004-09-10 11:00:00 | SPY | ETF | 112.32 | 112.62 | 112.23 | 112.55 | 1220000.0 |
| 2004-09-10 11:30:00 | SPY | ETF | 112.57 | 112.62 | 112.41 | 112.49 | 1044400.0 |
| 2004-09-10 12:00:00 | SPY | ETF | 112.48 | 112.59 | 112.42 | 112.53 | 678600.0 |
| 2004-09-10 12:30:00 | SPY | ETF | 112.53 | 112.61 | 112.49 | 112.51 | 700400.0 |
| 2004-09-10 13:00:00 | SPY | ETF | 112.51 | 112.74 | 112.46 | 112.67 | 1343700.0 |
| 2004-09-10 13:30:00 | SPY | ETF | 112.66 | 112.68 | 112.49 | 112.54 | 1104900.0 |
| 2004-09-10 14:00:00 | SPY | ETF | 112.54 | 112.81 | 112.49 | 112.74 | 1249900.0 |
| 2004-09-10 14:30:00 | SPY | ETF | 112.75 | 113.09 | 112.7 | 113.0 | 4119400.0 |
| 2004-09-10 15:00:00 | SPY | ETF | 113.0 | 113.27 | 112.97 | 113.22 | 3644200.0 |
| 2004-09-10 15:30:00 | SPY | ETF | 113.23 | 113.27 | 113.03 | 113.0908 | 1674000.0 |
| 2004-09-10 16:00:00 | SPY | ETF | 113.1 | 113.17 | 113.02 | 113.04 | 1158000.0 |
| 2004-09-10 16:30:00 | SPY | ETF | 113.05 | 113.1 | 113.02 | 113.02 | 8700.0 |
| 2004-09-10 17:00:00 | SPY | ETF | 113.03 | 113.06 | 113.02 | 113.04 | 3600.0 |
| 2004-09-10 17:30:00 | SPY | ETF | 113.01 | 113.14 | 113.01 | 113.09 | 9000.0 |
| 2004-09-10 18:00:00 | SPY | ETF | 113.18 | 113.18 | 113.1 | 113.1 | 800.0 |
| 2004-09-10 18:30:00 | SPY | ETF | 113.15 | 113.16 | 113.15 | 113.16 | 200.0 |
| 2004-09-10 19:30:00 | SPY | ETF | 113.06 | 113.06 | 113.06 | 113.06 | 200.0 |
| 2004-09-10 08:00:00 | QQQ | ETF | 34.6 | 34.62 | 34.6 | 34.62 | 130600.0 |
| 2004-09-10 08:30:00 | QQQ | ETF | 34.63 | 34.69 | 34.57 | 34.6 | 331300.0 |
| 2004-09-10 09:00:00 | QQQ | ETF | 34.6 | 34.64 | 34.57 | 34.62 | 249300.0 |
| 2004-09-10 09:30:00 | QQQ | ETF | 34.61 | 34.719 | 34.48 | 34.67 | 12900500.0 |
| 2004-09-10 10:00:00 | QQQ | ETF | 34.67 | 34.82 | 34.609 | 34.79 | 13817400.0 |
| 2004-09-10 10:30:00 | QQQ | ETF | 34.79 | 34.9 | 34.75 | 34.764 | 10857400.0 |
| 2004-09-10 11:00:00 | QQQ | ETF | 34.764 | 34.88 | 34.73 | 34.839 | 4701900.0 |
| 2004-09-10 11:30:00 | QQQ | ETF | 34.84 | 34.86 | 34.75 | 34.8 | 3687300.0 |
| 2004-09-10 12:00:00 | QQQ | ETF | 34.79 | 34.857 | 34.77 | 34.82 | 5493900.0 |
| 2004-09-10 12:30:00 | QQQ | ETF | 34.81 | 34.88 | 34.81 | 34.82 | 2871500.0 |
| 2004-09-10 13:00:00 | QQQ | ETF | 34.82 | 34.92 | 34.79 | 34.895 | 4560800.0 |
| 2004-09-10 13:30:00 | QQQ | ETF | 34.895 | 34.9 | 34.78 | 34.799 | 2530900.0 |
| 2004-09-10 14:00:00 | QQQ | ETF | 34.79 | 34.97 | 34.78 | 34.93 | 4591600.0 |
| 2004-09-10 14:30:00 | QQQ | ETF | 34.93 | 35.1 | 34.91 | 35.05 | 13616500.0 |
| 2004-09-10 15:00:00 | QQQ | ETF | 35.04 | 35.15 | 35.03 | 35.14 | 8603100.0 |
| 2004-09-10 15:30:00 | QQQ | ETF | 35.127 | 35.19 | 35.1 | 35.127 | 8799100.0 |
| 2004-09-10 16:00:00 | QQQ | ETF | 35.121 | 35.175 | 35.08 | 35.1 | 5811700.0 |
| 2004-09-10 16:30:00 | QQQ | ETF | 35.11 | 35.14 | 35.1 | 35.13 | 49300.0 |
| 2004-09-10 17:00:00 | QQQ | ETF | 35.13 | 35.15 | 35.12 | 35.14 | 42300.0 |
| 2004-09-10 17:30:00 | QQQ | ETF | 35.13 | 35.15 | 35.11 | 35.14 | 21500.0 |
| 2004-09-10 18:00:00 | QQQ | ETF | 35.12 | 35.12 | 35.11 | 35.111 | 15300.0 |
| 2004-09-10 18:30:00 | QQQ | ETF | 35.11 | 35.12 | 35.11 | 35.12 | 1400.0 |
| 2004-09-10 19:00:00 | QQQ | ETF | 35.12 | 35.15 | 35.12 | 35.15 | 10400.0 |
| 2004-09-10 19:30:00 | QQQ | ETF | 35.15 | 35.15 | 35.15 | 35.15 | 8200.0 |
| 2004-09-10 08:30:00 | IWM | ETF | 56.56 | 56.56 | 56.56 | 56.56 | 1000.0 |
| 2004-09-10 09:00:00 | IWM | ETF | 56.575 | 56.575 | 56.575 | 56.575 | 34000.0 |
| 2004-09-10 09:30:00 | IWM | ETF | 56.495 | 56.515 | 56.075 | 56.32 | 1207800.0 |
> showing 50 of 1,127 rows — these rows as CSV