PREVIEW / etf_30min / 2004-09-14
file: by_date/etf_30min/2004/2004-09-14.parquet size: 34 KB rows: 1,147
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-14 08:00:00 | SPY | ETF | 113.42 | 113.42 | 113.38 | 113.41 | 108200.0 |
| 2004-09-14 08:30:00 | SPY | ETF | 113.39 | 113.39 | 113.32 | 113.35 | 180600.0 |
| 2004-09-14 09:00:00 | SPY | ETF | 113.35 | 113.37 | 113.29 | 113.29 | 28600.0 |
| 2004-09-14 09:30:00 | SPY | ETF | 113.3 | 113.44 | 113.19 | 113.33 | 5193600.0 |
| 2004-09-14 10:00:00 | SPY | ETF | 113.33 | 113.37 | 113.19 | 113.36 | 2689800.0 |
| 2004-09-14 10:30:00 | SPY | ETF | 113.36 | 113.38 | 113.19 | 113.23 | 1378500.0 |
| 2004-09-14 11:00:00 | SPY | ETF | 113.23 | 113.38 | 113.21 | 113.27 | 857200.0 |
| 2004-09-14 11:30:00 | SPY | ETF | 113.27 | 113.38 | 113.22 | 113.35 | 1080800.0 |
| 2004-09-14 12:00:00 | SPY | ETF | 113.34 | 113.65 | 113.32 | 113.48 | 3124600.0 |
| 2004-09-14 12:30:00 | SPY | ETF | 113.53 | 113.64 | 113.46 | 113.62 | 741500.0 |
| 2004-09-14 13:00:00 | SPY | ETF | 113.62 | 113.69 | 113.39 | 113.47 | 1486000.0 |
| 2004-09-14 13:30:00 | SPY | ETF | 113.46 | 113.48 | 113.31 | 113.43 | 1168100.0 |
| 2004-09-14 14:00:00 | SPY | ETF | 113.42 | 113.55 | 113.37 | 113.53 | 1168400.0 |
| 2004-09-14 14:30:00 | SPY | ETF | 113.53 | 113.59 | 113.34 | 113.54 | 1043200.0 |
| 2004-09-14 15:00:00 | SPY | ETF | 113.54 | 113.68 | 113.5 | 113.66 | 2196000.0 |
| 2004-09-14 15:30:00 | SPY | ETF | 113.66 | 113.68 | 113.44 | 113.61 | 3122900.0 |
| 2004-09-14 16:00:00 | SPY | ETF | 113.61 | 113.69 | 113.55 | 113.65 | 1593400.0 |
| 2004-09-14 16:30:00 | SPY | ETF | 113.65 | 113.67 | 113.54 | 113.59 | 25600.0 |
| 2004-09-14 17:00:00 | SPY | ETF | 113.58 | 113.62 | 113.58 | 113.59 | 13900.0 |
| 2004-09-14 17:30:00 | SPY | ETF | 113.55 | 113.6 | 113.55 | 113.6 | 800.0 |
| 2004-09-14 18:00:00 | SPY | ETF | 113.58 | 113.58 | 113.57 | 113.57 | 1300.0 |
| 2004-09-14 18:30:00 | SPY | ETF | 113.55 | 113.55 | 113.49 | 113.55 | 4600.0 |
| 2004-09-14 19:30:00 | SPY | ETF | 113.56 | 113.57 | 113.56 | 113.56 | 500.0 |
| 2004-09-14 08:00:00 | QQQ | ETF | 35.47 | 35.55 | 35.4 | 35.52 | 28300.0 |
| 2004-09-14 08:30:00 | QQQ | ETF | 35.53 | 35.54 | 35.48 | 35.49 | 84500.0 |
| 2004-09-14 09:00:00 | QQQ | ETF | 35.49 | 35.49 | 35.42 | 35.45 | 283700.0 |
| 2004-09-14 09:30:00 | QQQ | ETF | 35.45 | 35.54 | 35.39 | 35.45 | 11081900.0 |
| 2004-09-14 10:00:00 | QQQ | ETF | 35.45 | 35.54 | 35.36 | 35.507 | 7274100.0 |
| 2004-09-14 10:30:00 | QQQ | ETF | 35.508 | 35.56 | 35.44 | 35.464 | 4628200.0 |
| 2004-09-14 11:00:00 | QQQ | ETF | 35.46 | 35.58 | 35.46 | 35.48 | 3563700.0 |
| 2004-09-14 11:30:00 | QQQ | ETF | 35.49 | 35.56 | 35.47 | 35.55 | 2923200.0 |
| 2004-09-14 12:00:00 | QQQ | ETF | 35.55 | 35.68 | 35.53 | 35.581 | 7556800.0 |
| 2004-09-14 12:30:00 | QQQ | ETF | 35.581 | 35.67 | 35.58 | 35.66 | 3898500.0 |
| 2004-09-14 13:00:00 | QQQ | ETF | 35.66 | 35.72 | 35.58 | 35.6 | 4745100.0 |
| 2004-09-14 13:30:00 | QQQ | ETF | 35.599 | 35.61 | 35.539 | 35.599 | 3104500.0 |
| 2004-09-14 14:00:00 | QQQ | ETF | 35.599 | 35.63 | 35.57 | 35.61 | 2897200.0 |
| 2004-09-14 14:30:00 | QQQ | ETF | 35.61 | 35.62 | 35.5 | 35.59 | 3952200.0 |
| 2004-09-14 15:00:00 | QQQ | ETF | 35.58 | 35.69 | 35.57 | 35.673 | 6114800.0 |
| 2004-09-14 15:30:00 | QQQ | ETF | 35.673 | 35.7 | 35.57 | 35.65 | 9073800.0 |
| 2004-09-14 16:00:00 | QQQ | ETF | 35.65 | 35.7 | 35.59 | 35.68 | 1202000.0 |
| 2004-09-14 16:30:00 | QQQ | ETF | 35.68 | 35.68 | 35.52 | 35.579 | 546200.0 |
| 2004-09-14 17:00:00 | QQQ | ETF | 35.58 | 35.6 | 35.55 | 35.55 | 121800.0 |
| 2004-09-14 17:30:00 | QQQ | ETF | 35.55 | 35.58 | 35.429 | 35.58 | 328900.0 |
| 2004-09-14 18:00:00 | QQQ | ETF | 35.57 | 35.57 | 35.526 | 35.56 | 45200.0 |
| 2004-09-14 18:30:00 | QQQ | ETF | 35.55 | 35.55 | 35.55 | 35.55 | 1200.0 |
| 2004-09-14 19:00:00 | QQQ | ETF | 35.55 | 35.55 | 35.54 | 35.54 | 2800.0 |
| 2004-09-14 19:30:00 | QQQ | ETF | 35.55 | 35.56 | 35.55 | 35.55 | 5300.0 |
| 2004-09-14 08:30:00 | IWM | ETF | 57.08 | 57.1 | 57.08 | 57.09 | 5800.0 |
| 2004-09-14 09:00:00 | IWM | ETF | 57.03 | 57.03 | 57.015 | 57.015 | 5000.0 |
| 2004-09-14 09:30:00 | IWM | ETF | 57.135 | 57.18 | 56.78 | 56.84 | 1758400.0 |
> showing 50 of 1,147 rows — these rows as CSV