PREVIEW / etf_30min / 2024-07-09
file: by_date/etf_30min/2024/2024-07-09.parquet size: 830 KB rows: 32,642
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 |
|---|---|---|---|---|---|---|---|
| 2024-07-09 04:00:00 | SPY | ETF | 556.34 | 556.59 | 556.29 | 556.31 | 6113.0 |
| 2024-07-09 04:30:00 | SPY | ETF | 556.35 | 556.55 | 556.35 | 556.49 | 1275.0 |
| 2024-07-09 05:00:00 | SPY | ETF | 556.55 | 556.63 | 556.54 | 556.63 | 2580.0 |
| 2024-07-09 05:30:00 | SPY | ETF | 556.61 | 556.62 | 556.52 | 556.57 | 2103.0 |
| 2024-07-09 06:00:00 | SPY | ETF | 556.5 | 556.5 | 556.48 | 556.48 | 1443.0 |
| 2024-07-09 06:30:00 | SPY | ETF | 556.45 | 556.57 | 556.45 | 556.49 | 666.0 |
| 2024-07-09 07:00:00 | SPY | ETF | 556.46 | 556.57 | 556.23 | 556.34 | 49051.0 |
| 2024-07-09 07:30:00 | SPY | ETF | 556.32 | 556.36 | 556.21 | 556.25 | 18636.0 |
| 2024-07-09 08:00:00 | SPY | ETF | 556.5204 | 556.65 | 556.0 | 556.03 | 73638.0 |
| 2024-07-09 08:30:00 | SPY | ETF | 556.08 | 556.25 | 555.95 | 556.21 | 27606.0 |
| 2024-07-09 09:00:00 | SPY | ETF | 556.21 | 556.4 | 556.15 | 556.21 | 67507.0 |
| 2024-07-09 09:30:00 | SPY | ETF | 556.26 | 556.82 | 556.11 | 556.67 | 1971863.0 |
| 2024-07-09 10:00:00 | SPY | ETF | 556.69 | 556.8963 | 555.67 | 556.02 | 1617633.0 |
| 2024-07-09 10:30:00 | SPY | ETF | 556.01 | 556.91 | 555.76 | 556.35 | 1443793.0 |
| 2024-07-09 11:00:00 | SPY | ETF | 556.33 | 556.59 | 555.72 | 556.05 | 1234262.0 |
| 2024-07-09 11:30:00 | SPY | ETF | 556.05 | 556.53 | 555.84 | 556.525 | 944508.0 |
| 2024-07-09 12:00:00 | SPY | ETF | 556.52 | 556.8015 | 556.35 | 556.69 | 826843.0 |
| 2024-07-09 12:30:00 | SPY | ETF | 556.68 | 556.74 | 556.11 | 556.72 | 865268.0 |
| 2024-07-09 13:00:00 | SPY | ETF | 556.7 | 557.18 | 555.7301 | 556.0 | 2058603.0 |
| 2024-07-09 13:30:00 | SPY | ETF | 556.0 | 556.34 | 555.96 | 556.14 | 863894.0 |
| 2024-07-09 14:00:00 | SPY | ETF | 556.13 | 556.13 | 555.72 | 555.745 | 1199814.0 |
| 2024-07-09 14:30:00 | SPY | ETF | 555.75 | 556.18 | 555.61 | 555.895 | 1542878.0 |
| 2024-07-09 15:00:00 | SPY | ETF | 555.9 | 555.92 | 555.52 | 555.785 | 890623.0 |
| 2024-07-09 15:30:00 | SPY | ETF | 555.78 | 556.08 | 555.56 | 555.85 | 3292245.0 |
| 2024-07-09 16:00:00 | SPY | ETF | 555.85 | 556.01 | 555.7 | 555.91 | 976020.0 |
| 2024-07-09 16:30:00 | SPY | ETF | 555.93 | 555.96 | 555.82 | 555.86 | 92238.0 |
| 2024-07-09 17:00:00 | SPY | ETF | 555.83 | 555.85 | 555.79 | 555.79 | 13181.0 |
| 2024-07-09 17:30:00 | SPY | ETF | 555.78 | 555.8 | 555.6601 | 555.7 | 10719.0 |
| 2024-07-09 18:00:00 | SPY | ETF | 555.78 | 555.94 | 555.78 | 555.88 | 27865.0 |
| 2024-07-09 18:30:00 | SPY | ETF | 555.93 | 556.01 | 555.93 | 555.97 | 6391.0 |
| 2024-07-09 19:00:00 | SPY | ETF | 556.01 | 556.09 | 556.01 | 556.0488 | 6045.0 |
| 2024-07-09 19:30:00 | SPY | ETF | 556.07 | 556.07 | 556.01 | 556.01 | 1201.0 |
| 2024-07-09 04:00:00 | QQQ | ETF | 499.17 | 499.26 | 498.8 | 498.89 | 17096.0 |
| 2024-07-09 04:30:00 | QQQ | ETF | 498.95 | 499.17 | 498.93 | 499.1 | 4341.0 |
| 2024-07-09 05:00:00 | QQQ | ETF | 499.12 | 499.28 | 499.11 | 499.19 | 3988.0 |
| 2024-07-09 05:30:00 | QQQ | ETF | 499.25 | 499.37 | 499.25 | 499.29 | 4224.0 |
| 2024-07-09 06:00:00 | QQQ | ETF | 499.22 | 499.27 | 499.1 | 499.16 | 10203.0 |
| 2024-07-09 06:30:00 | QQQ | ETF | 499.3 | 499.34 | 499.17 | 499.25 | 6859.0 |
| 2024-07-09 07:00:00 | QQQ | ETF | 499.28 | 499.4 | 498.93 | 499.06 | 27996.0 |
| 2024-07-09 07:30:00 | QQQ | ETF | 499.04 | 499.07 | 498.76 | 498.91 | 24811.0 |
| 2024-07-09 08:00:00 | QQQ | ETF | 499.39 | 499.4 | 498.55 | 498.64 | 87379.0 |
| 2024-07-09 08:30:00 | QQQ | ETF | 498.61 | 498.86 | 498.41 | 498.8 | 60784.0 |
| 2024-07-09 09:00:00 | QQQ | ETF | 498.82 | 498.99 | 498.71 | 498.84 | 99608.0 |
| 2024-07-09 09:30:00 | QQQ | ETF | 498.87 | 499.835 | 498.76 | 499.5063 | 2063123.0 |
| 2024-07-09 10:00:00 | QQQ | ETF | 499.52 | 500.0 | 498.13 | 498.38 | 2265068.0 |
| 2024-07-09 10:30:00 | QQQ | ETF | 498.36 | 499.26 | 497.8 | 498.48 | 1945139.0 |
| 2024-07-09 11:00:00 | QQQ | ETF | 498.48 | 498.92 | 497.56 | 497.99 | 1236302.0 |
| 2024-07-09 11:30:00 | QQQ | ETF | 497.9899 | 498.45 | 497.63 | 498.4075 | 780305.0 |
| 2024-07-09 12:00:00 | QQQ | ETF | 498.4 | 498.69 | 498.01 | 498.26 | 770474.0 |
| 2024-07-09 12:30:00 | QQQ | ETF | 498.26 | 498.37 | 496.9101 | 497.716 | 1392091.0 |
> showing 50 of 32,642 rows — these rows as CSV