PREVIEW / etf_30min / 2010-09-30
file: by_date/etf_30min/2010/2010-09-30.parquet size: 264 KB rows: 8,799
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-09-30 04:00:00 | SPY | ETF | 114.5 | 114.5 | 114.5 | 114.5 | 100.0 |
| 2010-09-30 05:30:00 | SPY | ETF | 114.47 | 114.47 | 114.39 | 114.4 | 3600.0 |
| 2010-09-30 06:00:00 | SPY | ETF | 114.46 | 114.53 | 114.44 | 114.46 | 5300.0 |
| 2010-09-30 06:30:00 | SPY | ETF | 114.52 | 114.52 | 114.25 | 114.33 | 12900.0 |
| 2010-09-30 07:00:00 | SPY | ETF | 114.29 | 114.34 | 114.26 | 114.31 | 79003.0 |
| 2010-09-30 07:30:00 | SPY | ETF | 114.33 | 114.36 | 114.29 | 114.29 | 87118.0 |
| 2010-09-30 08:00:00 | SPY | ETF | 114.31 | 114.43 | 114.22 | 114.22 | 432033.0 |
| 2010-09-30 08:30:00 | SPY | ETF | 114.32 | 114.94 | 114.31 | 114.87 | 2704207.0 |
| 2010-09-30 09:00:00 | SPY | ETF | 114.88 | 115.25 | 114.88 | 115.07 | 2542646.0 |
| 2010-09-30 09:30:00 | SPY | ETF | 115.05 | 115.79 | 115.04 | 115.385 | 44718048.0 |
| 2010-09-30 10:00:00 | SPY | ETF | 115.38 | 115.42 | 114.87 | 115.0601 | 26953436.0 |
| 2010-09-30 10:30:00 | SPY | ETF | 115.06 | 115.21 | 114.7 | 114.7075 | 16733232.0 |
| 2010-09-30 11:00:00 | SPY | ETF | 114.71 | 114.76 | 113.82 | 113.96 | 36262240.0 |
| 2010-09-30 11:30:00 | SPY | ETF | 113.96 | 114.22 | 113.79 | 114.01 | 21480657.0 |
| 2010-09-30 12:00:00 | SPY | ETF | 114.01 | 114.04 | 113.59 | 113.84 | 15865080.0 |
| 2010-09-30 12:30:00 | SPY | ETF | 113.84 | 114.35 | 113.79 | 114.3 | 15223938.0 |
| 2010-09-30 13:00:00 | SPY | ETF | 114.3 | 114.43 | 114.2 | 114.43 | 8526612.0 |
| 2010-09-30 13:30:00 | SPY | ETF | 114.43 | 114.44 | 114.18 | 114.33 | 7468252.0 |
| 2010-09-30 14:00:00 | SPY | ETF | 114.33 | 114.37 | 114.01 | 114.29 | 9201817.0 |
| 2010-09-30 14:30:00 | SPY | ETF | 114.28 | 114.64 | 114.245 | 114.46 | 10015837.0 |
| 2010-09-30 15:00:00 | SPY | ETF | 114.4601 | 114.53 | 114.15 | 114.51 | 14370018.0 |
| 2010-09-30 15:30:00 | SPY | ETF | 114.51 | 114.58 | 114.1 | 114.1 | 29879905.0 |
| 2010-09-30 16:00:00 | SPY | ETF | 114.1 | 115.425 | 113.665 | 114.03 | 20927224.0 |
| 2010-09-30 16:30:00 | SPY | ETF | 114.04 | 114.12 | 114.0 | 114.08 | 1627482.0 |
| 2010-09-30 17:00:00 | SPY | ETF | 114.07 | 114.1 | 114.02 | 114.08 | 123100.0 |
| 2010-09-30 17:30:00 | SPY | ETF | 114.4856 | 114.4856 | 114.08 | 114.12 | 1043649.0 |
| 2010-09-30 18:00:00 | SPY | ETF | 114.1 | 114.12 | 114.05 | 114.07 | 47966.0 |
| 2010-09-30 18:30:00 | SPY | ETF | 114.09 | 114.09 | 114.04 | 114.04 | 48464.0 |
| 2010-09-30 19:00:00 | SPY | ETF | 114.07 | 114.11 | 114.06 | 114.1 | 13975.0 |
| 2010-09-30 19:30:00 | SPY | ETF | 114.11 | 114.24 | 114.08 | 114.21 | 64203.0 |
| 2010-09-30 05:30:00 | QQQ | ETF | 49.37 | 49.37 | 49.36 | 49.37 | 14080.0 |
| 2010-09-30 06:30:00 | QQQ | ETF | 49.3 | 49.3 | 49.3 | 49.3 | 100.0 |
| 2010-09-30 07:00:00 | QQQ | ETF | 49.28 | 49.29 | 49.27 | 49.29 | 1600.0 |
| 2010-09-30 07:30:00 | QQQ | ETF | 49.27 | 49.32 | 49.26 | 49.29 | 161486.0 |
| 2010-09-30 08:00:00 | QQQ | ETF | 49.31 | 49.35 | 49.27 | 49.29 | 595460.0 |
| 2010-09-30 08:30:00 | QQQ | ETF | 49.29 | 49.55 | 49.27 | 49.53 | 4764565.0 |
| 2010-09-30 09:00:00 | QQQ | ETF | 49.53 | 49.7 | 49.52 | 49.56 | 616572.0 |
| 2010-09-30 09:30:00 | QQQ | ETF | 49.54 | 49.84 | 49.495 | 49.59 | 18074775.0 |
| 2010-09-30 10:00:00 | QQQ | ETF | 49.6 | 49.6 | 49.37 | 49.46 | 9861910.0 |
| 2010-09-30 10:30:00 | QQQ | ETF | 49.47 | 49.56 | 49.22 | 49.22 | 9690250.0 |
| 2010-09-30 11:00:00 | QQQ | ETF | 49.22 | 49.27 | 48.75 | 48.86 | 14190295.0 |
| 2010-09-30 11:30:00 | QQQ | ETF | 48.86 | 48.98 | 48.77 | 48.92 | 8691836.0 |
| 2010-09-30 12:00:00 | QQQ | ETF | 48.91 | 48.9299 | 48.75 | 48.83 | 4302657.0 |
| 2010-09-30 12:30:00 | QQQ | ETF | 48.83 | 49.13 | 48.825 | 49.07 | 6127637.0 |
| 2010-09-30 13:00:00 | QQQ | ETF | 49.0701 | 49.23 | 49.03 | 49.22 | 5984005.0 |
| 2010-09-30 13:30:00 | QQQ | ETF | 49.22 | 49.24 | 49.09 | 49.16 | 2798823.0 |
| 2010-09-30 14:00:00 | QQQ | ETF | 49.17 | 49.21 | 49.04 | 49.2 | 5717308.0 |
| 2010-09-30 14:30:00 | QQQ | ETF | 49.2 | 49.4 | 49.18 | 49.3001 | 3444728.0 |
| 2010-09-30 15:00:00 | QQQ | ETF | 49.31 | 49.32 | 49.13 | 49.27 | 3960399.0 |
| 2010-09-30 15:30:00 | QQQ | ETF | 49.275 | 49.3 | 49.06 | 49.06 | 7103148.0 |
> showing 50 of 8,799 rows — these rows as CSV