PREVIEW / etf_30min / 2004-08-25
file: by_date/etf_30min/2004/2004-08-25.parquet size: 36 KB rows: 1,151
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-08-25 08:00:00 | SPY | ETF | 110.48 | 110.53 | 110.46 | 110.53 | 23600.0 |
| 2004-08-25 08:30:00 | SPY | ETF | 110.5 | 110.55 | 110.41 | 110.41 | 128200.0 |
| 2004-08-25 09:00:00 | SPY | ETF | 110.38 | 110.4 | 110.28 | 110.34 | 31400.0 |
| 2004-08-25 09:30:00 | SPY | ETF | 110.33 | 110.34 | 110.1 | 110.21 | 2952800.0 |
| 2004-08-25 10:00:00 | SPY | ETF | 110.21 | 110.22 | 109.9 | 110.13 | 2889000.0 |
| 2004-08-25 10:30:00 | SPY | ETF | 110.13 | 110.3 | 110.03 | 110.15 | 2017500.0 |
| 2004-08-25 11:00:00 | SPY | ETF | 110.15 | 110.29 | 110.06 | 110.13 | 1427700.0 |
| 2004-08-25 11:30:00 | SPY | ETF | 110.13 | 110.27 | 110.13 | 110.2 | 543200.0 |
| 2004-08-25 12:00:00 | SPY | ETF | 110.19 | 110.59 | 110.19 | 110.54 | 2789900.0 |
| 2004-08-25 12:30:00 | SPY | ETF | 110.52 | 110.8 | 110.52 | 110.68 | 2549200.0 |
| 2004-08-25 13:00:00 | SPY | ETF | 110.68 | 110.96 | 110.67 | 110.91 | 3671200.0 |
| 2004-08-25 13:30:00 | SPY | ETF | 110.92 | 110.93 | 110.74 | 110.84 | 1509100.0 |
| 2004-08-25 14:00:00 | SPY | ETF | 110.84 | 111.17 | 110.82 | 111.13 | 3977600.0 |
| 2004-08-25 14:30:00 | SPY | ETF | 111.1 | 111.25 | 111.05 | 111.15 | 2146200.0 |
| 2004-08-25 15:00:00 | SPY | ETF | 111.15 | 111.22 | 111.04 | 111.13 | 2724900.0 |
| 2004-08-25 15:30:00 | SPY | ETF | 111.13 | 111.27 | 111.02 | 111.12 | 3196600.0 |
| 2004-08-25 16:00:00 | SPY | ETF | 111.13 | 111.17 | 110.99 | 111.01 | 960800.0 |
| 2004-08-25 16:30:00 | SPY | ETF | 111.02 | 111.03 | 110.99 | 111.03 | 247000.0 |
| 2004-08-25 17:00:00 | SPY | ETF | 111.05 | 111.06 | 111.01 | 111.03 | 83800.0 |
| 2004-08-25 17:30:00 | SPY | ETF | 111.05 | 111.05 | 111.01 | 111.05 | 2200.0 |
| 2004-08-25 18:00:00 | SPY | ETF | 111.05 | 111.08 | 111.05 | 111.06 | 2400.0 |
| 2004-08-25 18:30:00 | SPY | ETF | 111.08 | 111.08 | 111.04 | 111.04 | 5800.0 |
| 2004-08-25 08:00:00 | QQQ | ETF | 34.13 | 34.17 | 34.13 | 34.15 | 8000.0 |
| 2004-08-25 08:30:00 | QQQ | ETF | 34.16 | 34.17 | 34.08 | 34.09 | 144900.0 |
| 2004-08-25 09:00:00 | QQQ | ETF | 34.08 | 34.09 | 34.04 | 34.07 | 145700.0 |
| 2004-08-25 09:30:00 | QQQ | ETF | 34.075 | 34.08 | 33.973 | 34.0 | 9103200.0 |
| 2004-08-25 10:00:00 | QQQ | ETF | 34.0 | 34.05 | 33.9 | 34.039 | 7713400.0 |
| 2004-08-25 10:30:00 | QQQ | ETF | 34.038 | 34.12 | 33.98 | 34.1 | 9262300.0 |
| 2004-08-25 11:00:00 | QQQ | ETF | 34.1 | 34.16 | 34.06 | 34.07 | 4720600.0 |
| 2004-08-25 11:30:00 | QQQ | ETF | 34.07 | 34.12 | 34.05 | 34.09 | 2069800.0 |
| 2004-08-25 12:00:00 | QQQ | ETF | 34.09 | 34.289 | 34.086 | 34.25 | 7291000.0 |
| 2004-08-25 12:30:00 | QQQ | ETF | 34.252 | 34.383 | 34.25 | 34.36 | 8260600.0 |
| 2004-08-25 13:00:00 | QQQ | ETF | 34.36 | 34.47 | 34.348 | 34.432 | 5503800.0 |
| 2004-08-25 13:30:00 | QQQ | ETF | 34.44 | 34.45 | 34.379 | 34.41 | 4170200.0 |
| 2004-08-25 14:00:00 | QQQ | ETF | 34.411 | 34.54 | 34.4 | 34.52 | 7678300.0 |
| 2004-08-25 14:30:00 | QQQ | ETF | 34.52 | 34.59 | 34.48 | 34.56 | 5199700.0 |
| 2004-08-25 15:00:00 | QQQ | ETF | 34.552 | 34.58 | 34.51 | 34.555 | 4481900.0 |
| 2004-08-25 15:30:00 | QQQ | ETF | 34.556 | 34.6 | 34.49 | 34.54 | 8732000.0 |
| 2004-08-25 16:00:00 | QQQ | ETF | 34.547 | 34.57 | 34.52 | 34.53 | 2782300.0 |
| 2004-08-25 16:30:00 | QQQ | ETF | 34.53 | 34.536 | 34.51 | 34.52 | 134800.0 |
| 2004-08-25 17:00:00 | QQQ | ETF | 34.524 | 34.53 | 34.5 | 34.5 | 72300.0 |
| 2004-08-25 17:30:00 | QQQ | ETF | 34.52 | 34.53 | 34.51 | 34.53 | 5100.0 |
| 2004-08-25 18:00:00 | QQQ | ETF | 34.52 | 34.53 | 34.51 | 34.53 | 19500.0 |
| 2004-08-25 18:30:00 | QQQ | ETF | 34.53 | 34.54 | 34.52 | 34.52 | 4000.0 |
| 2004-08-25 19:00:00 | QQQ | ETF | 34.53 | 34.53 | 34.51 | 34.53 | 20900.0 |
| 2004-08-25 19:30:00 | QQQ | ETF | 34.52 | 34.52 | 34.51 | 34.52 | 5800.0 |
| 2004-08-25 08:00:00 | IWM | ETF | 54.56 | 54.56 | 54.56 | 54.56 | 3600.0 |
| 2004-08-25 08:30:00 | IWM | ETF | 54.54 | 54.54 | 54.54 | 54.54 | 200.0 |
| 2004-08-25 09:30:00 | IWM | ETF | 54.43 | 54.43 | 54.19 | 54.25 | 1336600.0 |
| 2004-08-25 10:00:00 | IWM | ETF | 54.24 | 54.285 | 54.0 | 54.225 | 836800.0 |
> showing 50 of 1,151 rows — these rows as CSV