PREVIEW / etf_30min / 2002-08-27
file: by_date/etf_30min/2002/2002-08-27.parquet size: 20 KB rows: 566
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 |
|---|---|---|---|---|---|---|---|
| 2002-08-27 09:30:00 | SPY | ETF | 95.7 | 96.25 | 95.4 | 95.62 | 4562400.0 |
| 2002-08-27 10:00:00 | SPY | ETF | 95.66 | 95.7 | 94.3 | 94.7 | 7293900.0 |
| 2002-08-27 10:30:00 | SPY | ETF | 94.7 | 94.72 | 94.2 | 94.53 | 2336200.0 |
| 2002-08-27 11:00:00 | SPY | ETF | 94.6 | 95.36 | 94.52 | 95.35 | 2464100.0 |
| 2002-08-27 11:30:00 | SPY | ETF | 95.28 | 95.46 | 95.0 | 95.21 | 1884200.0 |
| 2002-08-27 12:00:00 | SPY | ETF | 95.18 | 95.21 | 94.81 | 94.85 | 1190500.0 |
| 2002-08-27 12:30:00 | SPY | ETF | 94.85 | 94.99 | 94.63 | 94.75 | 867400.0 |
| 2002-08-27 13:00:00 | SPY | ETF | 94.74 | 94.77 | 94.32 | 94.59 | 1092600.0 |
| 2002-08-27 13:30:00 | SPY | ETF | 94.62 | 94.88 | 94.1 | 94.29 | 2406300.0 |
| 2002-08-27 14:00:00 | SPY | ETF | 94.3 | 94.63 | 94.03 | 94.41 | 1681700.0 |
| 2002-08-27 14:30:00 | SPY | ETF | 94.38 | 94.58 | 93.9 | 94.01 | 2233900.0 |
| 2002-08-27 15:00:00 | SPY | ETF | 94.01 | 94.22 | 93.7 | 93.76 | 2251300.0 |
| 2002-08-27 15:30:00 | SPY | ETF | 93.79 | 94.04 | 93.5 | 93.9 | 3074200.0 |
| 2002-08-27 16:00:00 | SPY | ETF | 93.89 | 94.16 | 93.85 | 94.16 | 979500.0 |
| 2002-08-27 09:30:00 | QQQ | ETF | 25.43 | 25.51 | 25.0 | 25.09 | 14077700.0 |
| 2002-08-27 10:00:00 | QQQ | ETF | 25.1 | 25.1 | 24.65 | 24.79 | 13738500.0 |
| 2002-08-27 10:30:00 | QQQ | ETF | 24.8 | 24.85 | 24.64 | 24.72 | 6046900.0 |
| 2002-08-27 11:00:00 | QQQ | ETF | 24.72 | 24.95 | 24.69 | 24.9 | 5838900.0 |
| 2002-08-27 11:30:00 | QQQ | ETF | 24.9 | 24.95 | 24.76 | 24.82 | 3141600.0 |
| 2002-08-27 12:00:00 | QQQ | ETF | 24.82 | 24.83 | 24.7 | 24.71 | 3342100.0 |
| 2002-08-27 12:30:00 | QQQ | ETF | 24.71 | 24.75 | 24.52 | 24.61 | 5918800.0 |
| 2002-08-27 13:00:00 | QQQ | ETF | 24.63 | 24.64 | 24.45 | 24.61 | 5960100.0 |
| 2002-08-27 13:30:00 | QQQ | ETF | 24.58 | 24.67 | 24.4 | 24.44 | 5976600.0 |
| 2002-08-27 14:00:00 | QQQ | ETF | 24.45 | 24.55 | 24.36 | 24.46 | 5391700.0 |
| 2002-08-27 14:30:00 | QQQ | ETF | 24.49 | 24.5 | 24.29 | 24.35 | 4063500.0 |
| 2002-08-27 15:00:00 | QQQ | ETF | 24.35 | 24.4 | 24.19 | 24.21 | 3975000.0 |
| 2002-08-27 15:30:00 | QQQ | ETF | 24.25 | 24.38 | 24.15 | 24.26 | 9452100.0 |
| 2002-08-27 16:00:00 | QQQ | ETF | 24.26 | 24.37 | 24.21 | 24.37 | 972900.0 |
| 2002-08-27 09:30:00 | IWM | ETF | 40.875 | 40.895 | 40.335 | 40.445 | 347000.0 |
| 2002-08-27 10:00:00 | IWM | ETF | 40.33 | 40.33 | 40.005 | 40.185 | 94600.0 |
| 2002-08-27 10:30:00 | IWM | ETF | 40.205 | 40.275 | 40.135 | 40.275 | 115400.0 |
| 2002-08-27 11:00:00 | IWM | ETF | 40.275 | 40.53 | 40.26 | 40.5 | 332600.0 |
| 2002-08-27 11:30:00 | IWM | ETF | 40.5 | 40.52 | 40.29 | 40.37 | 203600.0 |
| 2002-08-27 12:00:00 | IWM | ETF | 40.375 | 40.375 | 40.25 | 40.26 | 112800.0 |
| 2002-08-27 12:30:00 | IWM | ETF | 40.3 | 40.3 | 40.21 | 40.235 | 138200.0 |
| 2002-08-27 13:00:00 | IWM | ETF | 40.185 | 40.225 | 40.14 | 40.16 | 64400.0 |
| 2002-08-27 13:30:00 | IWM | ETF | 40.165 | 40.305 | 40.14 | 40.155 | 220200.0 |
| 2002-08-27 14:00:00 | IWM | ETF | 40.11 | 40.3 | 40.11 | 40.25 | 242400.0 |
| 2002-08-27 14:30:00 | IWM | ETF | 40.28 | 40.32 | 40.09 | 40.12 | 175800.0 |
| 2002-08-27 15:00:00 | IWM | ETF | 40.085 | 40.125 | 39.89 | 39.9 | 217800.0 |
| 2002-08-27 15:30:00 | IWM | ETF | 39.85 | 39.86 | 39.66 | 39.665 | 459200.0 |
| 2002-08-27 16:00:00 | IWM | ETF | 39.66 | 39.775 | 39.66 | 39.775 | 600.0 |
| 2002-08-27 09:30:00 | DIA | ETF | 89.98 | 90.4 | 89.62 | 89.87 | 1460400.0 |
| 2002-08-27 10:00:00 | DIA | ETF | 89.88 | 89.94 | 88.64 | 88.89 | 1575800.0 |
| 2002-08-27 10:30:00 | DIA | ETF | 88.88 | 88.98 | 88.55 | 88.85 | 1010100.0 |
| 2002-08-27 11:00:00 | DIA | ETF | 88.89 | 89.61 | 88.8 | 89.61 | 870500.0 |
| 2002-08-27 11:30:00 | DIA | ETF | 89.54 | 89.7 | 89.31 | 89.48 | 498100.0 |
| 2002-08-27 12:00:00 | DIA | ETF | 89.47 | 89.49 | 89.2 | 89.25 | 157800.0 |
| 2002-08-27 12:30:00 | DIA | ETF | 89.22 | 89.34 | 88.96 | 89.07 | 188600.0 |
| 2002-08-27 13:00:00 | DIA | ETF | 89.12 | 89.3 | 88.75 | 89.12 | 540400.0 |
> showing 50 of 566 rows — these rows as CSV