PREVIEW / etf_30min / 2007-02-09
file: by_date/etf_30min/2007/2007-02-09.parquet size: 103 KB rows: 3,498
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-09 04:00:00 | SPY | ETF | 145.16 | 145.16 | 145.16 | 145.16 | 400.0 |
| 2007-02-09 07:00:00 | SPY | ETF | 145.04 | 145.09 | 145.04 | 145.09 | 26500.0 |
| 2007-02-09 07:30:00 | SPY | ETF | 145.04 | 145.11 | 145.03 | 145.04 | 28400.0 |
| 2007-02-09 08:00:00 | SPY | ETF | 145.05 | 145.1 | 144.99 | 145.02 | 379600.0 |
| 2007-02-09 08:30:00 | SPY | ETF | 145.02 | 145.05 | 144.96 | 145.0 | 542100.0 |
| 2007-02-09 09:00:00 | SPY | ETF | 145.01 | 145.06 | 144.98 | 145.04 | 324100.0 |
| 2007-02-09 09:30:00 | SPY | ETF | 145.06 | 145.33 | 144.99 | 145.13 | 4884800.0 |
| 2007-02-09 10:00:00 | SPY | ETF | 145.11 | 145.21 | 144.89 | 144.92 | 4670200.0 |
| 2007-02-09 10:30:00 | SPY | ETF | 144.91 | 145.0 | 144.82 | 144.85 | 5601000.0 |
| 2007-02-09 11:00:00 | SPY | ETF | 144.85 | 145.06 | 144.84 | 144.95 | 2652600.0 |
| 2007-02-09 11:30:00 | SPY | ETF | 144.95 | 145.12 | 144.9 | 145.06 | 2377700.0 |
| 2007-02-09 12:00:00 | SPY | ETF | 145.06 | 145.07 | 144.91 | 144.92 | 1870400.0 |
| 2007-02-09 12:30:00 | SPY | ETF | 144.92 | 144.92 | 144.35 | 144.47 | 7357100.0 |
| 2007-02-09 13:00:00 | SPY | ETF | 144.47 | 144.5 | 144.32 | 144.45 | 5207300.0 |
| 2007-02-09 13:30:00 | SPY | ETF | 144.44 | 144.45 | 143.81 | 144.0 | 10761000.0 |
| 2007-02-09 14:00:00 | SPY | ETF | 144.0 | 144.06 | 143.65 | 143.83 | 6220600.0 |
| 2007-02-09 14:30:00 | SPY | ETF | 143.83 | 143.84 | 143.39 | 143.56 | 7396300.0 |
| 2007-02-09 15:00:00 | SPY | ETF | 143.55 | 143.94 | 143.53 | 143.89 | 7165200.0 |
| 2007-02-09 15:30:00 | SPY | ETF | 143.89 | 143.95 | 143.76 | 143.92 | 7664600.0 |
| 2007-02-09 16:00:00 | SPY | ETF | 143.93 | 144.01 | 143.85 | 143.94 | 2494700.0 |
| 2007-02-09 16:30:00 | SPY | ETF | 143.94 | 143.96 | 143.9 | 143.96 | 16500.0 |
| 2007-02-09 17:00:00 | SPY | ETF | 143.95 | 143.95 | 143.9 | 143.9 | 7900.0 |
| 2007-02-09 17:30:00 | SPY | ETF | 143.9 | 143.9 | 143.9 | 143.9 | 6000.0 |
| 2007-02-09 18:00:00 | SPY | ETF | 143.9 | 143.9 | 143.9 | 143.9 | 100.0 |
| 2007-02-09 18:30:00 | SPY | ETF | 143.9 | 143.9 | 143.86 | 143.86 | 1400.0 |
| 2007-02-09 19:30:00 | SPY | ETF | 143.9 | 143.9 | 143.86 | 143.86 | 600.0 |
| 2007-02-09 05:30:00 | QQQ | ETF | 44.58 | 44.58 | 44.58 | 44.58 | 200.0 |
| 2007-02-09 07:00:00 | QQQ | ETF | 44.56 | 44.56 | 44.56 | 44.56 | 10600.0 |
| 2007-02-09 07:30:00 | QQQ | ETF | 44.56 | 44.57 | 44.56 | 44.57 | 27322.0 |
| 2007-02-09 08:00:00 | QQQ | ETF | 44.57 | 44.59 | 44.55 | 44.56 | 134346.0 |
| 2007-02-09 08:30:00 | QQQ | ETF | 44.56 | 44.57 | 44.55 | 44.56 | 671667.0 |
| 2007-02-09 09:00:00 | QQQ | ETF | 44.56 | 44.58 | 44.56 | 44.57 | 477948.0 |
| 2007-02-09 09:30:00 | QQQ | ETF | 44.57 | 44.72 | 44.56 | 44.57 | 13447400.0 |
| 2007-02-09 10:00:00 | QQQ | ETF | 44.58 | 44.61 | 44.42 | 44.44 | 9366500.0 |
| 2007-02-09 10:30:00 | QQQ | ETF | 44.43 | 44.5 | 44.33 | 44.37 | 11025200.0 |
| 2007-02-09 11:00:00 | QQQ | ETF | 44.36 | 44.44 | 44.35 | 44.4 | 3816700.0 |
| 2007-02-09 11:30:00 | QQQ | ETF | 44.4 | 44.49 | 44.36 | 44.46 | 3521800.0 |
| 2007-02-09 12:00:00 | QQQ | ETF | 44.45 | 44.47 | 44.34 | 44.34 | 4691000.0 |
| 2007-02-09 12:30:00 | QQQ | ETF | 44.35 | 44.35 | 43.98 | 44.0 | 16439800.0 |
| 2007-02-09 13:00:00 | QQQ | ETF | 44.0 | 44.11 | 43.96 | 44.06 | 12691600.0 |
| 2007-02-09 13:30:00 | QQQ | ETF | 44.06 | 44.06 | 43.88 | 43.96 | 12874000.0 |
| 2007-02-09 14:00:00 | QQQ | ETF | 43.96 | 44.0 | 43.84 | 43.94 | 9047000.0 |
| 2007-02-09 14:30:00 | QQQ | ETF | 43.96 | 43.96 | 43.73 | 43.86 | 9634700.0 |
| 2007-02-09 15:00:00 | QQQ | ETF | 43.86 | 44.01 | 43.83 | 43.97 | 9962700.0 |
| 2007-02-09 15:30:00 | QQQ | ETF | 43.97 | 44.0 | 43.88 | 43.89 | 10750600.0 |
| 2007-02-09 16:00:00 | QQQ | ETF | 43.89 | 43.92 | 43.83 | 43.85 | 1938153.0 |
| 2007-02-09 16:30:00 | QQQ | ETF | 43.85 | 43.86 | 43.82 | 43.84 | 62125.0 |
| 2007-02-09 17:00:00 | QQQ | ETF | 43.84 | 43.84 | 43.76 | 43.82 | 28700.0 |
| 2007-02-09 17:30:00 | QQQ | ETF | 43.82 | 43.83 | 43.82 | 43.82 | 4271.0 |
| 2007-02-09 18:00:00 | QQQ | ETF | 43.8 | 43.84 | 43.8 | 43.8 | 6811.0 |
> showing 50 of 3,498 rows — these rows as CSV