PREVIEW / etf_30min / 2001-10-16
file: by_date/etf_30min/2001/2001-10-16.parquet size: 16 KB rows: 403
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-16 09:30:00 | SPY | ETF | 109.8 | 110.61 | 109.46 | 110.3 | 2779200.0 |
| 2001-10-16 10:00:00 | SPY | ETF | 110.27 | 110.45 | 109.75 | 109.89 | 1456000.0 |
| 2001-10-16 10:30:00 | SPY | ETF | 109.85 | 109.96 | 109.0 | 109.25 | 2271600.0 |
| 2001-10-16 11:00:00 | SPY | ETF | 109.26 | 109.44 | 108.95 | 109.12 | 1047400.0 |
| 2001-10-16 11:30:00 | SPY | ETF | 109.09 | 109.52 | 109.06 | 109.2 | 912000.0 |
| 2001-10-16 12:00:00 | SPY | ETF | 109.24 | 109.29 | 108.97 | 109.18 | 554700.0 |
| 2001-10-16 12:30:00 | SPY | ETF | 109.22 | 109.4 | 109.13 | 109.39 | 428900.0 |
| 2001-10-16 13:00:00 | SPY | ETF | 109.34 | 109.6 | 109.27 | 109.55 | 546400.0 |
| 2001-10-16 13:30:00 | SPY | ETF | 109.55 | 109.79 | 109.41 | 109.54 | 793400.0 |
| 2001-10-16 14:00:00 | SPY | ETF | 109.51 | 109.93 | 109.29 | 109.32 | 837700.0 |
| 2001-10-16 14:30:00 | SPY | ETF | 109.37 | 109.8 | 109.25 | 109.67 | 741900.0 |
| 2001-10-16 15:00:00 | SPY | ETF | 109.67 | 110.18 | 109.48 | 109.9 | 1050300.0 |
| 2001-10-16 15:30:00 | SPY | ETF | 109.88 | 110.24 | 109.84 | 110.06 | 1085600.0 |
| 2001-10-16 16:00:00 | SPY | ETF | 110.06 | 110.17 | 109.94 | 110.15 | 923600.0 |
| 2001-10-16 16:30:00 | SPY | ETF | 109.88 | 109.99 | 109.5 | 109.99 | 14700.0 |
| 2001-10-16 17:00:00 | SPY | ETF | 110.1 | 110.5 | 109.95 | 110.4 | 28500.0 |
| 2001-10-16 17:30:00 | SPY | ETF | 110.37 | 110.67 | 110.3 | 110.62 | 7900.0 |
| 2001-10-16 18:00:00 | SPY | ETF | 110.59 | 110.8 | 110.46 | 110.6 | 2300.0 |
| 2001-10-16 09:30:00 | QQQ | ETF | 34.66 | 35.06 | 34.35 | 34.89 | 13529200.0 |
| 2001-10-16 10:00:00 | QQQ | ETF | 34.89 | 35.0 | 34.65 | 34.7 | 7628300.0 |
| 2001-10-16 10:30:00 | QQQ | ETF | 34.7 | 34.74 | 34.07 | 34.33 | 10986200.0 |
| 2001-10-16 11:00:00 | QQQ | ETF | 34.32 | 34.5 | 34.17 | 34.29 | 5592700.0 |
| 2001-10-16 11:30:00 | QQQ | ETF | 34.25 | 34.49 | 34.22 | 34.3 | 2929400.0 |
| 2001-10-16 12:00:00 | QQQ | ETF | 34.31 | 34.36 | 34.1 | 34.26 | 2716400.0 |
| 2001-10-16 12:30:00 | QQQ | ETF | 34.27 | 34.45 | 34.17 | 34.44 | 3299700.0 |
| 2001-10-16 13:00:00 | QQQ | ETF | 34.45 | 34.65 | 34.39 | 34.61 | 3688300.0 |
| 2001-10-16 13:30:00 | QQQ | ETF | 34.61 | 34.73 | 34.47 | 34.57 | 3001100.0 |
| 2001-10-16 14:00:00 | QQQ | ETF | 34.58 | 34.79 | 34.39 | 34.41 | 3555400.0 |
| 2001-10-16 14:30:00 | QQQ | ETF | 34.4 | 34.7 | 34.38 | 34.63 | 3278200.0 |
| 2001-10-16 15:00:00 | QQQ | ETF | 34.62 | 34.95 | 34.5 | 34.87 | 4996600.0 |
| 2001-10-16 15:30:00 | QQQ | ETF | 34.87 | 35.04 | 34.85 | 34.95 | 7365700.0 |
| 2001-10-16 16:00:00 | QQQ | ETF | 34.98 | 35.4 | 34.86 | 35.2 | 3115900.0 |
| 2001-10-16 16:30:00 | QQQ | ETF | 35.17 | 35.19 | 34.7 | 34.9 | 683000.0 |
| 2001-10-16 17:00:00 | QQQ | ETF | 34.9 | 35.34 | 34.85 | 35.31 | 666800.0 |
| 2001-10-16 17:30:00 | QQQ | ETF | 35.31 | 35.43 | 35.08 | 35.37 | 416000.0 |
| 2001-10-16 18:00:00 | QQQ | ETF | 35.43 | 35.5 | 35.26 | 35.46 | 202500.0 |
| 2001-10-16 09:30:00 | IWM | ETF | 42.95 | 43.29 | 42.95 | 43.135 | 15800.0 |
| 2001-10-16 10:00:00 | IWM | ETF | 43.13 | 43.25 | 42.935 | 42.935 | 58800.0 |
| 2001-10-16 10:30:00 | IWM | ETF | 43.11 | 43.22 | 42.875 | 42.91 | 133400.0 |
| 2001-10-16 11:00:00 | IWM | ETF | 42.865 | 43.125 | 42.865 | 42.97 | 128600.0 |
| 2001-10-16 11:30:00 | IWM | ETF | 43.075 | 43.15 | 42.91 | 43.07 | 11600.0 |
| 2001-10-16 12:00:00 | IWM | ETF | 43.015 | 43.015 | 43.015 | 43.015 | 400.0 |
| 2001-10-16 12:30:00 | IWM | ETF | 42.94 | 43.025 | 42.94 | 42.945 | 88800.0 |
| 2001-10-16 13:00:00 | IWM | ETF | 42.95 | 43.085 | 42.95 | 43.0 | 31000.0 |
| 2001-10-16 13:30:00 | IWM | ETF | 43.12 | 43.12 | 42.965 | 43.05 | 75600.0 |
| 2001-10-16 14:00:00 | IWM | ETF | 43.135 | 43.14 | 43.045 | 43.05 | 7600.0 |
| 2001-10-16 14:30:00 | IWM | ETF | 42.985 | 43.065 | 42.91 | 43.025 | 97000.0 |
| 2001-10-16 15:00:00 | IWM | ETF | 43.09 | 43.205 | 43.09 | 43.15 | 13800.0 |
| 2001-10-16 15:30:00 | IWM | ETF | 43.15 | 43.4 | 43.15 | 43.265 | 265800.0 |
| 2001-10-16 16:00:00 | IWM | ETF | 43.3 | 43.4 | 43.275 | 43.275 | 19000.0 |
> showing 50 of 403 rows — these rows as CSV