PREVIEW / etf_30min / 2003-11-10
file: by_date/etf_30min/2003/2003-11-10.parquet size: 25 KB rows: 799
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-10 08:00:00 | SPY | ETF | 105.75 | 105.8 | 105.75 | 105.75 | 5000.0 |
| 2003-11-10 08:30:00 | SPY | ETF | 105.78 | 105.78 | 105.58 | 105.64 | 25900.0 |
| 2003-11-10 09:00:00 | SPY | ETF | 105.7 | 105.76 | 105.68 | 105.71 | 20400.0 |
| 2003-11-10 09:30:00 | SPY | ETF | 105.74 | 105.84 | 105.58 | 105.77 | 3407200.0 |
| 2003-11-10 10:00:00 | SPY | ETF | 105.741 | 105.75 | 105.39 | 105.47 | 4148300.0 |
| 2003-11-10 10:30:00 | SPY | ETF | 105.44 | 105.57 | 105.34 | 105.5 | 1900100.0 |
| 2003-11-10 11:00:00 | SPY | ETF | 105.53 | 105.63 | 105.4 | 105.42 | 748300.0 |
| 2003-11-10 11:30:00 | SPY | ETF | 105.42 | 105.5 | 105.27 | 105.28 | 1677000.0 |
| 2003-11-10 12:00:00 | SPY | ETF | 105.29 | 105.38 | 105.27 | 105.35 | 679200.0 |
| 2003-11-10 12:30:00 | SPY | ETF | 105.36 | 105.44 | 105.27 | 105.35 | 821200.0 |
| 2003-11-10 13:00:00 | SPY | ETF | 105.36 | 105.49 | 105.27 | 105.46 | 958200.0 |
| 2003-11-10 13:30:00 | SPY | ETF | 105.46 | 105.56 | 105.37 | 105.53 | 1016900.0 |
| 2003-11-10 14:00:00 | SPY | ETF | 105.55 | 105.55 | 105.24 | 105.3 | 836500.0 |
| 2003-11-10 14:30:00 | SPY | ETF | 105.3 | 105.56 | 105.22 | 105.4 | 1078600.0 |
| 2003-11-10 15:00:00 | SPY | ETF | 105.37 | 105.49 | 105.06 | 105.06 | 1520600.0 |
| 2003-11-10 15:30:00 | SPY | ETF | 105.09 | 105.19 | 105.01 | 105.18 | 2930900.0 |
| 2003-11-10 16:00:00 | SPY | ETF | 105.14 | 105.27 | 105.13 | 105.2 | 1571800.0 |
| 2003-11-10 16:30:00 | SPY | ETF | 105.24 | 105.24 | 105.19 | 105.19 | 9100.0 |
| 2003-11-10 17:00:00 | SPY | ETF | 105.19 | 105.52 | 105.19 | 105.2 | 102100.0 |
| 2003-11-10 17:30:00 | SPY | ETF | 105.24 | 105.25 | 105.23 | 105.23 | 1300.0 |
| 2003-11-10 18:00:00 | SPY | ETF | 105.24 | 105.24 | 105.21 | 105.22 | 6300.0 |
| 2003-11-10 19:00:00 | SPY | ETF | 105.2 | 105.2 | 105.2 | 105.2 | 200.0 |
| 2003-11-10 08:00:00 | QQQ | ETF | 35.66 | 35.73 | 35.66 | 35.71 | 47200.0 |
| 2003-11-10 08:30:00 | QQQ | ETF | 35.7 | 35.71 | 35.65 | 35.66 | 44200.0 |
| 2003-11-10 09:00:00 | QQQ | ETF | 35.68 | 35.71 | 35.65 | 35.7 | 81400.0 |
| 2003-11-10 09:30:00 | QQQ | ETF | 35.7 | 35.743 | 35.6 | 35.73 | 7498000.0 |
| 2003-11-10 10:00:00 | QQQ | ETF | 35.72 | 35.74 | 35.47 | 35.531 | 9801300.0 |
| 2003-11-10 10:30:00 | QQQ | ETF | 35.53 | 35.59 | 35.45 | 35.53 | 4220500.0 |
| 2003-11-10 11:00:00 | QQQ | ETF | 35.54 | 35.57 | 35.42 | 35.45 | 2924900.0 |
| 2003-11-10 11:30:00 | QQQ | ETF | 35.44 | 35.48 | 35.37 | 35.4 | 4117500.0 |
| 2003-11-10 12:00:00 | QQQ | ETF | 35.42 | 35.44 | 35.358 | 35.4 | 2621000.0 |
| 2003-11-10 12:30:00 | QQQ | ETF | 35.4 | 35.46 | 35.36 | 35.43 | 2012200.0 |
| 2003-11-10 13:00:00 | QQQ | ETF | 35.43 | 35.49 | 35.36 | 35.46 | 4000000.0 |
| 2003-11-10 13:30:00 | QQQ | ETF | 35.46 | 35.53 | 35.41 | 35.482 | 2900800.0 |
| 2003-11-10 14:00:00 | QQQ | ETF | 35.48 | 35.5 | 35.32 | 35.36 | 2594300.0 |
| 2003-11-10 14:30:00 | QQQ | ETF | 35.36 | 35.48 | 35.33 | 35.38 | 3582900.0 |
| 2003-11-10 15:00:00 | QQQ | ETF | 35.38 | 35.44 | 35.2 | 35.21 | 3502600.0 |
| 2003-11-10 15:30:00 | QQQ | ETF | 35.2 | 35.26 | 35.1 | 35.182 | 8506900.0 |
| 2003-11-10 16:00:00 | QQQ | ETF | 35.19 | 35.24 | 35.16 | 35.24 | 1959100.0 |
| 2003-11-10 16:30:00 | QQQ | ETF | 35.25 | 35.26 | 35.2 | 35.23 | 192500.0 |
| 2003-11-10 17:00:00 | QQQ | ETF | 35.223 | 35.246 | 35.21 | 35.21 | 56700.0 |
| 2003-11-10 17:30:00 | QQQ | ETF | 35.229 | 35.23 | 35.18 | 35.19 | 33300.0 |
| 2003-11-10 18:00:00 | QQQ | ETF | 35.19 | 35.22 | 35.19 | 35.218 | 32400.0 |
| 2003-11-10 18:30:00 | QQQ | ETF | 35.22 | 35.22 | 35.21 | 35.22 | 5600.0 |
| 2003-11-10 19:00:00 | QQQ | ETF | 35.21 | 35.21 | 35.21 | 35.21 | 200.0 |
| 2003-11-10 19:30:00 | QQQ | ETF | 35.21 | 35.23 | 35.21 | 35.23 | 1000.0 |
| 2003-11-10 09:30:00 | IWM | ETF | 54.135 | 54.26 | 54.074 | 54.16 | 344400.0 |
| 2003-11-10 10:00:00 | IWM | ETF | 54.116 | 54.15 | 53.72 | 53.72 | 573800.0 |
| 2003-11-10 10:30:00 | IWM | ETF | 53.7 | 53.765 | 53.595 | 53.755 | 320800.0 |
| 2003-11-10 11:00:00 | IWM | ETF | 53.76 | 53.805 | 53.695 | 53.695 | 240400.0 |
> showing 50 of 799 rows — these rows as CSV