PREVIEW / etf_30min / 2003-06-12
file: by_date/etf_30min/2003/2003-06-12.parquet size: 24 KB rows: 724
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-06-12 08:00:00 | SPY | ETF | 100.95 | 100.99 | 100.85 | 100.99 | 24300.0 |
| 2003-06-12 08:30:00 | SPY | ETF | 100.95 | 101.0 | 100.76 | 100.92 | 48900.0 |
| 2003-06-12 09:00:00 | SPY | ETF | 100.89 | 100.89 | 100.75 | 100.78 | 6900.0 |
| 2003-06-12 09:30:00 | SPY | ETF | 100.75 | 100.9 | 100.33 | 100.33 | 5326300.0 |
| 2003-06-12 10:00:00 | SPY | ETF | 100.36 | 100.36 | 99.62 | 100.1 | 5591400.0 |
| 2003-06-12 10:30:00 | SPY | ETF | 100.09 | 100.48 | 99.97 | 100.36 | 3352200.0 |
| 2003-06-12 11:00:00 | SPY | ETF | 100.34 | 100.47 | 100.16 | 100.36 | 2042200.0 |
| 2003-06-12 11:30:00 | SPY | ETF | 100.36 | 100.43 | 100.06 | 100.07 | 1206800.0 |
| 2003-06-12 12:00:00 | SPY | ETF | 100.1 | 100.2 | 99.98 | 100.1 | 1081800.0 |
| 2003-06-12 12:30:00 | SPY | ETF | 100.09 | 100.48 | 100.09 | 100.43 | 1685400.0 |
| 2003-06-12 13:00:00 | SPY | ETF | 100.43 | 100.46 | 100.06 | 100.22 | 1300100.0 |
| 2003-06-12 13:30:00 | SPY | ETF | 100.28 | 100.4 | 99.9 | 100.04 | 2266700.0 |
| 2003-06-12 14:00:00 | SPY | ETF | 100.05 | 100.08 | 99.8 | 99.87 | 1979000.0 |
| 2003-06-12 14:30:00 | SPY | ETF | 99.87 | 100.05 | 99.74 | 99.99 | 1437500.0 |
| 2003-06-12 15:00:00 | SPY | ETF | 99.95 | 100.29 | 99.81 | 100.16 | 1469600.0 |
| 2003-06-12 15:30:00 | SPY | ETF | 100.2 | 100.62 | 100.15 | 100.48 | 3624500.0 |
| 2003-06-12 16:00:00 | SPY | ETF | 100.5 | 100.65 | 100.44 | 100.6 | 988700.0 |
| 2003-06-12 16:30:00 | SPY | ETF | 100.57 | 100.62 | 100.54 | 100.62 | 22200.0 |
| 2003-06-12 17:00:00 | SPY | ETF | 100.61 | 100.63 | 100.57 | 100.57 | 55700.0 |
| 2003-06-12 17:30:00 | SPY | ETF | 100.55 | 100.58 | 100.42 | 100.55 | 24600.0 |
| 2003-06-12 18:00:00 | SPY | ETF | 100.51 | 100.54 | 100.51 | 100.51 | 3200.0 |
| 2003-06-12 18:30:00 | SPY | ETF | 100.56 | 100.57 | 100.56 | 100.57 | 1300.0 |
| 2003-06-12 19:00:00 | SPY | ETF | 100.57 | 100.57 | 100.55 | 100.55 | 2200.0 |
| 2003-06-12 19:30:00 | SPY | ETF | 100.52 | 100.52 | 100.45 | 100.45 | 500.0 |
| 2003-06-12 08:00:00 | QQQ | ETF | 30.75 | 30.81 | 30.71 | 30.79 | 49000.0 |
| 2003-06-12 08:30:00 | QQQ | ETF | 30.8 | 30.81 | 30.7 | 30.72 | 150900.0 |
| 2003-06-12 09:00:00 | QQQ | ETF | 30.72 | 30.73 | 30.63 | 30.63 | 76000.0 |
| 2003-06-12 09:30:00 | QQQ | ETF | 30.63 | 30.75 | 30.44 | 30.45 | 16199800.0 |
| 2003-06-12 10:00:00 | QQQ | ETF | 30.45 | 30.51 | 30.26 | 30.45 | 12753200.0 |
| 2003-06-12 10:30:00 | QQQ | ETF | 30.44 | 30.63 | 30.42 | 30.56 | 6864200.0 |
| 2003-06-12 11:00:00 | QQQ | ETF | 30.55 | 30.66 | 30.5 | 30.62 | 4731200.0 |
| 2003-06-12 11:30:00 | QQQ | ETF | 30.62 | 30.64 | 30.44 | 30.47 | 3313800.0 |
| 2003-06-12 12:00:00 | QQQ | ETF | 30.48 | 30.55 | 30.37 | 30.43 | 3176700.0 |
| 2003-06-12 12:30:00 | QQQ | ETF | 30.44 | 30.57 | 30.42 | 30.5 | 2331300.0 |
| 2003-06-12 13:00:00 | QQQ | ETF | 30.52 | 30.52 | 30.41 | 30.48 | 1459200.0 |
| 2003-06-12 13:30:00 | QQQ | ETF | 30.49 | 30.55 | 30.34 | 30.39 | 2489300.0 |
| 2003-06-12 14:00:00 | QQQ | ETF | 30.4 | 30.44 | 30.32 | 30.35 | 2944500.0 |
| 2003-06-12 14:30:00 | QQQ | ETF | 30.35 | 30.45 | 30.3 | 30.42 | 3232400.0 |
| 2003-06-12 15:00:00 | QQQ | ETF | 30.42 | 30.59 | 30.38 | 30.53 | 4009000.0 |
| 2003-06-12 15:30:00 | QQQ | ETF | 30.53 | 30.63 | 30.51 | 30.55 | 6498500.0 |
| 2003-06-12 16:00:00 | QQQ | ETF | 30.56 | 30.69 | 30.01 | 30.62 | 2120500.0 |
| 2003-06-12 16:30:00 | QQQ | ETF | 30.61 | 30.67 | 30.54 | 30.54 | 670500.0 |
| 2003-06-12 17:00:00 | QQQ | ETF | 30.65 | 30.71 | 30.65 | 30.67 | 464500.0 |
| 2003-06-12 17:30:00 | QQQ | ETF | 30.67 | 30.68 | 30.65 | 30.66 | 77800.0 |
| 2003-06-12 18:00:00 | QQQ | ETF | 30.66 | 30.66 | 30.63 | 30.63 | 55600.0 |
| 2003-06-12 18:30:00 | QQQ | ETF | 30.64 | 30.64 | 30.62 | 30.62 | 15400.0 |
| 2003-06-12 19:00:00 | QQQ | ETF | 30.63 | 30.63 | 30.62 | 30.63 | 5700.0 |
| 2003-06-12 19:30:00 | QQQ | ETF | 30.61 | 30.63 | 30.61 | 30.63 | 37100.0 |
| 2003-06-12 09:00:00 | IWM | ETF | 45.705 | 45.705 | 45.705 | 45.705 | 400.0 |
| 2003-06-12 09:30:00 | IWM | ETF | 45.74 | 45.805 | 45.615 | 45.665 | 301200.0 |
> showing 50 of 724 rows — these rows as CSV