PREVIEW / etf_30min / 2005-11-21
file: by_date/etf_30min/2005/2005-11-21.parquet size: 51 KB rows: 1,848
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-21 06:30:00 | SPY | ETF | 125.13 | 125.13 | 125.11 | 125.11 | 25000.0 |
| 2005-11-21 07:00:00 | SPY | ETF | 125.12 | 125.24 | 125.12 | 125.24 | 10100.0 |
| 2005-11-21 07:30:00 | SPY | ETF | 125.2 | 125.2 | 125.11 | 125.12 | 31300.0 |
| 2005-11-21 08:00:00 | SPY | ETF | 125.16 | 125.25 | 125.13 | 125.24 | 427000.0 |
| 2005-11-21 08:30:00 | SPY | ETF | 125.22 | 125.24 | 125.1 | 125.19 | 121700.0 |
| 2005-11-21 09:00:00 | SPY | ETF | 125.2 | 125.23 | 125.0 | 125.15 | 228100.0 |
| 2005-11-21 09:30:00 | SPY | ETF | 125.15 | 125.2 | 124.98 | 125.01 | 4526500.0 |
| 2005-11-21 10:00:00 | SPY | ETF | 125.01 | 125.25 | 125.0 | 125.19 | 2965800.0 |
| 2005-11-21 10:30:00 | SPY | ETF | 125.19 | 125.5 | 125.16 | 125.45 | 5900500.0 |
| 2005-11-21 11:00:00 | SPY | ETF | 125.44 | 125.52 | 125.24 | 125.33 | 3452300.0 |
| 2005-11-21 11:30:00 | SPY | ETF | 125.33 | 125.49 | 125.13 | 125.23 | 3112100.0 |
| 2005-11-21 12:00:00 | SPY | ETF | 125.23 | 125.32 | 125.13 | 125.2 | 2850400.0 |
| 2005-11-21 12:30:00 | SPY | ETF | 125.2 | 125.35 | 125.19 | 125.29 | 1282900.0 |
| 2005-11-21 13:00:00 | SPY | ETF | 125.29 | 125.32 | 125.18 | 125.28 | 1307500.0 |
| 2005-11-21 13:30:00 | SPY | ETF | 125.28 | 125.49 | 125.26 | 125.4 | 3126200.0 |
| 2005-11-21 14:00:00 | SPY | ETF | 125.39 | 125.48 | 125.32 | 125.47 | 1935700.0 |
| 2005-11-21 14:30:00 | SPY | ETF | 125.47 | 125.5 | 125.34 | 125.44 | 4195100.0 |
| 2005-11-21 15:00:00 | SPY | ETF | 125.43 | 125.59 | 125.39 | 125.55 | 3545600.0 |
| 2005-11-21 15:30:00 | SPY | ETF | 125.56 | 125.91 | 125.51 | 125.73 | 7862100.0 |
| 2005-11-21 16:00:00 | SPY | ETF | 125.76 | 125.81 | 125.74 | 125.77 | 570700.0 |
| 2005-11-21 16:30:00 | SPY | ETF | 125.76 | 125.78 | 125.74 | 125.75 | 601200.0 |
| 2005-11-21 17:00:00 | SPY | ETF | 125.75 | 125.75 | 125.74 | 125.74 | 17700.0 |
| 2005-11-21 17:30:00 | SPY | ETF | 125.73 | 125.73 | 125.73 | 125.73 | 200.0 |
| 2005-11-21 18:00:00 | SPY | ETF | 125.76 | 125.79 | 125.76 | 125.79 | 700.0 |
| 2005-11-21 19:00:00 | SPY | ETF | 125.79 | 125.8 | 125.76 | 125.76 | 1500.0 |
| 2005-11-21 19:30:00 | SPY | ETF | 125.76 | 125.78 | 125.75 | 125.76 | 1900.0 |
| 2005-11-21 09:30:00 | QQQ | ETF | 41.4 | 41.43 | 41.24 | 41.27 | 8264000.0 |
| 2005-11-21 10:00:00 | QQQ | ETF | 41.27 | 41.42 | 41.27 | 41.38 | 7171800.0 |
| 2005-11-21 10:30:00 | QQQ | ETF | 41.37 | 41.52 | 41.35 | 41.48 | 6353800.0 |
| 2005-11-21 11:00:00 | QQQ | ETF | 41.49 | 41.5 | 41.33 | 41.36 | 5108700.0 |
| 2005-11-21 11:30:00 | QQQ | ETF | 41.36 | 41.37 | 41.24 | 41.29 | 6281700.0 |
| 2005-11-21 12:00:00 | QQQ | ETF | 41.28 | 41.38 | 41.28 | 41.33 | 2566800.0 |
| 2005-11-21 12:30:00 | QQQ | ETF | 41.33 | 41.4 | 41.32 | 41.36 | 2726200.0 |
| 2005-11-21 13:00:00 | QQQ | ETF | 41.36 | 41.38 | 41.3 | 41.35 | 1942200.0 |
| 2005-11-21 13:30:00 | QQQ | ETF | 41.35 | 41.44 | 41.34 | 41.41 | 3103200.0 |
| 2005-11-21 14:00:00 | QQQ | ETF | 41.4 | 41.45 | 41.36 | 41.44 | 2597500.0 |
| 2005-11-21 14:30:00 | QQQ | ETF | 41.44 | 41.45 | 41.36 | 41.39 | 2119900.0 |
| 2005-11-21 15:00:00 | QQQ | ETF | 41.39 | 41.48 | 41.38 | 41.47 | 3375100.0 |
| 2005-11-21 15:30:00 | QQQ | ETF | 41.47 | 41.58 | 41.45 | 41.55 | 9135700.0 |
| 2005-11-21 07:00:00 | IWM | ETF | 66.94 | 66.94 | 66.94 | 66.94 | 400.0 |
| 2005-11-21 07:30:00 | IWM | ETF | 66.94 | 66.94 | 66.93 | 66.93 | 10400.0 |
| 2005-11-21 08:00:00 | IWM | ETF | 66.93 | 66.97 | 66.86 | 66.93 | 359700.0 |
| 2005-11-21 08:30:00 | IWM | ETF | 66.95 | 66.95 | 66.92 | 66.92 | 5800.0 |
| 2005-11-21 09:00:00 | IWM | ETF | 66.94 | 67.02 | 66.94 | 67.01 | 160000.0 |
| 2005-11-21 09:30:00 | IWM | ETF | 67.005 | 67.07 | 66.52 | 66.56 | 3534400.0 |
| 2005-11-21 10:00:00 | IWM | ETF | 66.56 | 66.77 | 66.52 | 66.73 | 1290900.0 |
| 2005-11-21 10:30:00 | IWM | ETF | 66.73 | 67.16 | 66.73 | 67.14 | 3590600.0 |
| 2005-11-21 11:00:00 | IWM | ETF | 67.14 | 67.15 | 66.92 | 66.98 | 1374600.0 |
| 2005-11-21 11:30:00 | IWM | ETF | 66.98 | 67.01 | 66.84 | 66.94 | 556400.0 |
| 2005-11-21 12:00:00 | IWM | ETF | 66.92 | 67.06 | 66.88 | 67.01 | 988800.0 |
> showing 50 of 1,848 rows — these rows as CSV