PREVIEW / etf_30min / 2002-10-10
file: by_date/etf_30min/2002/2002-10-10.parquet size: 22 KB rows: 607
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 |
|---|---|---|---|---|---|---|---|
| 2002-10-10 08:00:00 | SPY | ETF | 78.35 | 78.52 | 78.19 | 78.19 | 8300.0 |
| 2002-10-10 08:30:00 | SPY | ETF | 78.25 | 78.67 | 78.24 | 78.39 | 16800.0 |
| 2002-10-10 09:00:00 | SPY | ETF | 78.44 | 78.5 | 77.91 | 77.91 | 13800.0 |
| 2002-10-10 09:30:00 | SPY | ETF | 77.94 | 78.55 | 77.07 | 77.15 | 8606000.0 |
| 2002-10-10 10:00:00 | SPY | ETF | 77.15 | 78.52 | 77.1 | 78.24 | 6924600.0 |
| 2002-10-10 10:30:00 | SPY | ETF | 78.25 | 80.1 | 78.1 | 79.96 | 7767000.0 |
| 2002-10-10 11:00:00 | SPY | ETF | 79.96 | 80.08 | 79.34 | 79.61 | 5551800.0 |
| 2002-10-10 11:30:00 | SPY | ETF | 79.6 | 79.75 | 78.95 | 79.17 | 4197700.0 |
| 2002-10-10 12:00:00 | SPY | ETF | 79.2 | 79.76 | 79.2 | 79.33 | 2305700.0 |
| 2002-10-10 12:30:00 | SPY | ETF | 79.35 | 79.75 | 79.21 | 79.52 | 3144500.0 |
| 2002-10-10 13:00:00 | SPY | ETF | 79.52 | 80.35 | 79.47 | 80.12 | 5652300.0 |
| 2002-10-10 13:30:00 | SPY | ETF | 80.1 | 80.64 | 80.06 | 80.18 | 4733600.0 |
| 2002-10-10 14:00:00 | SPY | ETF | 80.2 | 80.46 | 79.75 | 79.87 | 4929800.0 |
| 2002-10-10 14:30:00 | SPY | ETF | 79.93 | 80.56 | 79.76 | 80.4 | 4259600.0 |
| 2002-10-10 15:00:00 | SPY | ETF | 80.4 | 81.07 | 80.36 | 80.5 | 5145700.0 |
| 2002-10-10 15:30:00 | SPY | ETF | 80.5 | 80.75 | 80.22 | 80.66 | 4264400.0 |
| 2002-10-10 16:00:00 | SPY | ETF | 80.69 | 80.77 | 80.4 | 80.62 | 3751000.0 |
| 2002-10-10 16:30:00 | SPY | ETF | 80.38 | 80.68 | 77.82 | 77.82 | 1595400.0 |
| 2002-10-10 17:00:00 | SPY | ETF | 77.82 | 80.71 | 77.15 | 80.63 | 44300.0 |
| 2002-10-10 17:30:00 | SPY | ETF | 80.63 | 80.7 | 80.62 | 80.7 | 4900.0 |
| 2002-10-10 18:00:00 | SPY | ETF | 80.63 | 80.63 | 80.58 | 80.58 | 8400.0 |
| 2002-10-10 18:30:00 | SPY | ETF | 80.53 | 80.53 | 80.53 | 80.53 | 200.0 |
| 2002-10-10 19:00:00 | SPY | ETF | 80.53 | 80.53 | 80.53 | 80.53 | 100.0 |
| 2002-10-10 19:30:00 | SPY | ETF | 80.54 | 80.54 | 80.54 | 80.54 | 25100.0 |
| 2002-10-10 08:00:00 | QQQ | ETF | 20.18 | 20.18 | 20.15 | 20.15 | 5200.0 |
| 2002-10-10 08:30:00 | QQQ | ETF | 20.23 | 20.25 | 20.15 | 20.15 | 10100.0 |
| 2002-10-10 09:00:00 | QQQ | ETF | 20.2 | 20.2 | 20.14 | 20.15 | 23000.0 |
| 2002-10-10 09:30:00 | QQQ | ETF | 20.1 | 20.37 | 19.91 | 19.94 | 11136600.0 |
| 2002-10-10 10:00:00 | QQQ | ETF | 19.97 | 20.37 | 19.91 | 20.26 | 8060100.0 |
| 2002-10-10 10:30:00 | QQQ | ETF | 20.27 | 20.88 | 20.27 | 20.83 | 14404000.0 |
| 2002-10-10 11:00:00 | QQQ | ETF | 20.82 | 20.98 | 20.71 | 20.89 | 9115200.0 |
| 2002-10-10 11:30:00 | QQQ | ETF | 20.87 | 20.91 | 20.65 | 20.7 | 6697800.0 |
| 2002-10-10 12:00:00 | QQQ | ETF | 20.72 | 20.87 | 20.68 | 20.7 | 2829800.0 |
| 2002-10-10 12:30:00 | QQQ | ETF | 20.69 | 20.85 | 20.66 | 20.84 | 6250400.0 |
| 2002-10-10 13:00:00 | QQQ | ETF | 20.85 | 21.09 | 20.79 | 21.03 | 10716700.0 |
| 2002-10-10 13:30:00 | QQQ | ETF | 21.03 | 21.2 | 20.96 | 21.08 | 10142300.0 |
| 2002-10-10 14:00:00 | QQQ | ETF | 21.08 | 21.16 | 20.91 | 20.95 | 6301100.0 |
| 2002-10-10 14:30:00 | QQQ | ETF | 20.96 | 21.14 | 20.94 | 21.09 | 4568500.0 |
| 2002-10-10 15:00:00 | QQQ | ETF | 21.07 | 21.21 | 21.02 | 21.05 | 7277000.0 |
| 2002-10-10 15:30:00 | QQQ | ETF | 21.05 | 21.17 | 20.97 | 21.08 | 5779900.0 |
| 2002-10-10 16:00:00 | QQQ | ETF | 21.08 | 21.13 | 21.02 | 21.08 | 3129900.0 |
| 2002-10-10 16:30:00 | QQQ | ETF | 21.05 | 21.13 | 21.04 | 21.09 | 266100.0 |
| 2002-10-10 17:00:00 | QQQ | ETF | 21.11 | 21.15 | 21.08 | 21.11 | 137800.0 |
| 2002-10-10 17:30:00 | QQQ | ETF | 21.13 | 21.14 | 21.09 | 21.13 | 37900.0 |
| 2002-10-10 18:00:00 | QQQ | ETF | 21.13 | 21.18 | 21.11 | 21.18 | 28400.0 |
| 2002-10-10 18:30:00 | QQQ | ETF | 21.14 | 21.18 | 21.14 | 21.18 | 800.0 |
| 2002-10-10 19:30:00 | QQQ | ETF | 21.11 | 21.13 | 21.09 | 21.09 | 500.0 |
| 2002-10-10 09:30:00 | IWM | ETF | 32.535 | 32.77 | 32.3 | 32.3 | 351600.0 |
| 2002-10-10 10:00:00 | IWM | ETF | 32.4 | 32.6 | 32.305 | 32.57 | 45800.0 |
| 2002-10-10 10:30:00 | IWM | ETF | 32.55 | 32.97 | 32.445 | 32.935 | 540600.0 |
> showing 50 of 607 rows — these rows as CSV