PREVIEW / etf_30min / 2015-01-13
file: by_date/etf_30min/2015/2015-01-13.parquet size: 390 KB rows: 13,011
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-01-13 04:00:00 | SPY | ETF | 202.82 | 203.0 | 202.82 | 203.0 | 10245.0 |
| 2015-01-13 04:30:00 | SPY | ETF | 202.94 | 203.55 | 202.9 | 203.53 | 30425.0 |
| 2015-01-13 05:00:00 | SPY | ETF | 203.45 | 203.47 | 203.07 | 203.11 | 13060.0 |
| 2015-01-13 05:30:00 | SPY | ETF | 203.16 | 203.39 | 203.16 | 203.39 | 4400.0 |
| 2015-01-13 06:00:00 | SPY | ETF | 203.17 | 203.43 | 203.17 | 203.34 | 13650.0 |
| 2015-01-13 06:30:00 | SPY | ETF | 203.41 | 203.91 | 203.41 | 203.9 | 44021.0 |
| 2015-01-13 07:00:00 | SPY | ETF | 203.9 | 203.9 | 203.6 | 203.6 | 254628.0 |
| 2015-01-13 07:30:00 | SPY | ETF | 203.61 | 203.76 | 203.48 | 203.49 | 476356.0 |
| 2015-01-13 08:00:00 | SPY | ETF | 203.63 | 203.9 | 203.21 | 203.34 | 1165917.0 |
| 2015-01-13 08:30:00 | SPY | ETF | 203.34 | 203.66 | 203.34 | 203.57 | 464142.0 |
| 2015-01-13 09:00:00 | SPY | ETF | 203.57 | 204.27 | 203.56 | 204.13 | 1766493.0 |
| 2015-01-13 09:30:00 | SPY | ETF | 204.12 | 205.42 | 204.1 | 205.34 | 22316902.0 |
| 2015-01-13 10:00:00 | SPY | ETF | 205.34 | 205.48 | 204.92 | 204.99 | 10248901.0 |
| 2015-01-13 10:30:00 | SPY | ETF | 205.0 | 205.4 | 204.8899 | 205.16 | 8732390.0 |
| 2015-01-13 11:00:00 | SPY | ETF | 205.15 | 205.19 | 204.64 | 204.87 | 10818976.0 |
| 2015-01-13 11:30:00 | SPY | ETF | 204.88 | 204.95 | 204.46 | 204.53 | 9389051.0 |
| 2015-01-13 12:00:00 | SPY | ETF | 204.52 | 204.62 | 203.75 | 203.895 | 8446597.0 |
| 2015-01-13 12:30:00 | SPY | ETF | 203.895 | 203.9 | 203.45 | 203.84 | 8752100.0 |
| 2015-01-13 13:00:00 | SPY | ETF | 203.84 | 204.0 | 202.67 | 202.8299 | 9780132.0 |
| 2015-01-13 13:30:00 | SPY | ETF | 202.82 | 203.372 | 201.07 | 201.58 | 21721497.0 |
| 2015-01-13 14:00:00 | SPY | ETF | 201.585 | 201.59 | 200.51 | 201.385 | 24542681.0 |
| 2015-01-13 14:30:00 | SPY | ETF | 201.38 | 201.82 | 200.87 | 200.89 | 18502942.0 |
| 2015-01-13 15:00:00 | SPY | ETF | 200.9 | 201.74 | 200.71 | 201.25 | 15755776.0 |
| 2015-01-13 15:30:00 | SPY | ETF | 201.26 | 204.69 | 201.24 | 202.07 | 26691279.0 |
| 2015-01-13 16:00:00 | SPY | ETF | 202.07 | 202.32 | 201.83 | 202.07 | 8786045.0 |
| 2015-01-13 16:30:00 | SPY | ETF | 202.07 | 202.26 | 202.05 | 202.23 | 4215440.0 |
| 2015-01-13 17:00:00 | SPY | ETF | 202.27 | 202.28 | 202.13 | 202.13 | 74704.0 |
| 2015-01-13 17:30:00 | SPY | ETF | 202.13 | 202.16 | 202.12 | 202.13 | 10993.0 |
| 2015-01-13 18:00:00 | SPY | ETF | 202.1 | 202.21 | 201.87 | 202.21 | 99748.0 |
| 2015-01-13 18:30:00 | SPY | ETF | 202.19 | 202.28 | 202.08 | 202.09 | 31028.0 |
| 2015-01-13 19:00:00 | SPY | ETF | 202.09 | 202.3 | 202.0 | 202.0 | 24347.0 |
| 2015-01-13 19:30:00 | SPY | ETF | 201.98 | 202.02 | 201.93 | 201.97 | 23367.0 |
| 2015-01-13 04:00:00 | QQQ | ETF | 101.73 | 101.73 | 101.73 | 101.73 | 5000.0 |
| 2015-01-13 05:00:00 | QQQ | ETF | 101.9 | 101.9 | 101.9 | 101.9 | 100.0 |
| 2015-01-13 05:30:00 | QQQ | ETF | 102.0 | 102.0 | 102.0 | 102.0 | 700.0 |
| 2015-01-13 06:00:00 | QQQ | ETF | 102.0 | 102.14 | 102.0 | 102.14 | 1200.0 |
| 2015-01-13 06:30:00 | QQQ | ETF | 102.1 | 102.38 | 102.1 | 102.35 | 30750.0 |
| 2015-01-13 07:00:00 | QQQ | ETF | 102.31 | 102.34 | 102.21 | 102.21 | 12714.0 |
| 2015-01-13 07:30:00 | QQQ | ETF | 102.25 | 102.29 | 102.19 | 102.2 | 11977.0 |
| 2015-01-13 08:00:00 | QQQ | ETF | 102.17 | 102.32 | 102.06 | 102.12 | 37514.0 |
| 2015-01-13 08:30:00 | QQQ | ETF | 102.12 | 102.32 | 101.55 | 102.3 | 34599.0 |
| 2015-01-13 09:00:00 | QQQ | ETF | 102.32 | 102.61 | 102.32 | 102.54 | 491969.0 |
| 2015-01-13 09:30:00 | QQQ | ETF | 102.54 | 103.52 | 102.54 | 103.48 | 5850822.0 |
| 2015-01-13 10:00:00 | QQQ | ETF | 103.49 | 103.55 | 103.35 | 103.45 | 2826702.0 |
| 2015-01-13 10:30:00 | QQQ | ETF | 103.45 | 103.62 | 103.381 | 103.49 | 1438081.0 |
| 2015-01-13 11:00:00 | QQQ | ETF | 103.49 | 103.51 | 103.21 | 103.419 | 1376047.0 |
| 2015-01-13 11:30:00 | QQQ | ETF | 103.415 | 103.46 | 103.18 | 103.229 | 1705699.0 |
| 2015-01-13 12:00:00 | QQQ | ETF | 103.24 | 103.27 | 102.809 | 102.86 | 2268112.0 |
| 2015-01-13 12:30:00 | QQQ | ETF | 102.85 | 102.86 | 102.57 | 102.75 | 1338336.0 |
| 2015-01-13 13:00:00 | QQQ | ETF | 102.75 | 102.87 | 102.12 | 102.22 | 1882131.0 |
> showing 50 of 13,011 rows — these rows as CSV