PREVIEW / etf_30min / 2005-09-08
file: by_date/etf_30min/2005/2005-09-08.parquet size: 44 KB rows: 1,623
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-08 07:00:00 | SPY | ETF | 123.67 | 123.68 | 123.57 | 123.57 | 29200.0 |
| 2005-09-08 07:30:00 | SPY | ETF | 123.55 | 123.59 | 123.55 | 123.55 | 30300.0 |
| 2005-09-08 08:00:00 | SPY | ETF | 123.54 | 123.65 | 123.54 | 123.6 | 395000.0 |
| 2005-09-08 08:30:00 | SPY | ETF | 123.65 | 123.65 | 123.55 | 123.58 | 225100.0 |
| 2005-09-08 09:00:00 | SPY | ETF | 123.58 | 123.65 | 123.53 | 123.65 | 166500.0 |
| 2005-09-08 09:30:00 | SPY | ETF | 123.66 | 123.7 | 123.46 | 123.59 | 3271400.0 |
| 2005-09-08 10:00:00 | SPY | ETF | 123.59 | 123.79 | 123.55 | 123.68 | 3935000.0 |
| 2005-09-08 10:30:00 | SPY | ETF | 123.68 | 124.0 | 123.58 | 123.68 | 5973800.0 |
| 2005-09-08 11:00:00 | SPY | ETF | 123.68 | 123.81 | 123.56 | 123.79 | 2024000.0 |
| 2005-09-08 11:30:00 | SPY | ETF | 123.78 | 123.94 | 123.7 | 123.8 | 1696900.0 |
| 2005-09-08 12:00:00 | SPY | ETF | 123.8 | 123.85 | 123.71 | 123.8 | 1100700.0 |
| 2005-09-08 12:30:00 | SPY | ETF | 123.79 | 123.8 | 123.7 | 123.75 | 938700.0 |
| 2005-09-08 13:00:00 | SPY | ETF | 123.75 | 123.79 | 123.69 | 123.74 | 399300.0 |
| 2005-09-08 13:30:00 | SPY | ETF | 123.74 | 123.77 | 123.58 | 123.68 | 1379200.0 |
| 2005-09-08 14:00:00 | SPY | ETF | 123.68 | 123.77 | 123.45 | 123.49 | 2636800.0 |
| 2005-09-08 14:30:00 | SPY | ETF | 123.5 | 123.68 | 123.47 | 123.49 | 1553700.0 |
| 2005-09-08 15:00:00 | SPY | ETF | 123.49 | 123.705 | 123.31 | 123.45 | 4646100.0 |
| 2005-09-08 15:30:00 | SPY | ETF | 123.45 | 123.62 | 123.42 | 123.58 | 3990300.0 |
| 2005-09-08 16:00:00 | SPY | ETF | 123.5985 | 123.6 | 123.46 | 123.52 | 968500.0 |
| 2005-09-08 16:30:00 | SPY | ETF | 123.52 | 123.57 | 123.5 | 123.54 | 421800.0 |
| 2005-09-08 17:00:00 | SPY | ETF | 123.52 | 123.53 | 123.5 | 123.5 | 59800.0 |
| 2005-09-08 17:30:00 | SPY | ETF | 123.53 | 123.53 | 123.5 | 123.51 | 500.0 |
| 2005-09-08 18:00:00 | SPY | ETF | 123.52 | 123.54 | 123.5 | 123.53 | 2100.0 |
| 2005-09-08 18:30:00 | SPY | ETF | 123.57 | 123.57 | 123.57 | 123.57 | 3500.0 |
| 2005-09-08 09:30:00 | QQQ | ETF | 39.29 | 39.34 | 39.27 | 39.33 | 6508800.0 |
| 2005-09-08 10:00:00 | QQQ | ETF | 39.33 | 39.44 | 39.32 | 39.39 | 5251100.0 |
| 2005-09-08 10:30:00 | QQQ | ETF | 39.4 | 39.56 | 39.39 | 39.42 | 10408700.0 |
| 2005-09-08 11:00:00 | QQQ | ETF | 39.41 | 39.51 | 39.4 | 39.5 | 4253100.0 |
| 2005-09-08 11:30:00 | QQQ | ETF | 39.5 | 39.54 | 39.48 | 39.49 | 3160500.0 |
| 2005-09-08 12:00:00 | QQQ | ETF | 39.49 | 39.57 | 39.46 | 39.55 | 4939300.0 |
| 2005-09-08 12:30:00 | QQQ | ETF | 39.55 | 39.56 | 39.5 | 39.52 | 2659200.0 |
| 2005-09-08 13:00:00 | QQQ | ETF | 39.52 | 39.54 | 39.5 | 39.52 | 1336900.0 |
| 2005-09-08 13:30:00 | QQQ | ETF | 39.52 | 39.54 | 39.4 | 39.44 | 3941000.0 |
| 2005-09-08 14:00:00 | QQQ | ETF | 39.44 | 39.5 | 39.36 | 39.38 | 6358200.0 |
| 2005-09-08 14:30:00 | QQQ | ETF | 39.37 | 39.44 | 39.37 | 39.41 | 3303500.0 |
| 2005-09-08 15:00:00 | QQQ | ETF | 39.41 | 39.41 | 39.3 | 39.34 | 6343200.0 |
| 2005-09-08 15:30:00 | QQQ | ETF | 39.35 | 39.41 | 39.34 | 39.41 | 5997400.0 |
| 2005-09-08 08:00:00 | IWM | ETF | 67.2 | 67.2 | 67.13 | 67.18 | 4500.0 |
| 2005-09-08 08:30:00 | IWM | ETF | 67.17 | 67.17 | 67.12 | 67.13 | 26600.0 |
| 2005-09-08 09:00:00 | IWM | ETF | 67.13 | 67.21 | 67.12 | 67.2 | 26100.0 |
| 2005-09-08 09:30:00 | IWM | ETF | 67.19 | 67.3 | 66.94 | 67.01 | 2059300.0 |
| 2005-09-08 10:00:00 | IWM | ETF | 67.0 | 67.15 | 66.94 | 67.08 | 1338000.0 |
| 2005-09-08 10:30:00 | IWM | ETF | 67.09 | 67.25 | 67.03 | 67.09 | 1267400.0 |
| 2005-09-08 11:00:00 | IWM | ETF | 67.09 | 67.14 | 67.02 | 67.12 | 969400.0 |
| 2005-09-08 11:30:00 | IWM | ETF | 67.11 | 67.22 | 67.1 | 67.17 | 589400.0 |
| 2005-09-08 12:00:00 | IWM | ETF | 67.17 | 67.27 | 67.16 | 67.25 | 282600.0 |
| 2005-09-08 12:30:00 | IWM | ETF | 67.24 | 67.25 | 67.18 | 67.25 | 281600.0 |
| 2005-09-08 13:00:00 | IWM | ETF | 67.25 | 67.26 | 67.18 | 67.19 | 139500.0 |
| 2005-09-08 13:30:00 | IWM | ETF | 67.2 | 67.22 | 67.06 | 67.1108 | 310800.0 |
| 2005-09-08 14:00:00 | IWM | ETF | 67.1 | 67.16 | 66.96 | 67.01 | 1017400.0 |
> showing 50 of 1,623 rows — these rows as CSV