PREVIEW / etf_30min / 2008-02-06
file: by_date/etf_30min/2008/2008-02-06.parquet size: 158 KB rows: 5,598
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-06 04:00:00 | SPY | ETF | 134.49 | 134.49 | 134.49 | 134.49 | 200.0 |
| 2008-02-06 05:00:00 | SPY | ETF | 134.41 | 134.52 | 134.41 | 134.52 | 28500.0 |
| 2008-02-06 05:30:00 | SPY | ETF | 134.64 | 134.8 | 134.64 | 134.77 | 38200.0 |
| 2008-02-06 06:00:00 | SPY | ETF | 134.48 | 134.84 | 134.48 | 134.84 | 14000.0 |
| 2008-02-06 06:30:00 | SPY | ETF | 134.87 | 135.04 | 134.71 | 134.71 | 109400.0 |
| 2008-02-06 07:00:00 | SPY | ETF | 134.67 | 134.85 | 134.64 | 134.66 | 303900.0 |
| 2008-02-06 07:30:00 | SPY | ETF | 134.66 | 134.89 | 134.66 | 134.83 | 282900.0 |
| 2008-02-06 08:00:00 | SPY | ETF | 134.81 | 134.95 | 134.48 | 134.62 | 2132100.0 |
| 2008-02-06 08:30:00 | SPY | ETF | 134.63 | 135.0 | 134.0 | 134.76 | 2515800.0 |
| 2008-02-06 09:00:00 | SPY | ETF | 134.78 | 134.81 | 134.45 | 134.58 | 1205821.0 |
| 2008-02-06 09:30:00 | SPY | ETF | 134.58 | 134.68 | 133.45 | 133.9 | 24044861.0 |
| 2008-02-06 10:00:00 | SPY | ETF | 133.9101 | 134.6 | 133.9101 | 134.18 | 26985089.0 |
| 2008-02-06 10:30:00 | SPY | ETF | 134.19 | 134.89 | 134.0 | 134.7 | 18807080.0 |
| 2008-02-06 11:00:00 | SPY | ETF | 134.69 | 135.25 | 134.56 | 135.09 | 15921899.0 |
| 2008-02-06 11:30:00 | SPY | ETF | 135.09 | 135.24 | 134.75 | 134.9199 | 9389254.0 |
| 2008-02-06 12:00:00 | SPY | ETF | 134.92 | 135.03 | 134.4 | 134.45 | 11087177.0 |
| 2008-02-06 12:30:00 | SPY | ETF | 134.45 | 134.63 | 134.16 | 134.34 | 8679555.0 |
| 2008-02-06 13:00:00 | SPY | ETF | 134.34 | 134.5854 | 134.19 | 134.42 | 6343711.0 |
| 2008-02-06 13:30:00 | SPY | ETF | 134.42 | 134.44 | 133.57 | 133.63 | 13357233.0 |
| 2008-02-06 14:00:00 | SPY | ETF | 133.64 | 133.89 | 133.1 | 133.44 | 19492428.0 |
| 2008-02-06 14:30:00 | SPY | ETF | 133.43 | 133.87 | 133.3 | 133.64 | 12707926.0 |
| 2008-02-06 15:00:00 | SPY | ETF | 133.63 | 133.81 | 132.86 | 133.33 | 26433208.0 |
| 2008-02-06 15:30:00 | SPY | ETF | 133.33 | 133.6903 | 132.41 | 132.72 | 30075534.0 |
| 2008-02-06 16:00:00 | SPY | ETF | 132.76 | 133.51 | 132.65 | 133.15 | 3870100.0 |
| 2008-02-06 16:30:00 | SPY | ETF | 133.15 | 133.74 | 132.46 | 132.46 | 6532224.0 |
| 2008-02-06 17:00:00 | SPY | ETF | 132.5 | 132.74 | 132.0 | 132.07 | 2593100.0 |
| 2008-02-06 17:30:00 | SPY | ETF | 132.06 | 132.16 | 132.0 | 132.09 | 514000.0 |
| 2008-02-06 18:00:00 | SPY | ETF | 132.09 | 132.26 | 132.01 | 132.2 | 111100.0 |
| 2008-02-06 18:30:00 | SPY | ETF | 132.21 | 132.28 | 132.18 | 132.25 | 119800.0 |
| 2008-02-06 19:00:00 | SPY | ETF | 132.29 | 132.32 | 132.17 | 132.21 | 20700.0 |
| 2008-02-06 19:30:00 | SPY | ETF | 132.2 | 132.28 | 132.15 | 132.15 | 32000.0 |
| 2008-02-06 04:30:00 | QQQ | ETF | 43.81 | 43.81 | 43.81 | 43.81 | 300.0 |
| 2008-02-06 05:30:00 | QQQ | ETF | 43.95 | 43.96 | 43.95 | 43.96 | 1100.0 |
| 2008-02-06 07:00:00 | QQQ | ETF | 43.92 | 44.0 | 43.88 | 43.97 | 36825.0 |
| 2008-02-06 07:30:00 | QQQ | ETF | 43.99 | 44.02 | 43.94 | 43.97 | 172934.0 |
| 2008-02-06 08:00:00 | QQQ | ETF | 43.97 | 43.99 | 43.83 | 43.85 | 423431.0 |
| 2008-02-06 08:30:00 | QQQ | ETF | 43.85 | 43.99 | 43.85 | 43.92 | 711470.0 |
| 2008-02-06 09:00:00 | QQQ | ETF | 43.93 | 43.94 | 43.86 | 43.93 | 496505.0 |
| 2008-02-06 09:30:00 | QQQ | ETF | 43.93 | 43.93 | 43.62 | 43.79 | 13532000.0 |
| 2008-02-06 10:00:00 | QQQ | ETF | 43.8 | 44.1 | 43.73 | 43.79 | 25783887.0 |
| 2008-02-06 10:30:00 | QQQ | ETF | 43.79 | 44.06 | 43.76 | 43.98 | 11983542.0 |
| 2008-02-06 11:00:00 | QQQ | ETF | 43.98 | 44.17 | 43.92 | 44.11 | 9785954.0 |
| 2008-02-06 11:30:00 | QQQ | ETF | 44.1 | 44.14 | 43.93 | 44.0 | 7462425.0 |
| 2008-02-06 12:00:00 | QQQ | ETF | 44.0 | 44.04 | 43.82 | 43.87 | 4003079.0 |
| 2008-02-06 12:30:00 | QQQ | ETF | 43.87 | 43.91 | 43.74 | 43.8 | 5185895.0 |
| 2008-02-06 13:00:00 | QQQ | ETF | 43.81 | 43.83 | 43.7 | 43.8 | 4075077.0 |
| 2008-02-06 13:30:00 | QQQ | ETF | 43.81 | 43.81 | 43.33 | 43.36 | 7556318.0 |
| 2008-02-06 14:00:00 | QQQ | ETF | 43.359 | 43.44 | 43.06 | 43.24 | 16808695.0 |
| 2008-02-06 14:30:00 | QQQ | ETF | 43.24 | 43.39 | 43.15 | 43.3101 | 10502564.0 |
| 2008-02-06 15:00:00 | QQQ | ETF | 43.32 | 43.39 | 43.05 | 43.2 | 16541291.0 |
> showing 50 of 5,598 rows — these rows as CSV