PREVIEW / etf_30min / 2005-11-11
file: by_date/etf_30min/2005/2005-11-11.parquet size: 48 KB rows: 1,744
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-11-11 06:30:00 | SPY | ETF | 123.43 | 123.44 | 123.43 | 123.44 | 5000.0 |
| 2005-11-11 07:30:00 | SPY | ETF | 123.41 | 123.41 | 123.33 | 123.39 | 4400.0 |
| 2005-11-11 08:00:00 | SPY | ETF | 123.38 | 123.41 | 123.33 | 123.38 | 394700.0 |
| 2005-11-11 08:30:00 | SPY | ETF | 123.37 | 123.41 | 123.37 | 123.39 | 31100.0 |
| 2005-11-11 09:00:00 | SPY | ETF | 123.39 | 123.43 | 123.35 | 123.35 | 164200.0 |
| 2005-11-11 09:30:00 | SPY | ETF | 123.35 | 123.49 | 123.28 | 123.44 | 5752800.0 |
| 2005-11-11 10:00:00 | SPY | ETF | 123.44 | 123.51 | 123.34 | 123.4 | 3120000.0 |
| 2005-11-11 10:30:00 | SPY | ETF | 123.39 | 123.44 | 123.36 | 123.43 | 1081900.0 |
| 2005-11-11 11:00:00 | SPY | ETF | 123.43 | 123.59 | 123.43 | 123.51 | 3887800.0 |
| 2005-11-11 11:30:00 | SPY | ETF | 123.5 | 123.53 | 123.41 | 123.43 | 1626700.0 |
| 2005-11-11 12:00:00 | SPY | ETF | 123.42 | 123.5 | 123.36 | 123.46 | 2252000.0 |
| 2005-11-11 12:30:00 | SPY | ETF | 123.46 | 123.55 | 123.41 | 123.42 | 1430500.0 |
| 2005-11-11 13:00:00 | SPY | ETF | 123.42 | 123.51 | 123.38 | 123.44 | 2272900.0 |
| 2005-11-11 13:30:00 | SPY | ETF | 123.43 | 123.49 | 123.4 | 123.48 | 685600.0 |
| 2005-11-11 14:00:00 | SPY | ETF | 123.5 | 123.58 | 123.46 | 123.53 | 1119300.0 |
| 2005-11-11 14:30:00 | SPY | ETF | 123.54 | 123.67 | 123.53 | 123.62 | 2584900.0 |
| 2005-11-11 15:00:00 | SPY | ETF | 123.61 | 123.69 | 123.6 | 123.66 | 2325900.0 |
| 2005-11-11 15:30:00 | SPY | ETF | 123.66 | 123.84 | 123.64 | 123.65 | 4126100.0 |
| 2005-11-11 16:00:00 | SPY | ETF | 123.66 | 123.8 | 123.63 | 123.76 | 1191900.0 |
| 2005-11-11 16:30:00 | SPY | ETF | 123.76 | 123.79 | 123.76 | 123.78 | 30800.0 |
| 2005-11-11 17:00:00 | SPY | ETF | 123.8 | 123.84 | 123.8 | 123.8 | 5400.0 |
| 2005-11-11 18:00:00 | SPY | ETF | 123.84 | 123.85 | 123.84 | 123.85 | 300.0 |
| 2005-11-11 19:00:00 | SPY | ETF | 123.81 | 123.81 | 123.81 | 123.81 | 900.0 |
| 2005-11-11 09:30:00 | QQQ | ETF | 40.77 | 40.89 | 40.76 | 40.88 | 14269600.0 |
| 2005-11-11 10:00:00 | QQQ | ETF | 40.88 | 40.88 | 40.78 | 40.8 | 7546200.0 |
| 2005-11-11 10:30:00 | QQQ | ETF | 40.8 | 40.85 | 40.78 | 40.84 | 2550900.0 |
| 2005-11-11 11:00:00 | QQQ | ETF | 40.84 | 40.92 | 40.81 | 40.84 | 6420200.0 |
| 2005-11-11 11:30:00 | QQQ | ETF | 40.84 | 40.84 | 40.77 | 40.77 | 2270100.0 |
| 2005-11-11 12:00:00 | QQQ | ETF | 40.77 | 40.79 | 40.72 | 40.77 | 5627100.0 |
| 2005-11-11 12:30:00 | QQQ | ETF | 40.78 | 40.8 | 40.75 | 40.76 | 2141600.0 |
| 2005-11-11 13:00:00 | QQQ | ETF | 40.75 | 40.76 | 40.68 | 40.72 | 5092500.0 |
| 2005-11-11 13:30:00 | QQQ | ETF | 40.72 | 40.77 | 40.72 | 40.75 | 1585200.0 |
| 2005-11-11 14:00:00 | QQQ | ETF | 40.76 | 40.81 | 40.71 | 40.74 | 3815700.0 |
| 2005-11-11 14:30:00 | QQQ | ETF | 40.74 | 40.81 | 40.71 | 40.71 | 4368700.0 |
| 2005-11-11 15:00:00 | QQQ | ETF | 40.71 | 40.74 | 40.68 | 40.71 | 5335200.0 |
| 2005-11-11 15:30:00 | QQQ | ETF | 40.71 | 40.77 | 40.68 | 40.71 | 7825400.0 |
| 2005-11-11 07:30:00 | IWM | ETF | 66.1 | 66.1 | 66.1 | 66.1 | 3000.0 |
| 2005-11-11 08:00:00 | IWM | ETF | 66.11 | 66.12 | 66.11 | 66.12 | 13700.0 |
| 2005-11-11 08:30:00 | IWM | ETF | 66.14 | 66.14 | 66.14 | 66.14 | 1300.0 |
| 2005-11-11 09:00:00 | IWM | ETF | 66.14 | 66.16 | 66.08 | 66.1 | 36900.0 |
| 2005-11-11 09:30:00 | IWM | ETF | 66.05 | 66.4 | 66.05 | 66.21 | 2829700.0 |
| 2005-11-11 10:00:00 | IWM | ETF | 66.21 | 66.22 | 65.95 | 66.18 | 3519500.0 |
| 2005-11-11 10:30:00 | IWM | ETF | 66.17 | 66.25 | 66.12 | 66.19 | 1271400.0 |
| 2005-11-11 11:00:00 | IWM | ETF | 66.21 | 66.34 | 66.16 | 66.29 | 1700900.0 |
| 2005-11-11 11:30:00 | IWM | ETF | 66.29 | 66.3 | 66.05 | 66.06 | 813400.0 |
| 2005-11-11 12:00:00 | IWM | ETF | 66.07 | 66.12 | 66.01 | 66.1 | 364500.0 |
| 2005-11-11 12:30:00 | IWM | ETF | 66.09 | 66.22 | 66.09 | 66.12 | 379700.0 |
| 2005-11-11 13:00:00 | IWM | ETF | 66.12 | 66.2 | 66.07 | 66.1 | 493500.0 |
| 2005-11-11 13:30:00 | IWM | ETF | 66.11 | 66.17 | 66.09 | 66.17 | 139100.0 |
| 2005-11-11 14:00:00 | IWM | ETF | 66.17 | 66.33 | 66.15 | 66.27 | 1239300.0 |
> showing 50 of 1,744 rows — these rows as CSV