PREVIEW / etf_30min / 2010-11-11
file: by_date/etf_30min/2010/2010-11-11.parquet size: 264 KB rows: 8,903
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-11-11 04:00:00 | SPY | ETF | 121.2 | 121.46 | 121.2 | 121.31 | 54796.0 |
| 2010-11-11 04:30:00 | SPY | ETF | 121.33 | 121.48 | 121.33 | 121.48 | 4200.0 |
| 2010-11-11 05:00:00 | SPY | ETF | 121.4 | 121.4 | 121.4 | 121.4 | 200.0 |
| 2010-11-11 05:30:00 | SPY | ETF | 121.52 | 121.6 | 121.52 | 121.6 | 10750.0 |
| 2010-11-11 06:00:00 | SPY | ETF | 121.62 | 121.62 | 121.4 | 121.4 | 11500.0 |
| 2010-11-11 06:30:00 | SPY | ETF | 121.4 | 121.4 | 121.27 | 121.33 | 83700.0 |
| 2010-11-11 07:00:00 | SPY | ETF | 121.31 | 121.41 | 121.25 | 121.36 | 69500.0 |
| 2010-11-11 07:30:00 | SPY | ETF | 121.36 | 121.38 | 121.07 | 121.13 | 187120.0 |
| 2010-11-11 08:00:00 | SPY | ETF | 121.27 | 121.33 | 121.1 | 121.3 | 989826.0 |
| 2010-11-11 08:30:00 | SPY | ETF | 121.27 | 121.27 | 121.02 | 121.02 | 702996.0 |
| 2010-11-11 09:00:00 | SPY | ETF | 121.03 | 121.19 | 121.0 | 121.05 | 919643.0 |
| 2010-11-11 09:30:00 | SPY | ETF | 121.05 | 121.15 | 120.68 | 121.04 | 23862468.0 |
| 2010-11-11 10:00:00 | SPY | ETF | 121.04 | 121.42 | 120.89 | 121.24 | 14637697.0 |
| 2010-11-11 10:30:00 | SPY | ETF | 121.24 | 121.26 | 120.91 | 121.2 | 13250720.0 |
| 2010-11-11 11:00:00 | SPY | ETF | 121.21 | 121.28 | 120.92 | 120.98 | 10543138.0 |
| 2010-11-11 11:30:00 | SPY | ETF | 120.97 | 121.29 | 120.96 | 121.21 | 8782705.0 |
| 2010-11-11 12:00:00 | SPY | ETF | 121.21 | 121.4 | 121.18 | 121.31 | 6382156.0 |
| 2010-11-11 12:30:00 | SPY | ETF | 121.32 | 121.38 | 121.16 | 121.22 | 5480143.0 |
| 2010-11-11 13:00:00 | SPY | ETF | 121.22 | 121.3725 | 121.12 | 121.27 | 6341097.0 |
| 2010-11-11 13:30:00 | SPY | ETF | 121.27 | 121.58 | 121.26 | 121.51 | 7715008.0 |
| 2010-11-11 14:00:00 | SPY | ETF | 121.5 | 121.7 | 121.43 | 121.64 | 5839119.0 |
| 2010-11-11 14:30:00 | SPY | ETF | 121.65 | 121.82 | 121.51 | 121.5885 | 7820427.0 |
| 2010-11-11 15:00:00 | SPY | ETF | 121.58 | 121.69 | 121.44 | 121.58 | 8485366.0 |
| 2010-11-11 15:30:00 | SPY | ETF | 121.58 | 121.65 | 121.31 | 121.65 | 26364489.0 |
| 2010-11-11 16:00:00 | SPY | ETF | 121.65 | 121.67 | 120.995 | 121.56 | 5720954.0 |
| 2010-11-11 16:30:00 | SPY | ETF | 121.56 | 121.6156 | 121.45 | 121.53 | 314894.0 |
| 2010-11-11 17:00:00 | SPY | ETF | 121.52 | 121.66 | 121.52 | 121.61 | 1453334.0 |
| 2010-11-11 17:30:00 | SPY | ETF | 121.61 | 121.65 | 121.61 | 121.61 | 92750.0 |
| 2010-11-11 18:00:00 | SPY | ETF | 121.61 | 121.66 | 121.42 | 121.45 | 126276.0 |
| 2010-11-11 18:30:00 | SPY | ETF | 121.44 | 121.51 | 121.27 | 121.32 | 56218.0 |
| 2010-11-11 19:00:00 | SPY | ETF | 121.34 | 121.54 | 121.34 | 121.46 | 111204.0 |
| 2010-11-11 19:30:00 | SPY | ETF | 121.51 | 121.58 | 121.37 | 121.38 | 66233.0 |
| 2010-11-11 04:30:00 | QQQ | ETF | 53.12 | 53.12 | 53.08 | 53.08 | 400.0 |
| 2010-11-11 05:00:00 | QQQ | ETF | 53.08 | 53.08 | 53.08 | 53.08 | 2000.0 |
| 2010-11-11 06:00:00 | QQQ | ETF | 53.1 | 53.1 | 53.1 | 53.1 | 300.0 |
| 2010-11-11 06:30:00 | QQQ | ETF | 53.13 | 53.13 | 53.05 | 53.05 | 11800.0 |
| 2010-11-11 07:00:00 | QQQ | ETF | 53.09 | 53.11 | 53.06 | 53.09 | 70962.0 |
| 2010-11-11 07:30:00 | QQQ | ETF | 53.09 | 53.09 | 52.93 | 52.94 | 521354.0 |
| 2010-11-11 08:00:00 | QQQ | ETF | 52.95 | 53.03 | 52.94 | 53.02 | 362062.0 |
| 2010-11-11 08:30:00 | QQQ | ETF | 53.01 | 53.01 | 52.86 | 52.89 | 554535.0 |
| 2010-11-11 09:00:00 | QQQ | ETF | 52.89 | 52.93 | 52.87 | 52.89 | 2837226.0 |
| 2010-11-11 09:30:00 | QQQ | ETF | 52.89 | 52.98 | 52.66 | 52.969 | 16372383.0 |
| 2010-11-11 10:00:00 | QQQ | ETF | 52.96 | 53.22 | 52.88 | 53.2 | 10086763.0 |
| 2010-11-11 10:30:00 | QQQ | ETF | 53.2 | 53.2 | 53.02 | 53.17 | 6527882.0 |
| 2010-11-11 11:00:00 | QQQ | ETF | 53.1799 | 53.2 | 52.99 | 53.0 | 3914319.0 |
| 2010-11-11 11:30:00 | QQQ | ETF | 53.0 | 53.195 | 53.0 | 53.16 | 2460793.0 |
| 2010-11-11 12:00:00 | QQQ | ETF | 53.16 | 53.33 | 53.15 | 53.29 | 3423944.0 |
| 2010-11-11 12:30:00 | QQQ | ETF | 53.29 | 53.31 | 53.21 | 53.2462 | 1899176.0 |
| 2010-11-11 13:00:00 | QQQ | ETF | 53.24 | 53.3 | 53.19 | 53.25 | 2331593.0 |
| 2010-11-11 13:30:00 | QQQ | ETF | 53.25 | 53.45 | 53.25 | 53.41 | 3351922.0 |
> showing 50 of 8,903 rows — these rows as CSV