PREVIEW / etf_30min / 2013-08-30
file: by_date/etf_30min/2013/2013-08-30.parquet size: 307 KB rows: 10,513
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-30 04:00:00 | SPY | ETF | 164.47 | 164.47 | 164.27 | 164.3 | 353420.0 |
| 2013-08-30 04:30:00 | SPY | ETF | 164.28 | 164.44 | 164.26 | 164.44 | 54600.0 |
| 2013-08-30 05:00:00 | SPY | ETF | 164.46 | 164.63 | 164.38 | 164.62 | 197290.0 |
| 2013-08-30 05:30:00 | SPY | ETF | 164.6 | 164.63 | 164.54 | 164.56 | 190300.0 |
| 2013-08-30 06:00:00 | SPY | ETF | 164.58 | 164.6 | 164.54 | 164.56 | 11320.0 |
| 2013-08-30 06:30:00 | SPY | ETF | 164.58 | 164.68 | 164.58 | 164.68 | 154150.0 |
| 2013-08-30 07:00:00 | SPY | ETF | 164.68 | 164.68 | 164.6 | 164.63 | 187590.0 |
| 2013-08-30 07:30:00 | SPY | ETF | 164.6 | 164.6 | 164.37 | 164.55 | 416205.0 |
| 2013-08-30 08:00:00 | SPY | ETF | 164.66 | 164.66 | 164.39 | 164.49 | 213992.0 |
| 2013-08-30 08:30:00 | SPY | ETF | 164.48 | 164.56 | 164.25 | 164.39 | 483276.0 |
| 2013-08-30 09:00:00 | SPY | ETF | 164.4 | 164.58 | 164.37 | 164.5 | 680835.0 |
| 2013-08-30 09:30:00 | SPY | ETF | 164.51 | 164.53 | 164.04 | 164.16 | 10102197.0 |
| 2013-08-30 10:00:00 | SPY | ETF | 164.15 | 164.16 | 163.74 | 163.86 | 10017083.0 |
| 2013-08-30 10:30:00 | SPY | ETF | 163.86 | 164.0699 | 163.5499 | 163.66 | 7926611.0 |
| 2013-08-30 11:00:00 | SPY | ETF | 163.65 | 163.91 | 163.57 | 163.67 | 6020034.0 |
| 2013-08-30 11:30:00 | SPY | ETF | 163.66 | 163.739 | 163.44 | 163.56 | 6708974.0 |
| 2013-08-30 12:00:00 | SPY | ETF | 163.56 | 163.84 | 163.5 | 163.78 | 4951320.0 |
| 2013-08-30 12:30:00 | SPY | ETF | 163.789 | 163.8 | 163.6 | 163.76 | 4141189.0 |
| 2013-08-30 13:00:00 | SPY | ETF | 163.76 | 164.08 | 163.2 | 163.84 | 14649890.0 |
| 2013-08-30 13:30:00 | SPY | ETF | 163.85 | 163.97 | 163.55 | 163.56 | 4705151.0 |
| 2013-08-30 14:00:00 | SPY | ETF | 163.56 | 163.69 | 163.45 | 163.6 | 3870172.0 |
| 2013-08-30 14:30:00 | SPY | ETF | 163.6 | 163.95 | 163.58 | 163.85 | 5513827.0 |
| 2013-08-30 15:00:00 | SPY | ETF | 163.85 | 164.0 | 163.73 | 163.84 | 6513992.0 |
| 2013-08-30 15:30:00 | SPY | ETF | 163.84 | 163.84 | 163.17 | 163.57 | 22292300.0 |
| 2013-08-30 16:00:00 | SPY | ETF | 163.58 | 164.2128 | 163.47 | 163.89 | 14588907.0 |
| 2013-08-30 16:30:00 | SPY | ETF | 163.89 | 163.93 | 163.76 | 163.8 | 2419293.0 |
| 2013-08-30 17:00:00 | SPY | ETF | 163.8 | 163.85 | 163.64 | 163.64 | 2770079.0 |
| 2013-08-30 17:30:00 | SPY | ETF | 163.64 | 163.64 | 163.46 | 163.53 | 247602.0 |
| 2013-08-30 18:00:00 | SPY | ETF | 163.53 | 163.53 | 163.38 | 163.4 | 111505.0 |
| 2013-08-30 18:30:00 | SPY | ETF | 163.4 | 163.51 | 163.38 | 163.5 | 50190.0 |
| 2013-08-30 19:00:00 | SPY | ETF | 163.49 | 163.53 | 163.49 | 163.52 | 6940.0 |
| 2013-08-30 19:30:00 | SPY | ETF | 163.52 | 163.58 | 163.51 | 163.54 | 19547.0 |
| 2013-08-30 04:00:00 | QQQ | ETF | 75.95 | 75.97 | 75.87 | 75.89 | 12600.0 |
| 2013-08-30 04:30:00 | QQQ | ETF | 75.87 | 75.97 | 75.87 | 75.97 | 15100.0 |
| 2013-08-30 05:00:00 | QQQ | ETF | 75.99 | 76.05 | 75.95 | 76.05 | 10100.0 |
| 2013-08-30 05:30:00 | QQQ | ETF | 76.07 | 76.07 | 76.03 | 76.05 | 5000.0 |
| 2013-08-30 06:00:00 | QQQ | ETF | 76.05 | 76.05 | 76.04 | 76.04 | 300.0 |
| 2013-08-30 06:30:00 | QQQ | ETF | 76.07 | 76.09 | 76.07 | 76.09 | 2900.0 |
| 2013-08-30 07:00:00 | QQQ | ETF | 76.07 | 76.07 | 76.05 | 76.07 | 1400.0 |
| 2013-08-30 07:30:00 | QQQ | ETF | 76.05 | 76.06 | 75.95 | 76.03 | 24625.0 |
| 2013-08-30 08:00:00 | QQQ | ETF | 76.03 | 76.04 | 75.995 | 76.01 | 119440.0 |
| 2013-08-30 08:30:00 | QQQ | ETF | 76.02 | 76.02 | 75.9 | 75.95 | 151480.0 |
| 2013-08-30 09:00:00 | QQQ | ETF | 75.96 | 76.05 | 75.96 | 76.02 | 140158.0 |
| 2013-08-30 09:30:00 | QQQ | ETF | 76.04 | 76.04 | 75.69 | 75.75 | 3952214.0 |
| 2013-08-30 10:00:00 | QQQ | ETF | 75.745 | 75.75 | 75.54 | 75.58 | 2250764.0 |
| 2013-08-30 10:30:00 | QQQ | ETF | 75.58 | 75.68 | 75.4 | 75.46 | 2026668.0 |
| 2013-08-30 11:00:00 | QQQ | ETF | 75.45 | 75.57 | 75.38 | 75.48 | 1555652.0 |
| 2013-08-30 11:30:00 | QQQ | ETF | 75.48 | 75.49 | 75.33 | 75.41 | 1262313.0 |
| 2013-08-30 12:00:00 | QQQ | ETF | 75.41 | 75.56 | 75.36 | 75.54 | 1493419.0 |
| 2013-08-30 12:30:00 | QQQ | ETF | 75.54 | 75.54 | 75.42 | 75.51 | 996074.0 |
> showing 50 of 10,513 rows — these rows as CSV