PREVIEW / etf_30min / 2004-02-05
file: by_date/etf_30min/2004/2004-02-05.parquet size: 35 KB rows: 1,185
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-02-05 08:00:00 | SPY | ETF | 113.22 | 113.27 | 113.18 | 113.18 | 132300.0 |
| 2004-02-05 08:30:00 | SPY | ETF | 113.08 | 113.24 | 113.06 | 113.24 | 120700.0 |
| 2004-02-05 09:00:00 | SPY | ETF | 113.15 | 113.2 | 113.14 | 113.14 | 26900.0 |
| 2004-02-05 09:30:00 | SPY | ETF | 113.17 | 113.33 | 112.97 | 113.05 | 4327500.0 |
| 2004-02-05 10:00:00 | SPY | ETF | 113.07 | 113.26 | 112.93 | 112.99 | 2090200.0 |
| 2004-02-05 10:30:00 | SPY | ETF | 113.0 | 113.25 | 112.95 | 112.97 | 1952500.0 |
| 2004-02-05 11:00:00 | SPY | ETF | 112.98 | 113.06 | 112.78 | 112.92 | 3610500.0 |
| 2004-02-05 11:30:00 | SPY | ETF | 112.92 | 113.08 | 112.87 | 112.96 | 994200.0 |
| 2004-02-05 12:00:00 | SPY | ETF | 112.96 | 113.02 | 112.84 | 112.9 | 640700.0 |
| 2004-02-05 12:30:00 | SPY | ETF | 112.9 | 113.07 | 112.9 | 113.07 | 685800.0 |
| 2004-02-05 13:00:00 | SPY | ETF | 113.06 | 113.47 | 112.99 | 113.35 | 3737200.0 |
| 2004-02-05 13:30:00 | SPY | ETF | 113.36 | 113.54 | 113.28 | 113.32 | 3284700.0 |
| 2004-02-05 14:00:00 | SPY | ETF | 113.32 | 113.49 | 113.27 | 113.31 | 1578200.0 |
| 2004-02-05 14:30:00 | SPY | ETF | 113.31 | 113.42 | 112.98 | 113.02 | 2465000.0 |
| 2004-02-05 15:00:00 | SPY | ETF | 113.02 | 113.45 | 113.0 | 113.44 | 3294300.0 |
| 2004-02-05 15:30:00 | SPY | ETF | 113.41 | 113.47 | 113.13 | 113.3 | 2641000.0 |
| 2004-02-05 16:00:00 | SPY | ETF | 113.3 | 113.35 | 113.14 | 113.18 | 1812100.0 |
| 2004-02-05 16:30:00 | SPY | ETF | 113.18 | 113.19 | 113.13 | 113.16 | 40500.0 |
| 2004-02-05 17:00:00 | SPY | ETF | 113.16 | 113.17 | 113.1 | 113.17 | 35600.0 |
| 2004-02-05 17:30:00 | SPY | ETF | 113.13 | 113.17 | 113.12 | 113.12 | 1900.0 |
| 2004-02-05 18:00:00 | SPY | ETF | 113.1 | 113.17 | 113.1 | 113.17 | 6500.0 |
| 2004-02-05 19:00:00 | SPY | ETF | 113.14 | 113.14 | 113.14 | 113.14 | 200.0 |
| 2004-02-05 19:30:00 | SPY | ETF | 113.11 | 113.11 | 113.1 | 113.1 | 7200.0 |
| 2004-02-05 08:00:00 | QQQ | ETF | 36.55 | 36.56 | 36.52 | 36.54 | 131500.0 |
| 2004-02-05 08:30:00 | QQQ | ETF | 36.52 | 36.55 | 36.48 | 36.5 | 179900.0 |
| 2004-02-05 09:00:00 | QQQ | ETF | 36.5 | 36.52 | 36.49 | 36.5 | 163500.0 |
| 2004-02-05 09:30:00 | QQQ | ETF | 36.51 | 36.63 | 36.47 | 36.54 | 12494200.0 |
| 2004-02-05 10:00:00 | QQQ | ETF | 36.53 | 36.64 | 36.46 | 36.48 | 8025000.0 |
| 2004-02-05 10:30:00 | QQQ | ETF | 36.474 | 36.592 | 36.412 | 36.42 | 5750700.0 |
| 2004-02-05 11:00:00 | QQQ | ETF | 36.43 | 36.47 | 36.33 | 36.43 | 10428700.0 |
| 2004-02-05 11:30:00 | QQQ | ETF | 36.44 | 36.49 | 36.4 | 36.42 | 3653500.0 |
| 2004-02-05 12:00:00 | QQQ | ETF | 36.43 | 36.46 | 36.38 | 36.429 | 1933500.0 |
| 2004-02-05 12:30:00 | QQQ | ETF | 36.42 | 36.53 | 36.42 | 36.5 | 4122800.0 |
| 2004-02-05 13:00:00 | QQQ | ETF | 36.509 | 36.69 | 36.49 | 36.62 | 7001400.0 |
| 2004-02-05 13:30:00 | QQQ | ETF | 36.621 | 36.69 | 36.53 | 36.554 | 5470900.0 |
| 2004-02-05 14:00:00 | QQQ | ETF | 36.55 | 36.66 | 36.53 | 36.59 | 3743600.0 |
| 2004-02-05 14:30:00 | QQQ | ETF | 36.59 | 36.63 | 36.45 | 36.49 | 4135700.0 |
| 2004-02-05 15:00:00 | QQQ | ETF | 36.49 | 36.62 | 36.46 | 36.6 | 3900900.0 |
| 2004-02-05 15:30:00 | QQQ | ETF | 36.609 | 36.63 | 36.46 | 36.484 | 5789700.0 |
| 2004-02-05 16:00:00 | QQQ | ETF | 36.5 | 36.51 | 36.44 | 36.48 | 2450500.0 |
| 2004-02-05 16:30:00 | QQQ | ETF | 36.471 | 36.49 | 36.43 | 36.49 | 829600.0 |
| 2004-02-05 17:00:00 | QQQ | ETF | 36.47 | 36.48 | 36.44 | 36.451 | 153300.0 |
| 2004-02-05 17:30:00 | QQQ | ETF | 36.47 | 36.48 | 36.44 | 36.47 | 61900.0 |
| 2004-02-05 18:00:00 | QQQ | ETF | 36.47 | 36.48 | 36.46 | 36.47 | 43000.0 |
| 2004-02-05 18:30:00 | QQQ | ETF | 36.48 | 36.49 | 36.48 | 36.48 | 21800.0 |
| 2004-02-05 19:00:00 | QQQ | ETF | 36.48 | 36.49 | 36.48 | 36.49 | 2800.0 |
| 2004-02-05 19:30:00 | QQQ | ETF | 36.48 | 36.48 | 36.46 | 36.46 | 8900.0 |
| 2004-02-05 09:30:00 | IWM | ETF | 56.5675 | 56.785 | 56.495 | 56.58 | 1471200.0 |
| 2004-02-05 10:00:00 | IWM | ETF | 56.595 | 56.856 | 56.55 | 56.65 | 1060400.0 |
| 2004-02-05 10:30:00 | IWM | ETF | 56.65 | 56.875 | 56.61 | 56.61 | 635200.0 |
> showing 50 of 1,185 rows — these rows as CSV