PREVIEW / etf_30min / 2004-06-01
file: by_date/etf_30min/2004/2004-06-01.parquet size: 34 KB rows: 1,157
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-06-01 08:00:00 | SPY | ETF | 112.29 | 112.36 | 112.22 | 112.34 | 47500.0 |
| 2004-06-01 08:30:00 | SPY | ETF | 112.34 | 112.36 | 112.27 | 112.35 | 22000.0 |
| 2004-06-01 09:00:00 | SPY | ETF | 112.35 | 112.49 | 112.35 | 112.49 | 35500.0 |
| 2004-06-01 09:30:00 | SPY | ETF | 112.46 | 112.73 | 112.36 | 112.68 | 3189500.0 |
| 2004-06-01 10:00:00 | SPY | ETF | 112.65 | 112.86 | 112.36 | 112.43 | 6164200.0 |
| 2004-06-01 10:30:00 | SPY | ETF | 112.43 | 112.59 | 112.36 | 112.54 | 1992900.0 |
| 2004-06-01 11:00:00 | SPY | ETF | 112.55 | 112.59 | 112.09 | 112.14 | 2716000.0 |
| 2004-06-01 11:30:00 | SPY | ETF | 112.14 | 112.4 | 112.08 | 112.28 | 3287600.0 |
| 2004-06-01 12:00:00 | SPY | ETF | 112.28 | 112.34 | 112.14 | 112.25 | 1426100.0 |
| 2004-06-01 12:30:00 | SPY | ETF | 112.22 | 112.45 | 112.22 | 112.33 | 704400.0 |
| 2004-06-01 13:00:00 | SPY | ETF | 112.33 | 112.43 | 112.3 | 112.37 | 820600.0 |
| 2004-06-01 13:30:00 | SPY | ETF | 112.36 | 112.42 | 112.16 | 112.21 | 847900.0 |
| 2004-06-01 14:00:00 | SPY | ETF | 112.22 | 112.33 | 111.93 | 111.95 | 4209700.0 |
| 2004-06-01 14:30:00 | SPY | ETF | 111.93 | 112.18 | 111.87 | 112.16 | 3771500.0 |
| 2004-06-01 15:00:00 | SPY | ETF | 112.17 | 112.36 | 112.06 | 112.34 | 2549200.0 |
| 2004-06-01 15:30:00 | SPY | ETF | 112.34 | 112.79 | 112.31 | 112.69 | 4144100.0 |
| 2004-06-01 16:00:00 | SPY | ETF | 112.68 | 112.81 | 112.26 | 112.69 | 2868100.0 |
| 2004-06-01 16:30:00 | SPY | ETF | 112.69 | 112.75 | 112.69 | 112.73 | 348800.0 |
| 2004-06-01 17:00:00 | SPY | ETF | 112.73 | 112.73 | 112.71 | 112.71 | 5900.0 |
| 2004-06-01 17:30:00 | SPY | ETF | 112.66 | 112.72 | 112.66 | 112.7 | 9100.0 |
| 2004-06-01 18:00:00 | SPY | ETF | 112.7 | 112.8 | 112.7 | 112.76 | 3700.0 |
| 2004-06-01 18:30:00 | SPY | ETF | 112.78 | 112.78 | 112.69 | 112.69 | 1800.0 |
| 2004-06-01 19:30:00 | SPY | ETF | 112.73 | 112.75 | 112.68 | 112.68 | 5700.0 |
| 2004-06-01 08:00:00 | QQQ | ETF | 36.5 | 36.5 | 36.24 | 36.25 | 101200.0 |
| 2004-06-01 08:30:00 | QQQ | ETF | 36.25 | 36.26 | 36.23 | 36.25 | 164900.0 |
| 2004-06-01 09:00:00 | QQQ | ETF | 36.24 | 36.27 | 36.23 | 36.26 | 72500.0 |
| 2004-06-01 09:30:00 | QQQ | ETF | 36.27 | 36.47 | 36.24 | 36.451 | 10613100.0 |
| 2004-06-01 10:00:00 | QQQ | ETF | 36.45 | 36.53 | 36.3 | 36.328 | 12883800.0 |
| 2004-06-01 10:30:00 | QQQ | ETF | 36.329 | 36.427 | 36.28 | 36.358 | 6214700.0 |
| 2004-06-01 11:00:00 | QQQ | ETF | 36.358 | 36.4 | 36.15 | 36.16 | 8257300.0 |
| 2004-06-01 11:30:00 | QQQ | ETF | 36.17 | 36.26 | 36.12 | 36.23 | 6741400.0 |
| 2004-06-01 12:00:00 | QQQ | ETF | 36.23 | 36.31 | 36.18 | 36.25 | 4157800.0 |
| 2004-06-01 12:30:00 | QQQ | ETF | 36.255 | 36.34 | 36.24 | 36.29 | 2969400.0 |
| 2004-06-01 13:00:00 | QQQ | ETF | 36.3 | 36.34 | 36.28 | 36.29 | 2517100.0 |
| 2004-06-01 13:30:00 | QQQ | ETF | 36.29 | 36.33 | 36.18 | 36.24 | 2482500.0 |
| 2004-06-01 14:00:00 | QQQ | ETF | 36.24 | 36.29 | 36.16 | 36.17 | 3524600.0 |
| 2004-06-01 14:30:00 | QQQ | ETF | 36.16 | 36.25 | 36.11 | 36.24 | 5101900.0 |
| 2004-06-01 15:00:00 | QQQ | ETF | 36.25 | 36.38 | 36.21 | 36.35 | 7155000.0 |
| 2004-06-01 15:30:00 | QQQ | ETF | 36.35 | 36.54 | 36.34 | 36.52 | 13523000.0 |
| 2004-06-01 16:00:00 | QQQ | ETF | 36.52 | 36.55 | 36.482 | 36.49 | 2175100.0 |
| 2004-06-01 16:30:00 | QQQ | ETF | 36.49 | 36.51 | 36.48 | 36.5 | 67700.0 |
| 2004-06-01 17:00:00 | QQQ | ETF | 36.5 | 36.5 | 36.47 | 36.48 | 44600.0 |
| 2004-06-01 17:30:00 | QQQ | ETF | 36.48 | 36.5 | 36.48 | 36.5 | 9700.0 |
| 2004-06-01 18:00:00 | QQQ | ETF | 36.49 | 36.49 | 36.47 | 36.48 | 41800.0 |
| 2004-06-01 18:30:00 | QQQ | ETF | 36.48 | 36.48 | 36.45 | 36.46 | 24400.0 |
| 2004-06-01 19:00:00 | QQQ | ETF | 36.46 | 36.48 | 36.43 | 36.48 | 29000.0 |
| 2004-06-01 19:30:00 | QQQ | ETF | 36.48 | 36.5 | 36.47 | 36.49 | 7700.0 |
| 2004-06-01 08:30:00 | IWM | ETF | 56.32 | 56.37 | 56.32 | 56.37 | 1200.0 |
| 2004-06-01 09:00:00 | IWM | ETF | 56.37 | 56.42 | 56.36 | 56.42 | 55400.0 |
| 2004-06-01 09:30:00 | IWM | ETF | 56.5 | 56.83 | 56.5 | 56.82 | 1246400.0 |
> showing 50 of 1,157 rows — these rows as CSV