PREVIEW / etf_30min / 2010-12-15
file: by_date/etf_30min/2010/2010-12-15.parquet size: 274 KB rows: 9,065
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-15 04:00:00 | SPY | ETF | 124.28 | 124.28 | 124.06 | 124.28 | 7611.0 |
| 2010-12-15 04:30:00 | SPY | ETF | 124.29 | 124.29 | 124.24 | 124.28 | 2300.0 |
| 2010-12-15 05:00:00 | SPY | ETF | 124.2 | 124.2 | 124.15 | 124.19 | 2400.0 |
| 2010-12-15 05:30:00 | SPY | ETF | 124.1 | 124.15 | 124.05 | 124.1 | 3000.0 |
| 2010-12-15 06:00:00 | SPY | ETF | 124.08 | 124.15 | 124.07 | 124.1 | 5000.0 |
| 2010-12-15 06:30:00 | SPY | ETF | 124.17 | 124.29 | 124.15 | 124.22 | 23350.0 |
| 2010-12-15 07:00:00 | SPY | ETF | 124.23 | 124.33 | 124.17 | 124.33 | 99610.0 |
| 2010-12-15 07:30:00 | SPY | ETF | 124.34 | 124.46 | 124.25 | 124.25 | 156713.0 |
| 2010-12-15 08:00:00 | SPY | ETF | 124.27 | 124.49 | 124.13 | 124.37 | 704601.0 |
| 2010-12-15 08:30:00 | SPY | ETF | 124.45 | 124.47 | 124.22 | 124.34 | 505528.0 |
| 2010-12-15 09:00:00 | SPY | ETF | 124.34 | 124.47 | 124.22 | 124.46 | 1025360.0 |
| 2010-12-15 09:30:00 | SPY | ETF | 124.44 | 124.77 | 124.38 | 124.76 | 14485934.0 |
| 2010-12-15 10:00:00 | SPY | ETF | 124.75 | 124.87 | 124.72 | 124.74 | 9094784.0 |
| 2010-12-15 10:30:00 | SPY | ETF | 124.75 | 124.93 | 124.75 | 124.8 | 6718217.0 |
| 2010-12-15 11:00:00 | SPY | ETF | 124.81 | 124.92 | 124.62 | 124.719 | 8923093.0 |
| 2010-12-15 11:30:00 | SPY | ETF | 124.72 | 124.72 | 124.575 | 124.67 | 6257850.0 |
| 2010-12-15 12:00:00 | SPY | ETF | 124.67 | 124.69 | 124.58 | 124.649 | 4704473.0 |
| 2010-12-15 12:30:00 | SPY | ETF | 124.65 | 124.6675 | 124.21 | 124.33 | 12705471.0 |
| 2010-12-15 13:00:00 | SPY | ETF | 124.33 | 124.6675 | 124.22 | 124.41 | 8668946.0 |
| 2010-12-15 13:30:00 | SPY | ETF | 124.415 | 124.52 | 124.34 | 124.5 | 5239826.0 |
| 2010-12-15 14:00:00 | SPY | ETF | 124.51 | 124.52 | 124.16 | 124.16 | 7150399.0 |
| 2010-12-15 14:30:00 | SPY | ETF | 124.17 | 124.19 | 123.89 | 123.985 | 15637249.0 |
| 2010-12-15 15:00:00 | SPY | ETF | 123.99 | 124.4 | 123.95 | 124.3 | 12545202.0 |
| 2010-12-15 15:30:00 | SPY | ETF | 124.3 | 124.47 | 124.01 | 124.1 | 22987032.0 |
| 2010-12-15 16:00:00 | SPY | ETF | 124.12 | 124.905 | 124.11 | 124.18 | 10014252.0 |
| 2010-12-15 16:30:00 | SPY | ETF | 124.426 | 124.6676 | 124.18 | 124.33 | 7283642.0 |
| 2010-12-15 17:00:00 | SPY | ETF | 124.35 | 124.35 | 124.21 | 124.34 | 164662.0 |
| 2010-12-15 17:30:00 | SPY | ETF | 124.34 | 124.36 | 124.28 | 124.32 | 44564.0 |
| 2010-12-15 18:00:00 | SPY | ETF | 124.31 | 124.31 | 124.06 | 124.08 | 137870.0 |
| 2010-12-15 18:30:00 | SPY | ETF | 124.08 | 124.12 | 124.05 | 124.08 | 123565.0 |
| 2010-12-15 19:00:00 | SPY | ETF | 124.09 | 124.09 | 123.95 | 123.98 | 96467.0 |
| 2010-12-15 19:30:00 | SPY | ETF | 124.01 | 124.12 | 123.98 | 124.12 | 40568.0 |
| 2010-12-15 04:00:00 | QQQ | ETF | 54.25 | 54.25 | 54.25 | 54.25 | 300.0 |
| 2010-12-15 05:30:00 | QQQ | ETF | 54.22 | 54.22 | 54.2 | 54.2 | 200.0 |
| 2010-12-15 06:00:00 | QQQ | ETF | 54.21 | 54.21 | 54.2 | 54.2 | 7000.0 |
| 2010-12-15 06:30:00 | QQQ | ETF | 54.27 | 54.3 | 54.27 | 54.29 | 900.0 |
| 2010-12-15 07:00:00 | QQQ | ETF | 54.3 | 54.31 | 54.3 | 54.31 | 2300.0 |
| 2010-12-15 07:30:00 | QQQ | ETF | 54.32 | 54.38 | 54.32 | 54.34 | 17100.0 |
| 2010-12-15 08:00:00 | QQQ | ETF | 54.33 | 54.41 | 54.31 | 54.32 | 124279.0 |
| 2010-12-15 08:30:00 | QQQ | ETF | 54.33 | 54.42 | 54.27 | 54.32 | 159411.0 |
| 2010-12-15 09:00:00 | QQQ | ETF | 54.32 | 54.41 | 54.3 | 54.33 | 135303.0 |
| 2010-12-15 09:30:00 | QQQ | ETF | 54.37 | 54.44 | 54.3 | 54.43 | 4432155.0 |
| 2010-12-15 10:00:00 | QQQ | ETF | 54.43 | 54.6 | 54.3926 | 54.54 | 6291820.0 |
| 2010-12-15 10:30:00 | QQQ | ETF | 54.545 | 54.7 | 54.545 | 54.63 | 3544102.0 |
| 2010-12-15 11:00:00 | QQQ | ETF | 54.63 | 54.68 | 54.46 | 54.51 | 5043994.0 |
| 2010-12-15 11:30:00 | QQQ | ETF | 54.5164 | 54.52 | 54.39 | 54.48 | 4067086.0 |
| 2010-12-15 12:00:00 | QQQ | ETF | 54.48 | 54.49 | 54.43 | 54.4699 | 1137073.0 |
| 2010-12-15 12:30:00 | QQQ | ETF | 54.469 | 54.469 | 54.2 | 54.23 | 2817222.0 |
| 2010-12-15 13:00:00 | QQQ | ETF | 54.233 | 54.26 | 54.16 | 54.2 | 7365177.0 |
| 2010-12-15 13:30:00 | QQQ | ETF | 54.19 | 54.28 | 54.14 | 54.27 | 2817956.0 |
> showing 50 of 9,065 rows — these rows as CSV