PREVIEW / etf_30min / 2001-04-24
file: by_date/etf_30min/2001/2001-04-24.parquet size: 14 KB rows: 346
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-04-24 09:30:00 | SPY | ETF | 122.52 | 122.99 | 122.35 | 122.7 | 1196200.0 |
| 2001-04-24 10:00:00 | SPY | ETF | 122.61 | 123.65 | 122.26 | 123.44 | 1343000.0 |
| 2001-04-24 10:30:00 | SPY | ETF | 123.45 | 123.65 | 123.06 | 123.09 | 366700.0 |
| 2001-04-24 11:00:00 | SPY | ETF | 123.09 | 123.16 | 122.72 | 122.98 | 347900.0 |
| 2001-04-24 11:30:00 | SPY | ETF | 123.0 | 123.12 | 122.75 | 122.96 | 421700.0 |
| 2001-04-24 12:00:00 | SPY | ETF | 122.85 | 122.85 | 122.27 | 122.68 | 690200.0 |
| 2001-04-24 12:30:00 | SPY | ETF | 122.71 | 122.79 | 122.43 | 122.5 | 1185800.0 |
| 2001-04-24 13:00:00 | SPY | ETF | 122.65 | 122.78 | 122.22 | 122.78 | 431200.0 |
| 2001-04-24 13:30:00 | SPY | ETF | 122.75 | 122.88 | 122.39 | 122.4 | 557900.0 |
| 2001-04-24 14:00:00 | SPY | ETF | 122.4 | 122.49 | 122.08 | 122.35 | 360000.0 |
| 2001-04-24 14:30:00 | SPY | ETF | 122.35 | 122.35 | 121.81 | 122.11 | 275100.0 |
| 2001-04-24 15:00:00 | SPY | ETF | 122.1 | 122.19 | 121.3 | 121.51 | 870100.0 |
| 2001-04-24 15:30:00 | SPY | ETF | 121.5 | 121.58 | 121.1 | 121.13 | 1049700.0 |
| 2001-04-24 16:00:00 | SPY | ETF | 121.13 | 122.29 | 121.1 | 121.8 | 783400.0 |
| 2001-04-24 16:30:00 | SPY | ETF | 121.62 | 121.96 | 121.5 | 121.65 | 1000.0 |
| 2001-04-24 17:00:00 | SPY | ETF | 121.65 | 121.65 | 121.5 | 121.55 | 2200.0 |
| 2001-04-24 17:30:00 | SPY | ETF | 121.5 | 121.5 | 121.35 | 121.36 | 3800.0 |
| 2001-04-24 18:00:00 | SPY | ETF | 121.35 | 121.35 | 121.25 | 121.3 | 2100.0 |
| 2001-04-24 09:30:00 | QQQ | ETF | 45.1 | 45.22 | 44.52 | 44.86 | 12123100.0 |
| 2001-04-24 10:00:00 | QQQ | ETF | 44.95 | 46.29 | 44.67 | 45.95 | 14756100.0 |
| 2001-04-24 10:30:00 | QQQ | ETF | 45.98 | 46.42 | 45.7 | 45.75 | 6207500.0 |
| 2001-04-24 11:00:00 | QQQ | ETF | 45.7 | 45.78 | 45.36 | 45.7 | 5852900.0 |
| 2001-04-24 11:30:00 | QQQ | ETF | 45.66 | 45.9 | 45.55 | 45.65 | 4852200.0 |
| 2001-04-24 12:00:00 | QQQ | ETF | 45.66 | 45.7 | 45.15 | 45.6 | 3846500.0 |
| 2001-04-24 12:30:00 | QQQ | ETF | 45.61 | 45.85 | 45.42 | 45.51 | 2692900.0 |
| 2001-04-24 13:00:00 | QQQ | ETF | 45.54 | 45.6 | 45.22 | 45.55 | 2042500.0 |
| 2001-04-24 13:30:00 | QQQ | ETF | 45.55 | 45.66 | 45.23 | 45.29 | 2695700.0 |
| 2001-04-24 14:00:00 | QQQ | ETF | 45.27 | 45.31 | 44.65 | 44.84 | 5684500.0 |
| 2001-04-24 14:30:00 | QQQ | ETF | 44.84 | 44.9 | 44.1 | 44.36 | 6368300.0 |
| 2001-04-24 15:00:00 | QQQ | ETF | 44.38 | 44.5 | 43.9 | 44.0 | 6737700.0 |
| 2001-04-24 15:30:00 | QQQ | ETF | 44.01 | 44.1 | 43.75 | 43.95 | 7698500.0 |
| 2001-04-24 16:00:00 | QQQ | ETF | 43.96 | 44.5 | 43.92 | 44.21 | 2627500.0 |
| 2001-04-24 16:30:00 | QQQ | ETF | 44.42 | 44.47 | 44.0 | 44.05 | 134500.0 |
| 2001-04-24 17:00:00 | QQQ | ETF | 44.09 | 44.25 | 44.0 | 44.1 | 51600.0 |
| 2001-04-24 17:30:00 | QQQ | ETF | 44.05 | 44.1 | 43.86 | 43.87 | 55000.0 |
| 2001-04-24 18:00:00 | QQQ | ETF | 43.9 | 44.17 | 43.9 | 44.05 | 14700.0 |
| 2001-04-24 09:30:00 | IWM | ETF | 46.1 | 46.1 | 45.875 | 45.975 | 17400.0 |
| 2001-04-24 10:00:00 | IWM | ETF | 46.045 | 46.5 | 46.045 | 46.35 | 139600.0 |
| 2001-04-24 10:30:00 | IWM | ETF | 46.45 | 46.5 | 46.325 | 46.45 | 31800.0 |
| 2001-04-24 11:00:00 | IWM | ETF | 46.425 | 46.425 | 46.425 | 46.425 | 1000.0 |
| 2001-04-24 11:30:00 | IWM | ETF | 46.325 | 46.45 | 46.28 | 46.425 | 7400.0 |
| 2001-04-24 12:00:00 | IWM | ETF | 46.28 | 46.28 | 46.1 | 46.2 | 53400.0 |
| 2001-04-24 12:30:00 | IWM | ETF | 46.25 | 46.375 | 46.25 | 46.35 | 19200.0 |
| 2001-04-24 13:00:00 | IWM | ETF | 46.25 | 46.25 | 46.075 | 46.175 | 6600.0 |
| 2001-04-24 13:30:00 | IWM | ETF | 46.2 | 46.225 | 46.2 | 46.225 | 1200.0 |
| 2001-04-24 14:00:00 | IWM | ETF | 46.35 | 46.35 | 46.105 | 46.105 | 600.0 |
| 2001-04-24 14:30:00 | IWM | ETF | 46.2 | 46.2 | 46.025 | 46.055 | 7400.0 |
| 2001-04-24 15:00:00 | IWM | ETF | 46.005 | 46.005 | 45.825 | 45.825 | 7000.0 |
| 2001-04-24 15:30:00 | IWM | ETF | 45.95 | 46.025 | 45.85 | 45.85 | 4200.0 |
| 2001-04-24 16:00:00 | IWM | ETF | 45.995 | 46.15 | 45.995 | 46.15 | 8800.0 |
> showing 50 of 346 rows — these rows as CSV