PREVIEW / etf_5min / 2014-03-31
file: by_date/etf_5min/2014/2014-03-31.parquet size: 1002 KB rows: 43,272
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-03-31 04:00:00 | SPY | ETF | 186.14 | 186.25 | 186.14 | 186.25 | 1642.0 |
| 2014-03-31 04:05:00 | SPY | ETF | 186.22 | 186.22 | 186.22 | 186.22 | 495.0 |
| 2014-03-31 04:15:00 | SPY | ETF | 186.16 | 186.16 | 186.16 | 186.16 | 200.0 |
| 2014-03-31 04:25:00 | SPY | ETF | 186.21 | 186.21 | 186.21 | 186.21 | 178.0 |
| 2014-03-31 04:40:00 | SPY | ETF | 186.25 | 186.25 | 186.25 | 186.25 | 201.0 |
| 2014-03-31 04:45:00 | SPY | ETF | 186.23 | 186.28 | 186.23 | 186.28 | 4000.0 |
| 2014-03-31 04:50:00 | SPY | ETF | 186.26 | 186.26 | 186.26 | 186.26 | 1200.0 |
| 2014-03-31 04:55:00 | SPY | ETF | 186.22 | 186.22 | 186.22 | 186.22 | 35200.0 |
| 2014-03-31 05:00:00 | SPY | ETF | 186.21 | 186.26 | 186.21 | 186.26 | 3218.0 |
| 2014-03-31 05:05:00 | SPY | ETF | 186.22 | 186.22 | 186.22 | 186.22 | 1000.0 |
| 2014-03-31 05:15:00 | SPY | ETF | 186.21 | 186.21 | 186.16 | 186.17 | 1401.0 |
| 2014-03-31 05:20:00 | SPY | ETF | 186.11 | 186.11 | 186.11 | 186.11 | 600.0 |
| 2014-03-31 05:25:00 | SPY | ETF | 186.16 | 186.16 | 186.14 | 186.15 | 3192.0 |
| 2014-03-31 05:30:00 | SPY | ETF | 186.16 | 186.21 | 186.16 | 186.21 | 2503.0 |
| 2014-03-31 05:35:00 | SPY | ETF | 186.18 | 186.18 | 186.16 | 186.16 | 1247.0 |
| 2014-03-31 05:45:00 | SPY | ETF | 186.18 | 186.21 | 186.18 | 186.21 | 700.0 |
| 2014-03-31 05:50:00 | SPY | ETF | 186.21 | 186.21 | 186.21 | 186.21 | 500.0 |
| 2014-03-31 05:55:00 | SPY | ETF | 186.21 | 186.21 | 186.21 | 186.21 | 700.0 |
| 2014-03-31 06:00:00 | SPY | ETF | 186.24 | 186.24 | 186.12 | 186.12 | 6555.0 |
| 2014-03-31 06:05:00 | SPY | ETF | 186.12 | 186.12 | 186.02 | 186.11 | 16700.0 |
| 2014-03-31 06:10:00 | SPY | ETF | 186.1 | 186.1 | 186.1 | 186.1 | 3230.0 |
| 2014-03-31 06:15:00 | SPY | ETF | 186.1 | 186.11 | 186.1 | 186.11 | 7000.0 |
| 2014-03-31 06:20:00 | SPY | ETF | 186.07 | 186.07 | 186.07 | 186.07 | 200.0 |
| 2014-03-31 06:25:00 | SPY | ETF | 186.16 | 186.16 | 186.16 | 186.16 | 100.0 |
| 2014-03-31 06:30:00 | SPY | ETF | 186.11 | 186.11 | 186.11 | 186.11 | 100.0 |
| 2014-03-31 06:35:00 | SPY | ETF | 186.1 | 186.1 | 186.02 | 186.02 | 11097.0 |
| 2014-03-31 06:40:00 | SPY | ETF | 186.04 | 186.05 | 186.02 | 186.05 | 52955.0 |
| 2014-03-31 06:45:00 | SPY | ETF | 186.04 | 186.05 | 186.02 | 186.02 | 46000.0 |
| 2014-03-31 06:50:00 | SPY | ETF | 186.04 | 186.14 | 186.04 | 186.11 | 40700.0 |
| 2014-03-31 06:55:00 | SPY | ETF | 186.1 | 186.12 | 186.1 | 186.12 | 4610.0 |
| 2014-03-31 07:00:00 | SPY | ETF | 186.13 | 186.18 | 186.12 | 186.15 | 46074.0 |
| 2014-03-31 07:05:00 | SPY | ETF | 186.18 | 186.18 | 186.16 | 186.18 | 5200.0 |
| 2014-03-31 07:10:00 | SPY | ETF | 186.14 | 186.16 | 186.13 | 186.13 | 5901.0 |
| 2014-03-31 07:15:00 | SPY | ETF | 186.16 | 186.16 | 186.13 | 186.15 | 7000.0 |
| 2014-03-31 07:20:00 | SPY | ETF | 186.17 | 186.17 | 186.08 | 186.08 | 9111.0 |
| 2014-03-31 07:25:00 | SPY | ETF | 186.08 | 186.12 | 186.08 | 186.12 | 71600.0 |
| 2014-03-31 07:30:00 | SPY | ETF | 186.16 | 186.2 | 186.15 | 186.2 | 20724.0 |
| 2014-03-31 07:35:00 | SPY | ETF | 186.17 | 186.18 | 186.14 | 186.18 | 1514.0 |
| 2014-03-31 07:40:00 | SPY | ETF | 186.18 | 186.24 | 186.17 | 186.24 | 17200.0 |
| 2014-03-31 07:45:00 | SPY | ETF | 186.24 | 186.27 | 186.23 | 186.26 | 56147.0 |
| 2014-03-31 07:50:00 | SPY | ETF | 186.26 | 186.28 | 186.25 | 186.25 | 14400.0 |
| 2014-03-31 07:55:00 | SPY | ETF | 186.27 | 186.34 | 186.27 | 186.34 | 89001.0 |
| 2014-03-31 08:00:00 | SPY | ETF | 186.31 | 186.33 | 186.13 | 186.28 | 52007.0 |
| 2014-03-31 08:05:00 | SPY | ETF | 186.28 | 186.32 | 186.28 | 186.31 | 47154.0 |
| 2014-03-31 08:10:00 | SPY | ETF | 186.3 | 186.35 | 186.3 | 186.31 | 19051.0 |
| 2014-03-31 08:15:00 | SPY | ETF | 186.29 | 186.29 | 186.24 | 186.28 | 34023.0 |
| 2014-03-31 08:20:00 | SPY | ETF | 186.26 | 186.29 | 186.26 | 186.26 | 4978.0 |
| 2014-03-31 08:25:00 | SPY | ETF | 186.29 | 186.31 | 186.26 | 186.26 | 21227.0 |
| 2014-03-31 08:30:00 | SPY | ETF | 186.26 | 186.49 | 186.26 | 186.45 | 97716.0 |
| 2014-03-31 08:35:00 | SPY | ETF | 186.43 | 186.5 | 186.41 | 186.49 | 112634.0 |
> showing 50 of 43,272 rows — these rows as CSV