PREVIEW / etf_30min / 2011-05-10
file: by_date/etf_30min/2011/2011-05-10.parquet size: 281 KB rows: 9,353
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-10 04:00:00 | SPY | ETF | 134.95 | 135.0 | 134.8 | 134.99 | 5650.0 |
| 2011-05-10 04:30:00 | SPY | ETF | 135.1 | 135.1 | 135.1 | 135.1 | 200.0 |
| 2011-05-10 05:00:00 | SPY | ETF | 135.18 | 135.3 | 135.18 | 135.3 | 4300.0 |
| 2011-05-10 05:30:00 | SPY | ETF | 135.27 | 135.27 | 135.17 | 135.17 | 1500.0 |
| 2011-05-10 06:00:00 | SPY | ETF | 135.26 | 135.34 | 135.26 | 135.34 | 42400.0 |
| 2011-05-10 06:30:00 | SPY | ETF | 135.39 | 135.42 | 135.33 | 135.35 | 46700.0 |
| 2011-05-10 07:00:00 | SPY | ETF | 135.33 | 135.38 | 135.26 | 135.28 | 68458.0 |
| 2011-05-10 07:30:00 | SPY | ETF | 135.3 | 135.44 | 135.28 | 135.4 | 238803.0 |
| 2011-05-10 08:00:00 | SPY | ETF | 135.4 | 135.53 | 135.29 | 135.44 | 950076.0 |
| 2011-05-10 08:30:00 | SPY | ETF | 135.45 | 135.5 | 135.27 | 135.32 | 487032.0 |
| 2011-05-10 09:00:00 | SPY | ETF | 135.32 | 135.33 | 135.08 | 135.17 | 1128070.0 |
| 2011-05-10 09:30:00 | SPY | ETF | 135.17 | 135.43 | 135.0 | 135.39 | 13302462.0 |
| 2011-05-10 10:00:00 | SPY | ETF | 135.4 | 135.66 | 135.32 | 135.549 | 11688675.0 |
| 2011-05-10 10:30:00 | SPY | ETF | 135.54 | 135.65 | 135.45 | 135.56 | 6161995.0 |
| 2011-05-10 11:00:00 | SPY | ETF | 135.56 | 135.64 | 135.29 | 135.35 | 6008856.0 |
| 2011-05-10 11:30:00 | SPY | ETF | 135.35 | 135.56 | 135.29 | 135.45 | 5404819.0 |
| 2011-05-10 12:00:00 | SPY | ETF | 135.45 | 135.5 | 135.36 | 135.448 | 3180643.0 |
| 2011-05-10 12:30:00 | SPY | ETF | 135.43 | 135.58 | 135.42 | 135.45 | 3290156.0 |
| 2011-05-10 13:00:00 | SPY | ETF | 135.44 | 135.46 | 135.3 | 135.455 | 5154451.0 |
| 2011-05-10 13:30:00 | SPY | ETF | 135.46 | 135.57 | 135.38 | 135.55 | 2925285.0 |
| 2011-05-10 14:00:00 | SPY | ETF | 135.56 | 135.62 | 135.42 | 135.53 | 4000172.0 |
| 2011-05-10 14:30:00 | SPY | ETF | 135.54 | 135.94 | 135.5 | 135.94 | 9879241.0 |
| 2011-05-10 15:00:00 | SPY | ETF | 135.93 | 136.11 | 135.87 | 136.03 | 10915825.0 |
| 2011-05-10 15:30:00 | SPY | ETF | 136.03 | 136.04 | 135.77 | 135.89 | 17128753.0 |
| 2011-05-10 16:00:00 | SPY | ETF | 135.89 | 136.02 | 135.76 | 135.87 | 8255321.0 |
| 2011-05-10 16:30:00 | SPY | ETF | 135.85 | 135.94 | 135.77 | 135.89 | 604404.0 |
| 2011-05-10 17:00:00 | SPY | ETF | 135.91 | 135.95 | 135.9 | 135.95 | 72101.0 |
| 2011-05-10 17:30:00 | SPY | ETF | 135.95 | 135.97 | 135.9 | 135.97 | 77225.0 |
| 2011-05-10 18:00:00 | SPY | ETF | 135.97 | 135.99 | 135.87 | 135.96 | 85642.0 |
| 2011-05-10 18:30:00 | SPY | ETF | 135.95 | 136.03 | 135.94 | 135.99 | 43250.0 |
| 2011-05-10 19:00:00 | SPY | ETF | 135.99 | 136.02 | 135.98 | 136.02 | 14507.0 |
| 2011-05-10 19:30:00 | SPY | ETF | 136.01 | 136.03 | 135.99 | 136.03 | 17134.0 |
| 2011-05-10 04:00:00 | QQQ | ETF | 58.68 | 58.68 | 58.6 | 58.6 | 9000.0 |
| 2011-05-10 05:00:00 | QQQ | ETF | 58.85 | 58.89 | 58.85 | 58.88 | 3200.0 |
| 2011-05-10 06:30:00 | QQQ | ETF | 58.94 | 58.94 | 58.94 | 58.94 | 300.0 |
| 2011-05-10 07:00:00 | QQQ | ETF | 58.98 | 58.98 | 58.94 | 58.94 | 3950.0 |
| 2011-05-10 07:30:00 | QQQ | ETF | 58.96 | 59.01 | 58.96 | 58.99 | 63513.0 |
| 2011-05-10 08:00:00 | QQQ | ETF | 58.99 | 59.02 | 58.95 | 58.97 | 95881.0 |
| 2011-05-10 08:30:00 | QQQ | ETF | 58.98 | 58.99 | 58.89 | 58.9 | 183688.0 |
| 2011-05-10 09:00:00 | QQQ | ETF | 58.91 | 58.91 | 58.8 | 58.88 | 323307.0 |
| 2011-05-10 09:30:00 | QQQ | ETF | 58.89 | 59.08 | 58.775 | 59.07 | 4994644.0 |
| 2011-05-10 10:00:00 | QQQ | ETF | 59.08 | 59.1 | 58.96 | 58.99 | 3360609.0 |
| 2011-05-10 10:30:00 | QQQ | ETF | 58.995 | 59.06 | 58.9099 | 58.99 | 2180141.0 |
| 2011-05-10 11:00:00 | QQQ | ETF | 58.99 | 59.04 | 58.86 | 58.88 | 1896286.0 |
| 2011-05-10 11:30:00 | QQQ | ETF | 58.89 | 59.0 | 58.885 | 58.94 | 1254206.0 |
| 2011-05-10 12:00:00 | QQQ | ETF | 58.9449 | 58.98 | 58.9 | 58.93 | 1544188.0 |
| 2011-05-10 12:30:00 | QQQ | ETF | 58.92 | 58.98 | 58.89 | 58.9 | 2994294.0 |
| 2011-05-10 13:00:00 | QQQ | ETF | 58.91 | 58.95 | 58.84 | 58.94 | 1768603.0 |
| 2011-05-10 13:30:00 | QQQ | ETF | 58.94 | 59.01 | 58.89 | 58.9984 | 2032030.0 |
| 2011-05-10 14:00:00 | QQQ | ETF | 59.0 | 59.03 | 58.9405 | 59.0 | 1226287.0 |
> showing 50 of 9,353 rows — these rows as CSV