PREVIEW / etf_30min / 2010-12-17
file: by_date/etf_30min/2010/2010-12-17.parquet size: 267 KB rows: 8,910
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-17 04:00:00 | SPY | ETF | 124.74 | 124.74 | 124.2 | 124.24 | 15665.0 |
| 2010-12-17 04:30:00 | SPY | ETF | 124.27 | 124.27 | 124.27 | 124.27 | 200.0 |
| 2010-12-17 05:00:00 | SPY | ETF | 124.28 | 124.28 | 124.17 | 124.17 | 999.0 |
| 2010-12-17 05:30:00 | SPY | ETF | 124.15 | 124.15 | 124.05 | 124.08 | 1600.0 |
| 2010-12-17 06:00:00 | SPY | ETF | 124.12 | 124.15 | 124.1 | 124.12 | 6900.0 |
| 2010-12-17 06:30:00 | SPY | ETF | 124.13 | 124.17 | 124.05 | 124.1 | 17900.0 |
| 2010-12-17 07:00:00 | SPY | ETF | 124.07 | 124.15 | 123.96 | 124.0 | 102090.0 |
| 2010-12-17 07:30:00 | SPY | ETF | 123.98 | 124.23 | 123.95 | 124.14 | 147450.0 |
| 2010-12-17 08:00:00 | SPY | ETF | 124.16 | 124.2 | 124.03 | 124.05 | 458889.0 |
| 2010-12-17 08:30:00 | SPY | ETF | 124.06 | 124.22 | 124.03 | 124.16 | 816303.0 |
| 2010-12-17 09:00:00 | SPY | ETF | 124.16 | 124.82 | 124.03 | 124.07 | 1317690.0 |
| 2010-12-17 09:30:00 | SPY | ETF | 124.08 | 124.11 | 123.91 | 124.025 | 16554425.0 |
| 2010-12-17 10:00:00 | SPY | ETF | 124.03 | 124.13 | 123.85 | 124.09 | 11677493.0 |
| 2010-12-17 10:30:00 | SPY | ETF | 124.09 | 124.12 | 123.82 | 124.0 | 10871302.0 |
| 2010-12-17 11:00:00 | SPY | ETF | 124.005 | 124.071 | 123.94 | 124.0398 | 10997319.0 |
| 2010-12-17 11:30:00 | SPY | ETF | 124.04 | 124.15 | 124.035 | 124.07 | 5298911.0 |
| 2010-12-17 12:00:00 | SPY | ETF | 124.08 | 124.13 | 124.06 | 124.1 | 3017002.0 |
| 2010-12-17 12:30:00 | SPY | ETF | 124.0999 | 124.17 | 124.08 | 124.15 | 2982737.0 |
| 2010-12-17 13:00:00 | SPY | ETF | 124.15 | 124.35 | 124.15 | 124.305 | 7101078.0 |
| 2010-12-17 13:30:00 | SPY | ETF | 124.3001 | 124.46 | 124.28 | 124.38 | 5927521.0 |
| 2010-12-17 14:00:00 | SPY | ETF | 124.38 | 124.455 | 124.33 | 124.41 | 4048272.0 |
| 2010-12-17 14:30:00 | SPY | ETF | 124.41 | 124.44 | 124.35 | 124.4 | 4395187.0 |
| 2010-12-17 15:00:00 | SPY | ETF | 124.4 | 124.44 | 124.24 | 124.2799 | 7709797.0 |
| 2010-12-17 15:30:00 | SPY | ETF | 124.2701 | 124.35 | 124.12 | 124.34 | 20635716.0 |
| 2010-12-17 16:00:00 | SPY | ETF | 124.32 | 124.3893 | 123.995 | 124.15 | 18244925.0 |
| 2010-12-17 16:30:00 | SPY | ETF | 124.14 | 124.32 | 124.13 | 124.23 | 5305451.0 |
| 2010-12-17 17:00:00 | SPY | ETF | 124.23 | 124.3 | 124.14 | 124.16 | 67224.0 |
| 2010-12-17 17:30:00 | SPY | ETF | 124.16 | 124.25 | 123.8 | 123.8 | 388463.0 |
| 2010-12-17 18:00:00 | SPY | ETF | 123.9 | 124.38 | 123.9 | 124.05 | 72351.0 |
| 2010-12-17 18:30:00 | SPY | ETF | 124.05 | 124.2 | 124.02 | 124.14 | 54894.0 |
| 2010-12-17 19:00:00 | SPY | ETF | 124.17 | 124.19 | 124.13 | 124.18 | 4601.0 |
| 2010-12-17 19:30:00 | SPY | ETF | 124.15 | 124.19 | 124.11 | 124.17 | 7914.0 |
| 2010-12-17 04:00:00 | QQQ | ETF | 54.54 | 54.54 | 54.46 | 54.46 | 8911.0 |
| 2010-12-17 04:30:00 | QQQ | ETF | 54.33 | 54.33 | 54.33 | 54.33 | 1400.0 |
| 2010-12-17 05:00:00 | QQQ | ETF | 54.33 | 54.43 | 54.3 | 54.3 | 2635.0 |
| 2010-12-17 05:30:00 | QQQ | ETF | 54.26 | 54.33 | 54.21 | 54.3 | 1087.0 |
| 2010-12-17 06:00:00 | QQQ | ETF | 54.25 | 54.25 | 54.25 | 54.25 | 465.0 |
| 2010-12-17 06:30:00 | QQQ | ETF | 54.29 | 54.29 | 54.26 | 54.29 | 4700.0 |
| 2010-12-17 07:00:00 | QQQ | ETF | 54.21 | 54.29 | 54.21 | 54.25 | 32763.0 |
| 2010-12-17 07:30:00 | QQQ | ETF | 54.26 | 54.41 | 54.23 | 54.38 | 387352.0 |
| 2010-12-17 08:00:00 | QQQ | ETF | 54.44 | 54.47 | 54.42 | 54.46 | 195103.0 |
| 2010-12-17 08:30:00 | QQQ | ETF | 54.44 | 54.51 | 54.44 | 54.5 | 110630.0 |
| 2010-12-17 09:00:00 | QQQ | ETF | 54.5 | 54.56 | 54.5 | 54.54 | 741353.0 |
| 2010-12-17 09:30:00 | QQQ | ETF | 54.54 | 54.55 | 54.44 | 54.5 | 5291183.0 |
| 2010-12-17 10:00:00 | QQQ | ETF | 54.49 | 54.55 | 54.41 | 54.521 | 3381470.0 |
| 2010-12-17 10:30:00 | QQQ | ETF | 54.53 | 54.55 | 54.42 | 54.5001 | 3323440.0 |
| 2010-12-17 11:00:00 | QQQ | ETF | 54.51 | 54.56 | 54.49 | 54.55 | 2486120.0 |
| 2010-12-17 11:30:00 | QQQ | ETF | 54.55 | 54.61 | 54.54 | 54.5699 | 2049635.0 |
| 2010-12-17 12:00:00 | QQQ | ETF | 54.57 | 54.6 | 54.55 | 54.57 | 2004958.0 |
| 2010-12-17 12:30:00 | QQQ | ETF | 54.56 | 54.6 | 54.55 | 54.59 | 1314037.0 |
> showing 50 of 8,910 rows — these rows as CSV