PREVIEW / etf_30min / 2015-12-18
file: by_date/etf_30min/2015/2015-12-18.parquet size: 401 KB rows: 13,492
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-18 04:00:00 | SPY | ETF | 202.96 | 202.96 | 201.95 | 202.28 | 34442.0 |
| 2015-12-18 04:30:00 | SPY | ETF | 202.19 | 202.45 | 201.98 | 202.45 | 25568.0 |
| 2015-12-18 05:00:00 | SPY | ETF | 202.4 | 202.44 | 202.17 | 202.44 | 19754.0 |
| 2015-12-18 05:30:00 | SPY | ETF | 202.37 | 202.89 | 202.33 | 202.85 | 56781.0 |
| 2015-12-18 06:00:00 | SPY | ETF | 202.73 | 202.84 | 202.41 | 202.64 | 41382.0 |
| 2015-12-18 06:30:00 | SPY | ETF | 202.64 | 202.65 | 202.01 | 202.06 | 170259.0 |
| 2015-12-18 07:00:00 | SPY | ETF | 202.16 | 202.36 | 201.74 | 201.98 | 340008.0 |
| 2015-12-18 07:30:00 | SPY | ETF | 202.0 | 202.21 | 201.92 | 201.99 | 582814.0 |
| 2015-12-18 08:00:00 | SPY | ETF | 202.0 | 202.72 | 201.77 | 202.65 | 1039193.0 |
| 2015-12-18 08:30:00 | SPY | ETF | 202.64 | 202.73 | 202.32 | 202.67 | 766352.0 |
| 2015-12-18 09:00:00 | SPY | ETF | 202.69 | 203.5 | 202.58 | 202.74 | 3312949.0 |
| 2015-12-18 09:30:00 | SPY | ETF | 202.77 | 202.93 | 202.17 | 202.48 | 25038031.0 |
| 2015-12-18 10:00:00 | SPY | ETF | 202.48 | 202.61 | 201.57 | 201.8 | 19795416.0 |
| 2015-12-18 10:30:00 | SPY | ETF | 201.79 | 202.0 | 201.27 | 201.97 | 15324756.0 |
| 2015-12-18 11:00:00 | SPY | ETF | 201.96 | 202.3 | 201.75 | 201.905 | 11343802.0 |
| 2015-12-18 11:30:00 | SPY | ETF | 201.88 | 202.12 | 201.42 | 201.54 | 12321975.0 |
| 2015-12-18 12:00:00 | SPY | ETF | 201.53 | 201.77 | 201.07 | 201.235 | 14617588.0 |
| 2015-12-18 12:30:00 | SPY | ETF | 201.2365 | 201.245 | 200.79 | 200.94 | 11844155.0 |
| 2015-12-18 13:00:00 | SPY | ETF | 200.9626 | 201.47 | 200.89 | 201.03 | 11656575.0 |
| 2015-12-18 13:30:00 | SPY | ETF | 201.03 | 201.44 | 200.86 | 201.29 | 10726327.0 |
| 2015-12-18 14:00:00 | SPY | ETF | 201.295 | 201.93 | 201.23 | 201.855 | 11066066.0 |
| 2015-12-18 14:30:00 | SPY | ETF | 201.88 | 201.8999 | 201.06 | 201.11 | 14246130.0 |
| 2015-12-18 15:00:00 | SPY | ETF | 201.11 | 201.406 | 200.39 | 200.76 | 22868756.0 |
| 2015-12-18 15:30:00 | SPY | ETF | 200.76 | 201.17 | 199.96 | 199.96 | 32376236.0 |
| 2015-12-18 16:00:00 | SPY | ETF | 199.96 | 201.71 | 199.67 | 199.8 | 19332066.0 |
| 2015-12-18 16:30:00 | SPY | ETF | 199.82 | 200.066 | 199.8 | 200.02 | 5321664.0 |
| 2015-12-18 17:00:00 | SPY | ETF | 200.03 | 200.05 | 199.96 | 200.05 | 761183.0 |
| 2015-12-18 17:30:00 | SPY | ETF | 200.02 | 200.05 | 199.63 | 199.72 | 189571.0 |
| 2015-12-18 18:00:00 | SPY | ETF | 199.76 | 199.81 | 199.67 | 199.75 | 54726.0 |
| 2015-12-18 18:30:00 | SPY | ETF | 199.77 | 199.85 | 199.73 | 199.73 | 123554.0 |
| 2015-12-18 19:00:00 | SPY | ETF | 199.72 | 199.76 | 199.66 | 199.69 | 70070.0 |
| 2015-12-18 19:30:00 | SPY | ETF | 199.69 | 199.74 | 199.66 | 199.73 | 38123.0 |
| 2015-12-18 04:00:00 | QQQ | ETF | 111.27 | 111.31 | 111.08 | 111.16 | 14265.0 |
| 2015-12-18 04:30:00 | QQQ | ETF | 111.11 | 111.18 | 111.09 | 111.18 | 18750.0 |
| 2015-12-18 05:00:00 | QQQ | ETF | 111.11 | 111.22 | 111.1 | 111.22 | 6800.0 |
| 2015-12-18 05:30:00 | QQQ | ETF | 111.25 | 111.55 | 111.25 | 111.55 | 6200.0 |
| 2015-12-18 06:00:00 | QQQ | ETF | 111.35 | 111.38 | 111.35 | 111.38 | 1100.0 |
| 2015-12-18 06:30:00 | QQQ | ETF | 111.4 | 111.4 | 111.13 | 111.21 | 6541.0 |
| 2015-12-18 07:00:00 | QQQ | ETF | 111.11 | 111.34 | 111.09 | 111.26 | 9200.0 |
| 2015-12-18 07:30:00 | QQQ | ETF | 111.22 | 111.37 | 111.21 | 111.21 | 209734.0 |
| 2015-12-18 08:00:00 | QQQ | ETF | 111.23 | 111.6 | 111.13 | 111.55 | 104759.0 |
| 2015-12-18 08:30:00 | QQQ | ETF | 111.5 | 111.6 | 111.42 | 111.57 | 46383.0 |
| 2015-12-18 09:00:00 | QQQ | ETF | 111.56 | 111.93 | 111.49 | 111.57 | 535680.0 |
| 2015-12-18 09:30:00 | QQQ | ETF | 111.58 | 111.88 | 111.2301 | 111.62 | 8737584.0 |
| 2015-12-18 10:00:00 | QQQ | ETF | 111.62 | 111.65 | 110.99 | 111.08 | 4576735.0 |
| 2015-12-18 10:30:00 | QQQ | ETF | 111.08 | 111.18 | 110.71 | 111.17 | 3671930.0 |
| 2015-12-18 11:00:00 | QQQ | ETF | 111.17 | 111.48 | 111.0622 | 111.19 | 2269401.0 |
| 2015-12-18 11:30:00 | QQQ | ETF | 111.18 | 111.34 | 110.91 | 111.0 | 1533493.0 |
| 2015-12-18 12:00:00 | QQQ | ETF | 110.999 | 111.11 | 110.64 | 110.705 | 2590904.0 |
| 2015-12-18 12:30:00 | QQQ | ETF | 110.7 | 110.7 | 110.365 | 110.385 | 2151511.0 |
> showing 50 of 13,492 rows — these rows as CSV