PREVIEW / etf_30min / 2005-09-30
file: by_date/etf_30min/2005/2005-09-30.parquet size: 47 KB rows: 1,712
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-30 07:30:00 | SPY | ETF | 122.61 | 122.64 | 122.61 | 122.64 | 32500.0 |
| 2005-09-30 08:00:00 | SPY | ETF | 122.58 | 122.74 | 122.58 | 122.73 | 468400.0 |
| 2005-09-30 08:30:00 | SPY | ETF | 122.67 | 123.58 | 122.55 | 122.66 | 302400.0 |
| 2005-09-30 09:00:00 | SPY | ETF | 122.57 | 122.66 | 122.57 | 122.6 | 97100.0 |
| 2005-09-30 09:30:00 | SPY | ETF | 122.62 | 122.76 | 122.45 | 122.73 | 5768100.0 |
| 2005-09-30 10:00:00 | SPY | ETF | 122.76 | 122.82 | 122.52 | 122.74 | 4789800.0 |
| 2005-09-30 10:30:00 | SPY | ETF | 122.73 | 122.97 | 122.62 | 122.85 | 5085400.0 |
| 2005-09-30 11:00:00 | SPY | ETF | 122.85 | 122.89 | 122.63 | 122.71 | 3780900.0 |
| 2005-09-30 11:30:00 | SPY | ETF | 122.7 | 122.79 | 122.52 | 122.6 | 2741700.0 |
| 2005-09-30 12:00:00 | SPY | ETF | 122.59 | 122.73 | 122.53 | 122.65 | 1110800.0 |
| 2005-09-30 12:30:00 | SPY | ETF | 122.65 | 122.77 | 122.62 | 122.66 | 1185400.0 |
| 2005-09-30 13:00:00 | SPY | ETF | 122.66 | 122.68 | 122.5 | 122.61 | 1440000.0 |
| 2005-09-30 13:30:00 | SPY | ETF | 122.61 | 122.73 | 122.57 | 122.622 | 1113800.0 |
| 2005-09-30 14:00:00 | SPY | ETF | 122.63 | 122.84 | 122.5 | 122.8 | 1514500.0 |
| 2005-09-30 14:30:00 | SPY | ETF | 122.8 | 122.95 | 122.72 | 122.8 | 1883400.0 |
| 2005-09-30 15:00:00 | SPY | ETF | 122.79 | 122.87 | 122.6 | 122.64 | 3903700.0 |
| 2005-09-30 15:30:00 | SPY | ETF | 122.64 | 122.85 | 121.74 | 122.85 | 6617200.0 |
| 2005-09-30 16:00:00 | SPY | ETF | 122.86 | 123.07 | 122.8 | 123.03 | 1342100.0 |
| 2005-09-30 16:30:00 | SPY | ETF | 122.98 | 123.05 | 122.95 | 123.04 | 50800.0 |
| 2005-09-30 17:00:00 | SPY | ETF | 123.0 | 123.02 | 123.0 | 123.0 | 500.0 |
| 2005-09-30 17:30:00 | SPY | ETF | 123.05 | 123.08 | 123.0 | 123.01 | 1100.0 |
| 2005-09-30 18:00:00 | SPY | ETF | 123.04 | 123.06 | 123.04 | 123.05 | 1100.0 |
| 2005-09-30 18:30:00 | SPY | ETF | 123.07 | 123.1 | 123.05 | 123.05 | 2000.0 |
| 2005-09-30 19:00:00 | SPY | ETF | 123.05 | 123.05 | 123.05 | 123.05 | 100.0 |
| 2005-09-30 19:30:00 | SPY | ETF | 123.08 | 123.08 | 123.08 | 123.08 | 100.0 |
| 2005-09-30 09:30:00 | QQQ | ETF | 39.15 | 39.27 | 39.13 | 39.26 | 10250600.0 |
| 2005-09-30 10:00:00 | QQQ | ETF | 39.26 | 39.34 | 39.23 | 39.32 | 8528800.0 |
| 2005-09-30 10:30:00 | QQQ | ETF | 39.33 | 39.45 | 39.29 | 39.39 | 12466000.0 |
| 2005-09-30 11:00:00 | QQQ | ETF | 39.38 | 39.4 | 39.3 | 39.32 | 4633900.0 |
| 2005-09-30 11:30:00 | QQQ | ETF | 39.32 | 39.35 | 39.23 | 39.26 | 3125900.0 |
| 2005-09-30 12:00:00 | QQQ | ETF | 39.25 | 39.35 | 39.24 | 39.32 | 2684800.0 |
| 2005-09-30 12:30:00 | QQQ | ETF | 39.32 | 39.36 | 39.31 | 39.34 | 1416100.0 |
| 2005-09-30 13:00:00 | QQQ | ETF | 39.33 | 39.35 | 39.24 | 39.29 | 3042800.0 |
| 2005-09-30 13:30:00 | QQQ | ETF | 39.3 | 39.34 | 39.29 | 39.31 | 2589200.0 |
| 2005-09-30 14:00:00 | QQQ | ETF | 39.31 | 39.4 | 39.29 | 39.37 | 2804000.0 |
| 2005-09-30 14:30:00 | QQQ | ETF | 39.37 | 39.44 | 39.35 | 39.37 | 3803000.0 |
| 2005-09-30 15:00:00 | QQQ | ETF | 39.38 | 39.41 | 39.3 | 39.31 | 5549500.0 |
| 2005-09-30 15:30:00 | QQQ | ETF | 39.31 | 39.46 | 39.27 | 39.45 | 10256800.0 |
| 2005-09-30 08:00:00 | IWM | ETF | 66.11 | 66.12 | 66.11 | 66.12 | 21100.0 |
| 2005-09-30 08:30:00 | IWM | ETF | 66.01 | 66.08 | 66.01 | 66.08 | 3600.0 |
| 2005-09-30 09:00:00 | IWM | ETF | 66.06 | 66.07 | 66.04 | 66.05 | 12200.0 |
| 2005-09-30 09:30:00 | IWM | ETF | 66.04 | 66.14 | 65.79 | 66.05 | 4979200.0 |
| 2005-09-30 10:00:00 | IWM | ETF | 66.05 | 66.21 | 65.91 | 66.18 | 5460700.0 |
| 2005-09-30 10:30:00 | IWM | ETF | 66.18 | 66.39 | 66.11 | 66.33 | 3075200.0 |
| 2005-09-30 11:00:00 | IWM | ETF | 66.31 | 66.32 | 66.05 | 66.11 | 2713700.0 |
| 2005-09-30 11:30:00 | IWM | ETF | 66.12 | 66.18 | 65.94 | 65.99 | 2077000.0 |
| 2005-09-30 12:00:00 | IWM | ETF | 65.99 | 66.13 | 65.92 | 66.09 | 1294700.0 |
| 2005-09-30 12:30:00 | IWM | ETF | 66.09 | 66.18 | 66.07 | 66.12 | 407500.0 |
| 2005-09-30 13:00:00 | IWM | ETF | 66.11 | 66.15 | 66.05 | 66.14 | 440100.0 |
| 2005-09-30 13:30:00 | IWM | ETF | 66.15 | 66.21 | 66.1 | 66.18 | 361800.0 |
> showing 50 of 1,712 rows — these rows as CSV