PREVIEW / etf_30min / 2004-05-24
file: by_date/etf_30min/2004/2004-05-24.parquet size: 35 KB rows: 1,149
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-05-24 08:00:00 | SPY | ETF | 110.47 | 110.5 | 110.44 | 110.49 | 49400.0 |
| 2004-05-24 08:30:00 | SPY | ETF | 110.47 | 110.56 | 110.44 | 110.45 | 78900.0 |
| 2004-05-24 09:00:00 | SPY | ETF | 110.49 | 110.5 | 110.43 | 110.46 | 56200.0 |
| 2004-05-24 09:30:00 | SPY | ETF | 110.53 | 110.76 | 110.34 | 110.57 | 4664200.0 |
| 2004-05-24 10:00:00 | SPY | ETF | 110.55 | 110.64 | 110.1 | 110.25 | 5715000.0 |
| 2004-05-24 10:30:00 | SPY | ETF | 110.25 | 110.47 | 110.18 | 110.42 | 2613800.0 |
| 2004-05-24 11:00:00 | SPY | ETF | 110.42 | 110.45 | 109.94 | 110.01 | 4729400.0 |
| 2004-05-24 11:30:00 | SPY | ETF | 110.05 | 110.07 | 109.74 | 109.92 | 3685500.0 |
| 2004-05-24 12:00:00 | SPY | ETF | 109.93 | 110.03 | 109.73 | 109.85 | 3563000.0 |
| 2004-05-24 12:30:00 | SPY | ETF | 109.85 | 109.9 | 109.68 | 109.73 | 1209600.0 |
| 2004-05-24 13:00:00 | SPY | ETF | 109.75 | 110.0 | 109.73 | 109.95 | 1406900.0 |
| 2004-05-24 13:30:00 | SPY | ETF | 109.95 | 110.275 | 109.92 | 110.09 | 2466500.0 |
| 2004-05-24 14:00:00 | SPY | ETF | 110.08 | 110.17 | 109.85 | 109.95 | 1250600.0 |
| 2004-05-24 14:30:00 | SPY | ETF | 109.95 | 110.03 | 109.78 | 109.97 | 1215600.0 |
| 2004-05-24 15:00:00 | SPY | ETF | 109.98 | 110.22 | 109.92 | 110.1 | 1842000.0 |
| 2004-05-24 15:30:00 | SPY | ETF | 110.12 | 110.31 | 110.0 | 110.09 | 2614600.0 |
| 2004-05-24 16:00:00 | SPY | ETF | 110.08 | 110.3 | 109.02 | 110.19 | 1477800.0 |
| 2004-05-24 16:30:00 | SPY | ETF | 110.2 | 110.49 | 110.18 | 110.36 | 306800.0 |
| 2004-05-24 17:00:00 | SPY | ETF | 110.34 | 110.34 | 110.26 | 110.3 | 33600.0 |
| 2004-05-24 17:30:00 | SPY | ETF | 110.3 | 110.35 | 110.28 | 110.28 | 3700.0 |
| 2004-05-24 18:00:00 | SPY | ETF | 110.27 | 110.27 | 110.26 | 110.26 | 1000.0 |
| 2004-05-24 19:30:00 | SPY | ETF | 110.25 | 110.25 | 110.25 | 110.25 | 400.0 |
| 2004-05-24 08:00:00 | QQQ | ETF | 35.26 | 35.3 | 35.25 | 35.27 | 419700.0 |
| 2004-05-24 08:30:00 | QQQ | ETF | 35.27 | 35.34 | 35.27 | 35.32 | 157000.0 |
| 2004-05-24 09:00:00 | QQQ | ETF | 35.32 | 35.35 | 35.29 | 35.29 | 159500.0 |
| 2004-05-24 09:30:00 | QQQ | ETF | 35.3 | 35.46 | 35.26 | 35.38 | 17075400.0 |
| 2004-05-24 10:00:00 | QQQ | ETF | 35.37 | 35.43 | 35.229 | 35.321 | 11932000.0 |
| 2004-05-24 10:30:00 | QQQ | ETF | 35.321 | 35.406 | 35.28 | 35.372 | 6344200.0 |
| 2004-05-24 11:00:00 | QQQ | ETF | 35.387 | 35.4 | 35.13 | 35.17 | 8697400.0 |
| 2004-05-24 11:30:00 | QQQ | ETF | 35.17 | 35.18 | 35.0 | 35.06 | 8701300.0 |
| 2004-05-24 12:00:00 | QQQ | ETF | 35.06 | 35.14 | 35.03 | 35.09 | 3656700.0 |
| 2004-05-24 12:30:00 | QQQ | ETF | 35.09 | 35.15 | 35.059 | 35.07 | 3367000.0 |
| 2004-05-24 13:00:00 | QQQ | ETF | 35.08 | 35.19 | 35.07 | 35.132 | 3725400.0 |
| 2004-05-24 13:30:00 | QQQ | ETF | 35.13 | 35.29 | 35.13 | 35.19 | 6133100.0 |
| 2004-05-24 14:00:00 | QQQ | ETF | 35.2 | 35.202 | 35.059 | 35.12 | 5559600.0 |
| 2004-05-24 14:30:00 | QQQ | ETF | 35.15 | 35.17 | 35.07 | 35.12 | 3028900.0 |
| 2004-05-24 15:00:00 | QQQ | ETF | 35.12 | 35.22 | 35.094 | 35.175 | 4709400.0 |
| 2004-05-24 15:30:00 | QQQ | ETF | 35.171 | 35.26 | 35.12 | 35.16 | 5721100.0 |
| 2004-05-24 16:00:00 | QQQ | ETF | 35.15 | 35.28 | 35.09 | 35.28 | 3618300.0 |
| 2004-05-24 16:30:00 | QQQ | ETF | 35.28 | 35.32 | 35.23 | 35.3 | 719700.0 |
| 2004-05-24 17:00:00 | QQQ | ETF | 35.3 | 35.3 | 35.263 | 35.28 | 458300.0 |
| 2004-05-24 17:30:00 | QQQ | ETF | 35.28 | 35.3 | 35.15 | 35.25 | 200300.0 |
| 2004-05-24 18:00:00 | QQQ | ETF | 35.25 | 35.27 | 35.2 | 35.25 | 61800.0 |
| 2004-05-24 18:30:00 | QQQ | ETF | 35.26 | 35.26 | 35.25 | 35.25 | 5200.0 |
| 2004-05-24 19:00:00 | QQQ | ETF | 35.25 | 35.25 | 35.22 | 35.25 | 2700.0 |
| 2004-05-24 19:30:00 | QQQ | ETF | 35.27 | 35.27 | 35.22 | 35.25 | 9800.0 |
| 2004-05-24 08:00:00 | IWM | ETF | 54.83 | 54.83 | 54.83 | 54.83 | 2000.0 |
| 2004-05-24 08:30:00 | IWM | ETF | 54.88 | 54.88 | 54.82 | 54.82 | 1600.0 |
| 2004-05-24 09:00:00 | IWM | ETF | 54.83 | 54.85 | 54.77 | 54.79 | 23400.0 |
| 2004-05-24 09:30:00 | IWM | ETF | 54.89 | 55.21 | 54.785 | 55.13 | 2444200.0 |
> showing 50 of 1,149 rows — these rows as CSV