PREVIEW / etf_30min / 2010-10-13
file: by_date/etf_30min/2010/2010-10-13.parquet size: 268 KB rows: 9,058
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-13 04:00:00 | SPY | ETF | 117.28 | 117.63 | 117.28 | 117.63 | 6239.0 |
| 2010-10-13 04:30:00 | SPY | ETF | 117.63 | 117.71 | 117.61 | 117.65 | 8120.0 |
| 2010-10-13 05:00:00 | SPY | ETF | 117.68 | 117.69 | 117.64 | 117.67 | 30700.0 |
| 2010-10-13 05:30:00 | SPY | ETF | 117.71 | 117.8 | 117.71 | 117.8 | 1000.0 |
| 2010-10-13 06:00:00 | SPY | ETF | 117.81 | 117.81 | 117.7 | 117.7 | 35940.0 |
| 2010-10-13 06:30:00 | SPY | ETF | 117.72 | 117.84 | 117.72 | 117.81 | 135700.0 |
| 2010-10-13 07:00:00 | SPY | ETF | 117.8 | 117.82 | 117.63 | 117.76 | 256620.0 |
| 2010-10-13 07:30:00 | SPY | ETF | 117.74 | 117.89 | 117.68 | 117.77 | 601980.0 |
| 2010-10-13 08:00:00 | SPY | ETF | 117.75 | 117.93 | 117.68 | 117.86 | 528498.0 |
| 2010-10-13 08:30:00 | SPY | ETF | 117.84 | 117.88 | 117.72 | 117.73 | 970235.0 |
| 2010-10-13 09:00:00 | SPY | ETF | 117.74 | 117.75 | 117.62 | 117.66 | 1349414.0 |
| 2010-10-13 09:30:00 | SPY | ETF | 117.66 | 117.83 | 117.38 | 117.74 | 24872607.0 |
| 2010-10-13 10:00:00 | SPY | ETF | 117.74 | 117.96 | 117.65 | 117.8 | 15780043.0 |
| 2010-10-13 10:30:00 | SPY | ETF | 117.8 | 118.08 | 117.745 | 118.08 | 10570749.0 |
| 2010-10-13 11:00:00 | SPY | ETF | 118.08 | 118.29 | 117.97 | 118.095 | 13380114.0 |
| 2010-10-13 11:30:00 | SPY | ETF | 118.09 | 118.17 | 118.0 | 118.1001 | 5781760.0 |
| 2010-10-13 12:00:00 | SPY | ETF | 118.11 | 118.36 | 118.1 | 118.33 | 7794892.0 |
| 2010-10-13 12:30:00 | SPY | ETF | 118.33 | 118.44 | 118.27 | 118.31 | 5042059.0 |
| 2010-10-13 13:00:00 | SPY | ETF | 118.3 | 118.38 | 118.21 | 118.27 | 6437915.0 |
| 2010-10-13 13:30:00 | SPY | ETF | 118.27 | 118.47 | 118.26 | 118.34 | 6527790.0 |
| 2010-10-13 14:00:00 | SPY | ETF | 118.35 | 118.55 | 118.31 | 118.34 | 8955848.0 |
| 2010-10-13 14:30:00 | SPY | ETF | 118.345 | 118.45 | 118.19 | 118.23 | 12718905.0 |
| 2010-10-13 15:00:00 | SPY | ETF | 118.22 | 118.35 | 117.96 | 118.0 | 18736511.0 |
| 2010-10-13 15:30:00 | SPY | ETF | 118.0 | 118.17 | 117.8 | 117.89 | 27032810.0 |
| 2010-10-13 16:00:00 | SPY | ETF | 117.89 | 118.4 | 117.515 | 117.94 | 6232706.0 |
| 2010-10-13 16:30:00 | SPY | ETF | 117.94 | 117.95 | 117.86 | 117.86 | 15348829.0 |
| 2010-10-13 17:00:00 | SPY | ETF | 117.87 | 117.9 | 117.86 | 117.87 | 195190.0 |
| 2010-10-13 17:30:00 | SPY | ETF | 117.86 | 117.9 | 117.86 | 117.9 | 39500.0 |
| 2010-10-13 18:00:00 | SPY | ETF | 117.89 | 117.89 | 117.85 | 117.87 | 188724.0 |
| 2010-10-13 18:30:00 | SPY | ETF | 117.87 | 117.87 | 117.84 | 117.84 | 86100.0 |
| 2010-10-13 19:00:00 | SPY | ETF | 117.85 | 117.89 | 117.84 | 117.89 | 58207.0 |
| 2010-10-13 19:30:00 | SPY | ETF | 117.89 | 117.95 | 117.88 | 117.92 | 125966.0 |
| 2010-10-13 04:00:00 | QQQ | ETF | 50.23 | 50.41 | 50.23 | 50.4 | 9779.0 |
| 2010-10-13 04:30:00 | QQQ | ETF | 50.38 | 50.38 | 50.38 | 50.38 | 500.0 |
| 2010-10-13 05:00:00 | QQQ | ETF | 50.44 | 50.44 | 50.44 | 50.44 | 2700.0 |
| 2010-10-13 05:30:00 | QQQ | ETF | 50.5 | 50.5 | 50.5 | 50.5 | 370.0 |
| 2010-10-13 06:00:00 | QQQ | ETF | 50.48 | 50.48 | 50.48 | 50.48 | 10000.0 |
| 2010-10-13 06:30:00 | QQQ | ETF | 50.47 | 50.48 | 50.45 | 50.47 | 25300.0 |
| 2010-10-13 07:00:00 | QQQ | ETF | 50.47 | 50.48 | 50.39 | 50.44 | 169312.0 |
| 2010-10-13 07:30:00 | QQQ | ETF | 50.45 | 50.51 | 50.41 | 50.46 | 159789.0 |
| 2010-10-13 08:00:00 | QQQ | ETF | 50.48 | 50.51 | 50.42 | 50.46 | 317690.0 |
| 2010-10-13 08:30:00 | QQQ | ETF | 50.47 | 50.47 | 50.42 | 50.43 | 425533.0 |
| 2010-10-13 09:00:00 | QQQ | ETF | 50.43 | 50.44 | 50.38 | 50.41 | 573263.0 |
| 2010-10-13 09:30:00 | QQQ | ETF | 50.4 | 50.47 | 50.28 | 50.365 | 11823236.0 |
| 2010-10-13 10:00:00 | QQQ | ETF | 50.37 | 50.5 | 50.37 | 50.445 | 5991748.0 |
| 2010-10-13 10:30:00 | QQQ | ETF | 50.44 | 50.59 | 50.42 | 50.585 | 5762397.0 |
| 2010-10-13 11:00:00 | QQQ | ETF | 50.59 | 50.65 | 50.55 | 50.565 | 4339535.0 |
| 2010-10-13 11:30:00 | QQQ | ETF | 50.57 | 50.63 | 50.54 | 50.59 | 1781546.0 |
| 2010-10-13 12:00:00 | QQQ | ETF | 50.595 | 50.67 | 50.56 | 50.6504 | 2554153.0 |
| 2010-10-13 12:30:00 | QQQ | ETF | 50.66 | 50.68 | 50.6 | 50.62 | 2640184.0 |
> showing 50 of 9,058 rows — these rows as CSV