PREVIEW / etf_30min / 2006-02-24
file: by_date/etf_30min/2006/2006-02-24.parquet size: 57 KB rows: 2,115
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-24 05:00:00 | SPY | ETF | 129.2 | 129.25 | 129.2 | 129.25 | 2800.0 |
| 2006-02-24 05:30:00 | SPY | ETF | 129.25 | 129.29 | 129.25 | 129.29 | 200.0 |
| 2006-02-24 06:00:00 | SPY | ETF | 129.29 | 129.29 | 129.29 | 129.29 | 100.0 |
| 2006-02-24 07:00:00 | SPY | ETF | 129.23 | 129.3 | 129.23 | 129.3 | 16500.0 |
| 2006-02-24 07:30:00 | SPY | ETF | 129.25 | 129.26 | 129.25 | 129.26 | 12000.0 |
| 2006-02-24 08:00:00 | SPY | ETF | 129.25 | 129.3 | 128.91 | 128.97 | 1844700.0 |
| 2006-02-24 08:30:00 | SPY | ETF | 128.93 | 129.19 | 128.84 | 129.0 | 2478200.0 |
| 2006-02-24 09:00:00 | SPY | ETF | 129.0 | 129.14 | 128.98 | 129.08 | 253500.0 |
| 2006-02-24 09:30:00 | SPY | ETF | 129.11 | 129.23 | 128.9 | 129.08 | 3915800.0 |
| 2006-02-24 10:00:00 | SPY | ETF | 129.1 | 129.35 | 129.02 | 129.0514 | 3689400.0 |
| 2006-02-24 10:30:00 | SPY | ETF | 129.05 | 129.1 | 128.76 | 128.92 | 4242300.0 |
| 2006-02-24 11:00:00 | SPY | ETF | 128.93 | 129.14 | 128.93 | 129.05 | 1673900.0 |
| 2006-02-24 11:30:00 | SPY | ETF | 129.05 | 129.2 | 128.97 | 129.07 | 2197900.0 |
| 2006-02-24 12:00:00 | SPY | ETF | 129.08 | 129.23 | 129.01 | 129.14 | 1048900.0 |
| 2006-02-24 12:30:00 | SPY | ETF | 129.14 | 129.33 | 129.11 | 129.24 | 1152400.0 |
| 2006-02-24 13:00:00 | SPY | ETF | 129.25 | 129.29 | 129.04 | 129.13 | 1674700.0 |
| 2006-02-24 13:30:00 | SPY | ETF | 129.12 | 129.16 | 128.96 | 129.02 | 1123900.0 |
| 2006-02-24 14:00:00 | SPY | ETF | 129.04 | 129.19 | 129.02 | 129.16 | 698700.0 |
| 2006-02-24 14:30:00 | SPY | ETF | 129.16 | 129.42 | 129.08 | 129.41 | 2409900.0 |
| 2006-02-24 15:00:00 | SPY | ETF | 129.41 | 129.48 | 129.29 | 129.32 | 2616000.0 |
| 2006-02-24 15:30:00 | SPY | ETF | 129.32 | 129.34 | 129.11 | 129.23 | 3433100.0 |
| 2006-02-24 16:00:00 | SPY | ETF | 129.22 | 129.41 | 129.16 | 129.31 | 566600.0 |
| 2006-02-24 16:30:00 | SPY | ETF | 129.31 | 129.38 | 129.3 | 129.3 | 99500.0 |
| 2006-02-24 17:00:00 | SPY | ETF | 129.3 | 129.3 | 129.3 | 129.3 | 1500.0 |
| 2006-02-24 18:00:00 | SPY | ETF | 129.32 | 129.37 | 129.1644 | 129.37 | 5300.0 |
| 2006-02-24 18:30:00 | SPY | ETF | 129.37 | 129.38 | 129.37 | 129.38 | 700.0 |
| 2006-02-24 19:00:00 | SPY | ETF | 129.38 | 129.38 | 129.38 | 129.38 | 200.0 |
| 2006-02-24 19:30:00 | SPY | ETF | 129.38 | 129.38 | 129.38 | 129.38 | 1000.0 |
| 2006-02-24 09:30:00 | QQQ | ETF | 41.15 | 41.21 | 41.04 | 41.14 | 9862200.0 |
| 2006-02-24 10:00:00 | QQQ | ETF | 41.13 | 41.29 | 41.13 | 41.16 | 6727100.0 |
| 2006-02-24 10:30:00 | QQQ | ETF | 41.16 | 41.17 | 40.15 | 41.06 | 6251700.0 |
| 2006-02-24 11:00:00 | QQQ | ETF | 41.06 | 41.16 | 41.05 | 41.1 | 3440000.0 |
| 2006-02-24 11:30:00 | QQQ | ETF | 41.09 | 41.16 | 41.07 | 41.15 | 2205100.0 |
| 2006-02-24 12:00:00 | QQQ | ETF | 41.15 | 41.2 | 41.13 | 41.18 | 1960200.0 |
| 2006-02-24 12:30:00 | QQQ | ETF | 41.18 | 41.27 | 41.17 | 41.25 | 3382400.0 |
| 2006-02-24 13:00:00 | QQQ | ETF | 41.25 | 41.27 | 41.17 | 41.2 | 2780400.0 |
| 2006-02-24 13:30:00 | QQQ | ETF | 41.2 | 41.2 | 41.1 | 41.12 | 2306000.0 |
| 2006-02-24 14:00:00 | QQQ | ETF | 41.12 | 41.21 | 41.1 | 41.2 | 3123300.0 |
| 2006-02-24 14:30:00 | QQQ | ETF | 41.19 | 41.27 | 41.17 | 41.27 | 2507500.0 |
| 2006-02-24 15:00:00 | QQQ | ETF | 41.26 | 41.29 | 41.21 | 41.23 | 3261700.0 |
| 2006-02-24 15:30:00 | QQQ | ETF | 41.22 | 41.27 | 41.14 | 41.25 | 4348400.0 |
| 2006-02-24 08:00:00 | IWM | ETF | 72.77 | 72.77 | 72.61 | 72.66 | 14800.0 |
| 2006-02-24 08:30:00 | IWM | ETF | 72.71 | 72.75 | 72.68 | 72.73 | 5100.0 |
| 2006-02-24 09:00:00 | IWM | ETF | 72.68 | 72.73 | 72.66 | 72.71 | 44100.0 |
| 2006-02-24 09:30:00 | IWM | ETF | 72.69 | 72.85 | 72.45 | 72.7 | 1866400.0 |
| 2006-02-24 10:00:00 | IWM | ETF | 72.7 | 72.9 | 72.59 | 72.75 | 2373200.0 |
| 2006-02-24 10:30:00 | IWM | ETF | 72.75 | 72.75 | 72.49 | 72.57 | 3552300.0 |
| 2006-02-24 11:00:00 | IWM | ETF | 72.58 | 72.86 | 72.57 | 72.76 | 1002700.0 |
| 2006-02-24 11:30:00 | IWM | ETF | 72.77 | 72.9 | 72.74 | 72.88 | 1683100.0 |
| 2006-02-24 12:00:00 | IWM | ETF | 72.89 | 72.97 | 72.85 | 72.9 | 523100.0 |
> showing 50 of 2,115 rows — these rows as CSV