PREVIEW / etf_30min / 2008-02-08
file: by_date/etf_30min/2008/2008-02-08.parquet size: 153 KB rows: 5,589
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-08 04:00:00 | SPY | ETF | 134.18 | 134.18 | 134.16 | 134.17 | 10100.0 |
| 2008-02-08 04:30:00 | SPY | ETF | 133.99 | 133.99 | 133.86 | 133.86 | 3100.0 |
| 2008-02-08 05:00:00 | SPY | ETF | 133.82 | 133.82 | 133.82 | 133.82 | 1000.0 |
| 2008-02-08 05:30:00 | SPY | ETF | 133.5 | 133.5 | 133.5 | 133.5 | 5000.0 |
| 2008-02-08 06:00:00 | SPY | ETF | 133.49 | 133.49 | 133.2 | 133.37 | 23000.0 |
| 2008-02-08 06:30:00 | SPY | ETF | 133.42 | 133.49 | 133.15 | 133.15 | 243500.0 |
| 2008-02-08 07:00:00 | SPY | ETF | 133.2 | 133.26 | 132.92 | 133.1 | 1121300.0 |
| 2008-02-08 07:30:00 | SPY | ETF | 133.04 | 133.43 | 132.96 | 133.14 | 740600.0 |
| 2008-02-08 08:00:00 | SPY | ETF | 133.14 | 133.4 | 132.96 | 133.13 | 2344000.0 |
| 2008-02-08 08:30:00 | SPY | ETF | 133.13 | 133.18 | 132.74 | 133.11 | 2580300.0 |
| 2008-02-08 09:00:00 | SPY | ETF | 133.11 | 133.26 | 133.02 | 133.25 | 1013218.0 |
| 2008-02-08 09:30:00 | SPY | ETF | 133.24 | 133.86 | 132.92 | 133.83 | 22587271.0 |
| 2008-02-08 10:00:00 | SPY | ETF | 133.83 | 134.02 | 133.5 | 133.79 | 13727695.0 |
| 2008-02-08 10:30:00 | SPY | ETF | 133.79 | 133.98 | 133.4 | 133.74 | 10039052.0 |
| 2008-02-08 11:00:00 | SPY | ETF | 133.75 | 134.22 | 133.58 | 133.69 | 11397980.0 |
| 2008-02-08 11:30:00 | SPY | ETF | 133.68 | 133.86 | 133.18 | 133.24 | 8843759.0 |
| 2008-02-08 12:00:00 | SPY | ETF | 133.23 | 133.38 | 132.78 | 133.25 | 13613460.0 |
| 2008-02-08 12:30:00 | SPY | ETF | 133.25 | 133.35 | 132.78 | 133.29 | 9125859.0 |
| 2008-02-08 13:00:00 | SPY | ETF | 133.28 | 133.29 | 132.35 | 132.79 | 13369383.0 |
| 2008-02-08 13:30:00 | SPY | ETF | 132.8 | 133.0 | 132.1 | 132.72 | 18304109.0 |
| 2008-02-08 14:00:00 | SPY | ETF | 132.72 | 133.21 | 132.46 | 133.05 | 11706115.0 |
| 2008-02-08 14:30:00 | SPY | ETF | 133.04 | 133.17 | 132.45 | 132.63 | 8959018.0 |
| 2008-02-08 15:00:00 | SPY | ETF | 132.63 | 133.02 | 132.53 | 132.96 | 10158799.0 |
| 2008-02-08 15:30:00 | SPY | ETF | 132.98 | 133.72 | 132.91 | 133.12 | 31682642.0 |
| 2008-02-08 16:00:00 | SPY | ETF | 133.08 | 133.7523 | 132.93 | 133.0 | 7811900.0 |
| 2008-02-08 16:30:00 | SPY | ETF | 133.0 | 133.07 | 132.95 | 132.98 | 18555089.0 |
| 2008-02-08 17:00:00 | SPY | ETF | 132.95 | 133.03 | 132.95 | 133.03 | 23000.0 |
| 2008-02-08 17:30:00 | SPY | ETF | 133.03 | 133.04 | 132.94 | 133.02 | 12300.0 |
| 2008-02-08 18:00:00 | SPY | ETF | 133.02 | 133.02 | 133.02 | 133.02 | 5900.0 |
| 2008-02-08 18:30:00 | SPY | ETF | 133.0 | 133.0 | 132.9 | 132.9 | 9500.0 |
| 2008-02-08 19:00:00 | SPY | ETF | 132.98 | 133.0 | 132.96 | 133.0 | 1800.0 |
| 2008-02-08 19:30:00 | SPY | ETF | 132.99 | 133.05 | 132.99 | 133.05 | 3100.0 |
| 2008-02-08 05:30:00 | QQQ | ETF | 43.19 | 43.19 | 43.19 | 43.19 | 1000.0 |
| 2008-02-08 06:00:00 | QQQ | ETF | 43.1 | 43.1 | 43.06 | 43.06 | 3300.0 |
| 2008-02-08 06:30:00 | QQQ | ETF | 43.08 | 43.08 | 43.08 | 43.08 | 10000.0 |
| 2008-02-08 07:00:00 | QQQ | ETF | 43.08 | 43.12 | 43.04 | 43.12 | 144404.0 |
| 2008-02-08 07:30:00 | QQQ | ETF | 43.08 | 43.24 | 43.07 | 43.14 | 383194.0 |
| 2008-02-08 08:00:00 | QQQ | ETF | 43.14 | 43.28 | 43.08 | 43.15 | 1126909.0 |
| 2008-02-08 08:30:00 | QQQ | ETF | 43.15 | 43.28 | 43.07 | 43.18 | 761732.0 |
| 2008-02-08 09:00:00 | QQQ | ETF | 43.17 | 43.23 | 43.12 | 43.19 | 2011103.0 |
| 2008-02-08 09:30:00 | QQQ | ETF | 43.18 | 43.57 | 43.05 | 43.5 | 28037102.0 |
| 2008-02-08 10:00:00 | QQQ | ETF | 43.5 | 43.64 | 43.31 | 43.54 | 12159689.0 |
| 2008-02-08 10:30:00 | QQQ | ETF | 43.54 | 43.7 | 43.42 | 43.66 | 10927527.0 |
| 2008-02-08 11:00:00 | QQQ | ETF | 43.66 | 43.77 | 43.57 | 43.57 | 8367025.0 |
| 2008-02-08 11:30:00 | QQQ | ETF | 43.57 | 43.65 | 43.35 | 43.36 | 9105292.0 |
| 2008-02-08 12:00:00 | QQQ | ETF | 43.36 | 43.47 | 43.25 | 43.41 | 8334479.0 |
| 2008-02-08 12:30:00 | QQQ | ETF | 43.41 | 43.46 | 43.26 | 43.45 | 9171435.0 |
| 2008-02-08 13:00:00 | QQQ | ETF | 43.44 | 43.45 | 43.19 | 43.3 | 7806158.0 |
| 2008-02-08 13:30:00 | QQQ | ETF | 43.2905 | 43.32 | 42.94 | 43.2 | 18216485.0 |
| 2008-02-08 14:00:00 | QQQ | ETF | 43.2 | 43.4 | 43.1 | 43.33 | 11607926.0 |
> showing 50 of 5,589 rows — these rows as CSV