PREVIEW / etf_5min / 2014-01-10
file: by_date/etf_5min/2014/2014-01-10.parquet size: 1.0 MB rows: 43,811
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-10 04:00:00 | SPY | ETF | 183.8 | 184.07 | 183.8 | 184.07 | 927.0 |
| 2014-01-10 04:15:00 | SPY | ETF | 184.09 | 184.12 | 184.09 | 184.11 | 351.0 |
| 2014-01-10 04:30:00 | SPY | ETF | 184.12 | 184.12 | 184.12 | 184.12 | 191.0 |
| 2014-01-10 04:35:00 | SPY | ETF | 184.13 | 184.13 | 184.13 | 184.13 | 101.0 |
| 2014-01-10 04:40:00 | SPY | ETF | 184.14 | 184.14 | 184.14 | 184.14 | 200.0 |
| 2014-01-10 04:45:00 | SPY | ETF | 184.14 | 184.14 | 184.14 | 184.14 | 75000.0 |
| 2014-01-10 05:05:00 | SPY | ETF | 184.09 | 184.09 | 184.09 | 184.09 | 10000.0 |
| 2014-01-10 05:10:00 | SPY | ETF | 184.12 | 184.12 | 184.12 | 184.12 | 100.0 |
| 2014-01-10 05:15:00 | SPY | ETF | 184.17 | 184.17 | 184.17 | 184.17 | 200.0 |
| 2014-01-10 05:20:00 | SPY | ETF | 184.12 | 184.12 | 184.12 | 184.12 | 400.0 |
| 2014-01-10 05:30:00 | SPY | ETF | 184.11 | 184.11 | 184.11 | 184.11 | 262.0 |
| 2014-01-10 05:35:00 | SPY | ETF | 184.1 | 184.12 | 184.1 | 184.12 | 1137.0 |
| 2014-01-10 05:45:00 | SPY | ETF | 184.14 | 184.21 | 184.14 | 184.18 | 1321.0 |
| 2014-01-10 05:55:00 | SPY | ETF | 184.25 | 184.25 | 184.25 | 184.25 | 100.0 |
| 2014-01-10 06:00:00 | SPY | ETF | 184.23 | 184.23 | 184.23 | 184.23 | 101.0 |
| 2014-01-10 06:05:00 | SPY | ETF | 184.25 | 184.25 | 184.24 | 184.24 | 350.0 |
| 2014-01-10 06:10:00 | SPY | ETF | 184.26 | 184.27 | 184.25 | 184.25 | 538.0 |
| 2014-01-10 06:15:00 | SPY | ETF | 184.27 | 184.29 | 184.27 | 184.29 | 1093.0 |
| 2014-01-10 06:20:00 | SPY | ETF | 184.27 | 184.27 | 184.27 | 184.27 | 168.0 |
| 2014-01-10 06:25:00 | SPY | ETF | 184.28 | 184.28 | 184.24 | 184.25 | 1100.0 |
| 2014-01-10 06:30:00 | SPY | ETF | 184.26 | 184.27 | 184.25 | 184.27 | 16177.0 |
| 2014-01-10 06:35:00 | SPY | ETF | 184.27 | 184.29 | 184.27 | 184.29 | 6394.0 |
| 2014-01-10 06:40:00 | SPY | ETF | 184.3 | 184.32 | 184.3 | 184.3 | 5717.0 |
| 2014-01-10 06:45:00 | SPY | ETF | 184.28 | 184.28 | 184.28 | 184.28 | 160.0 |
| 2014-01-10 06:50:00 | SPY | ETF | 184.24 | 184.24 | 184.24 | 184.24 | 100.0 |
| 2014-01-10 06:55:00 | SPY | ETF | 184.24 | 184.24 | 184.22 | 184.22 | 5305.0 |
| 2014-01-10 07:00:00 | SPY | ETF | 184.25 | 184.25 | 184.25 | 184.25 | 1900.0 |
| 2014-01-10 07:05:00 | SPY | ETF | 184.25 | 184.26 | 184.22 | 184.23 | 4400.0 |
| 2014-01-10 07:10:00 | SPY | ETF | 184.25 | 184.31 | 184.25 | 184.31 | 152189.0 |
| 2014-01-10 07:15:00 | SPY | ETF | 184.32 | 184.34 | 184.32 | 184.34 | 9360.0 |
| 2014-01-10 07:20:00 | SPY | ETF | 184.32 | 184.38 | 184.32 | 184.37 | 93200.0 |
| 2014-01-10 07:25:00 | SPY | ETF | 184.37 | 184.38 | 184.35 | 184.35 | 5600.0 |
| 2014-01-10 07:30:00 | SPY | ETF | 184.38 | 184.38 | 184.35 | 184.35 | 180450.0 |
| 2014-01-10 07:35:00 | SPY | ETF | 184.38 | 184.42 | 184.38 | 184.42 | 475101.0 |
| 2014-01-10 07:40:00 | SPY | ETF | 184.39 | 184.39 | 184.34 | 184.34 | 65949.0 |
| 2014-01-10 07:45:00 | SPY | ETF | 184.34 | 184.34 | 184.31 | 184.31 | 51600.0 |
| 2014-01-10 07:50:00 | SPY | ETF | 184.31 | 184.42 | 184.31 | 184.39 | 192939.0 |
| 2014-01-10 07:55:00 | SPY | ETF | 184.4 | 184.45 | 184.4 | 184.415 | 179931.0 |
| 2014-01-10 08:00:00 | SPY | ETF | 184.42 | 184.5 | 184.25 | 184.49 | 156259.0 |
| 2014-01-10 08:05:00 | SPY | ETF | 184.5 | 184.57 | 184.46 | 184.46 | 328762.0 |
| 2014-01-10 08:10:00 | SPY | ETF | 184.47 | 184.51 | 184.44 | 184.49 | 70350.0 |
| 2014-01-10 08:15:00 | SPY | ETF | 184.49 | 184.53 | 184.45 | 184.45 | 86533.0 |
| 2014-01-10 08:20:00 | SPY | ETF | 184.44 | 184.44 | 184.38 | 184.41 | 103222.0 |
| 2014-01-10 08:25:00 | SPY | ETF | 184.41 | 184.52 | 184.36 | 184.36 | 184154.0 |
| 2014-01-10 08:30:00 | SPY | ETF | 184.35 | 184.41 | 183.71 | 183.73 | 2416076.0 |
| 2014-01-10 08:35:00 | SPY | ETF | 183.74 | 183.85 | 183.26 | 183.8 | 1744082.0 |
| 2014-01-10 08:40:00 | SPY | ETF | 183.8 | 184.18 | 183.75 | 184.16 | 1225940.0 |
| 2014-01-10 08:45:00 | SPY | ETF | 184.16 | 184.18 | 184.03 | 184.12 | 494369.0 |
| 2014-01-10 08:50:00 | SPY | ETF | 184.13 | 184.25 | 184.05 | 184.17 | 1462913.0 |
| 2014-01-10 08:55:00 | SPY | ETF | 184.16 | 184.21 | 184.08 | 184.17 | 133401.0 |
> showing 50 of 43,811 rows — these rows as CSV