PREVIEW / etf_30min / 2012-01-30
file: by_date/etf_30min/2012/2012-01-30.parquet size: 290 KB rows: 9,784
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-30 04:00:00 | SPY | ETF | 131.08 | 131.08 | 130.68 | 130.73 | 3730.0 |
| 2012-01-30 04:30:00 | SPY | ETF | 130.75 | 130.78 | 130.7 | 130.7 | 800.0 |
| 2012-01-30 05:00:00 | SPY | ETF | 130.81 | 130.85 | 130.69 | 130.85 | 52500.0 |
| 2012-01-30 05:30:00 | SPY | ETF | 130.9 | 130.99 | 130.85 | 130.92 | 4975.0 |
| 2012-01-30 06:00:00 | SPY | ETF | 130.86 | 130.9 | 130.84 | 130.9 | 13400.0 |
| 2012-01-30 06:30:00 | SPY | ETF | 130.94 | 131.02 | 130.94 | 131.01 | 47350.0 |
| 2012-01-30 07:00:00 | SPY | ETF | 130.98 | 130.98 | 130.76 | 130.79 | 87072.0 |
| 2012-01-30 07:30:00 | SPY | ETF | 130.82 | 130.88 | 130.65 | 130.75 | 215226.0 |
| 2012-01-30 08:00:00 | SPY | ETF | 130.77 | 130.87 | 130.65 | 130.77 | 824308.0 |
| 2012-01-30 08:30:00 | SPY | ETF | 130.75 | 130.88 | 130.39 | 130.41 | 1052483.0 |
| 2012-01-30 09:00:00 | SPY | ETF | 130.41 | 130.6 | 130.37 | 130.51 | 1183671.0 |
| 2012-01-30 09:30:00 | SPY | ETF | 130.51 | 130.55 | 130.15 | 130.42 | 20797797.0 |
| 2012-01-30 10:00:00 | SPY | ETF | 130.41 | 130.46 | 130.06 | 130.21 | 13456004.0 |
| 2012-01-30 10:30:00 | SPY | ETF | 130.2 | 130.61 | 130.18 | 130.52 | 9690547.0 |
| 2012-01-30 11:00:00 | SPY | ETF | 130.53 | 130.82 | 130.525 | 130.73 | 10711433.0 |
| 2012-01-30 11:30:00 | SPY | ETF | 130.73 | 130.87 | 130.63 | 130.73 | 7937183.0 |
| 2012-01-30 12:00:00 | SPY | ETF | 130.71 | 130.89 | 130.71 | 130.85 | 8096138.0 |
| 2012-01-30 12:30:00 | SPY | ETF | 130.85 | 130.88 | 130.68 | 130.8 | 4171228.0 |
| 2012-01-30 13:00:00 | SPY | ETF | 130.8 | 130.88 | 130.61 | 130.88 | 5957194.0 |
| 2012-01-30 13:30:00 | SPY | ETF | 130.88 | 131.24 | 130.84 | 131.13 | 9366216.0 |
| 2012-01-30 14:00:00 | SPY | ETF | 131.13 | 131.38 | 131.06 | 131.28 | 7158390.0 |
| 2012-01-30 14:30:00 | SPY | ETF | 131.29 | 131.44 | 131.17 | 131.24 | 6134693.0 |
| 2012-01-30 15:00:00 | SPY | ETF | 131.24 | 131.32 | 131.09 | 131.31 | 8418345.0 |
| 2012-01-30 15:30:00 | SPY | ETF | 131.31 | 131.38 | 131.02 | 131.36 | 17279524.0 |
| 2012-01-30 16:00:00 | SPY | ETF | 131.37 | 131.42 | 130.5 | 131.38 | 10169960.0 |
| 2012-01-30 16:30:00 | SPY | ETF | 131.36 | 131.43 | 131.32 | 131.38 | 1306977.0 |
| 2012-01-30 17:00:00 | SPY | ETF | 131.37 | 131.43 | 131.34 | 131.38 | 71725.0 |
| 2012-01-30 17:30:00 | SPY | ETF | 131.39 | 131.42 | 131.38 | 131.41 | 13960.0 |
| 2012-01-30 18:00:00 | SPY | ETF | 131.4 | 131.4 | 131.34 | 131.37 | 140439.0 |
| 2012-01-30 18:30:00 | SPY | ETF | 131.36 | 131.46 | 131.34 | 131.45 | 35724.0 |
| 2012-01-30 19:00:00 | SPY | ETF | 131.45 | 131.55 | 131.39 | 131.53 | 166228.0 |
| 2012-01-30 19:30:00 | SPY | ETF | 131.53 | 131.76 | 131.52 | 131.72 | 221778.0 |
| 2012-01-30 04:00:00 | QQQ | ETF | 60.04 | 60.04 | 59.82 | 59.82 | 510.0 |
| 2012-01-30 04:30:00 | QQQ | ETF | 59.88 | 59.88 | 59.88 | 59.88 | 500.0 |
| 2012-01-30 05:00:00 | QQQ | ETF | 59.9 | 59.93 | 59.9 | 59.93 | 200.0 |
| 2012-01-30 06:00:00 | QQQ | ETF | 59.95 | 59.95 | 59.95 | 59.95 | 100.0 |
| 2012-01-30 06:30:00 | QQQ | ETF | 59.93 | 59.93 | 59.93 | 59.93 | 100.0 |
| 2012-01-30 07:00:00 | QQQ | ETF | 59.98 | 59.99 | 59.92 | 59.92 | 8650.0 |
| 2012-01-30 07:30:00 | QQQ | ETF | 59.91 | 59.95 | 59.88 | 59.93 | 17053.0 |
| 2012-01-30 08:00:00 | QQQ | ETF | 59.93 | 59.96 | 59.87 | 59.89 | 191271.0 |
| 2012-01-30 08:30:00 | QQQ | ETF | 59.92 | 59.93 | 59.77 | 59.77 | 264164.0 |
| 2012-01-30 09:00:00 | QQQ | ETF | 59.8 | 59.92 | 59.77 | 59.89 | 68083.0 |
| 2012-01-30 09:30:00 | QQQ | ETF | 59.88 | 59.98 | 59.72 | 59.84 | 5624301.0 |
| 2012-01-30 10:00:00 | QQQ | ETF | 59.84 | 59.86 | 59.66 | 59.74 | 4952079.0 |
| 2012-01-30 10:30:00 | QQQ | ETF | 59.75 | 60.1 | 59.74 | 60.0899 | 2962351.0 |
| 2012-01-30 11:00:00 | QQQ | ETF | 60.09 | 60.29 | 60.09 | 60.25 | 3281865.0 |
| 2012-01-30 11:30:00 | QQQ | ETF | 60.25 | 60.356 | 60.21 | 60.2401 | 2389449.0 |
| 2012-01-30 12:00:00 | QQQ | ETF | 60.25 | 60.35 | 60.2305 | 60.32 | 2126997.0 |
| 2012-01-30 12:30:00 | QQQ | ETF | 60.32 | 60.34 | 60.21 | 60.27 | 1101783.0 |
| 2012-01-30 13:00:00 | QQQ | ETF | 60.27 | 60.34 | 60.18 | 60.34 | 1540219.0 |
> showing 50 of 9,784 rows — these rows as CSV