PREVIEW / etf_30min / 2001-06-25
file: by_date/etf_30min/2001/2001-06-25.parquet size: 15 KB rows: 354
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-06-25 09:30:00 | SPY | ETF | 123.28 | 123.44 | 123.02 | 123.28 | 1143500.0 |
| 2001-06-25 10:00:00 | SPY | ETF | 123.27 | 123.41 | 122.88 | 122.93 | 457900.0 |
| 2001-06-25 10:30:00 | SPY | ETF | 122.96 | 123.02 | 122.67 | 122.76 | 640300.0 |
| 2001-06-25 11:00:00 | SPY | ETF | 122.75 | 123.08 | 122.5 | 122.62 | 491300.0 |
| 2001-06-25 11:30:00 | SPY | ETF | 122.6 | 122.63 | 122.4 | 122.46 | 547300.0 |
| 2001-06-25 12:00:00 | SPY | ETF | 122.49 | 122.49 | 122.12 | 122.27 | 428900.0 |
| 2001-06-25 12:30:00 | SPY | ETF | 122.3 | 122.3 | 121.9 | 121.95 | 753200.0 |
| 2001-06-25 13:00:00 | SPY | ETF | 121.99 | 122.34 | 121.92 | 122.34 | 519500.0 |
| 2001-06-25 13:30:00 | SPY | ETF | 122.38 | 122.38 | 121.99 | 122.24 | 259900.0 |
| 2001-06-25 14:00:00 | SPY | ETF | 122.19 | 122.23 | 121.6 | 121.68 | 609700.0 |
| 2001-06-25 14:30:00 | SPY | ETF | 121.68 | 121.93 | 121.5 | 121.79 | 427500.0 |
| 2001-06-25 15:00:00 | SPY | ETF | 121.78 | 122.14 | 121.71 | 121.91 | 490000.0 |
| 2001-06-25 15:30:00 | SPY | ETF | 121.91 | 122.29 | 121.85 | 122.13 | 895000.0 |
| 2001-06-25 16:00:00 | SPY | ETF | 122.1 | 122.2 | 121.72 | 121.72 | 524800.0 |
| 2001-06-25 16:30:00 | SPY | ETF | 121.75 | 122.11 | 121.75 | 122.11 | 2600.0 |
| 2001-06-25 17:00:00 | SPY | ETF | 121.72 | 121.72 | 121.72 | 121.72 | 25000.0 |
| 2001-06-25 09:30:00 | QQQ | ETF | 43.61 | 43.8 | 43.3 | 43.62 | 6154700.0 |
| 2001-06-25 10:00:00 | QQQ | ETF | 43.62 | 43.75 | 43.34 | 43.43 | 3808300.0 |
| 2001-06-25 10:30:00 | QQQ | ETF | 43.41 | 43.48 | 43.15 | 43.3 | 2882800.0 |
| 2001-06-25 11:00:00 | QQQ | ETF | 43.3 | 43.55 | 43.1 | 43.17 | 3192100.0 |
| 2001-06-25 11:30:00 | QQQ | ETF | 43.19 | 43.31 | 43.05 | 43.16 | 1296400.0 |
| 2001-06-25 12:00:00 | QQQ | ETF | 43.16 | 43.18 | 42.85 | 42.88 | 2195600.0 |
| 2001-06-25 12:30:00 | QQQ | ETF | 42.88 | 42.94 | 42.65 | 42.8 | 2141400.0 |
| 2001-06-25 13:00:00 | QQQ | ETF | 42.83 | 43.1 | 42.73 | 43.1 | 1790600.0 |
| 2001-06-25 13:30:00 | QQQ | ETF | 43.08 | 43.1 | 42.81 | 43.06 | 1533000.0 |
| 2001-06-25 14:00:00 | QQQ | ETF | 43.04 | 43.09 | 42.7 | 42.88 | 1807100.0 |
| 2001-06-25 14:30:00 | QQQ | ETF | 42.85 | 43.26 | 42.76 | 43.19 | 2405900.0 |
| 2001-06-25 15:00:00 | QQQ | ETF | 43.2 | 43.42 | 43.1 | 43.22 | 3790600.0 |
| 2001-06-25 15:30:00 | QQQ | ETF | 43.22 | 43.57 | 43.2 | 43.44 | 3364400.0 |
| 2001-06-25 16:00:00 | QQQ | ETF | 43.5 | 43.55 | 43.18 | 43.37 | 1053200.0 |
| 2001-06-25 16:30:00 | QQQ | ETF | 43.35 | 43.5 | 43.33 | 43.34 | 27500.0 |
| 2001-06-25 17:00:00 | QQQ | ETF | 43.33 | 43.37 | 43.25 | 43.25 | 44700.0 |
| 2001-06-25 17:30:00 | QQQ | ETF | 43.26 | 43.3 | 43.2 | 43.25 | 329700.0 |
| 2001-06-25 18:00:00 | QQQ | ETF | 43.23 | 43.25 | 43.12 | 43.14 | 20500.0 |
| 2001-06-25 09:30:00 | IWM | ETF | 48.85 | 48.885 | 48.7 | 48.75 | 247200.0 |
| 2001-06-25 10:00:00 | IWM | ETF | 48.8 | 48.825 | 48.655 | 48.75 | 217200.0 |
| 2001-06-25 10:30:00 | IWM | ETF | 48.735 | 48.735 | 48.5 | 48.555 | 175000.0 |
| 2001-06-25 11:00:00 | IWM | ETF | 48.595 | 48.62 | 48.45 | 48.45 | 170600.0 |
| 2001-06-25 11:30:00 | IWM | ETF | 48.5 | 48.59 | 48.415 | 48.48 | 83200.0 |
| 2001-06-25 12:00:00 | IWM | ETF | 48.48 | 48.5 | 48.405 | 48.425 | 127000.0 |
| 2001-06-25 12:30:00 | IWM | ETF | 48.375 | 48.435 | 48.325 | 48.37 | 110600.0 |
| 2001-06-25 13:00:00 | IWM | ETF | 48.36 | 48.5 | 48.305 | 48.335 | 146600.0 |
| 2001-06-25 13:30:00 | IWM | ETF | 48.34 | 48.44 | 48.305 | 48.305 | 8600.0 |
| 2001-06-25 14:00:00 | IWM | ETF | 48.3 | 48.335 | 48.125 | 48.17 | 128000.0 |
| 2001-06-25 14:30:00 | IWM | ETF | 48.15 | 48.3 | 48.125 | 48.29 | 214200.0 |
| 2001-06-25 15:00:00 | IWM | ETF | 48.295 | 48.45 | 48.295 | 48.375 | 97000.0 |
| 2001-06-25 15:30:00 | IWM | ETF | 48.355 | 48.45 | 48.34 | 48.37 | 56600.0 |
| 2001-06-25 16:00:00 | IWM | ETF | 48.275 | 48.275 | 48.26 | 48.26 | 28000.0 |
| 2001-06-25 09:30:00 | DIA | ETF | 106.57 | 106.6 | 106.11 | 106.5 | 206800.0 |
| 2001-06-25 10:00:00 | DIA | ETF | 106.54 | 106.55 | 106.1 | 106.15 | 76400.0 |
> showing 50 of 354 rows — these rows as CSV