PREVIEW / etf_5min / 2013-06-04
file: by_date/etf_5min/2013/2013-06-04.parquet size: 1024 KB rows: 42,651
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 |
|---|---|---|---|---|---|---|---|
| 2013-06-04 04:00:00 | SPY | ETF | 164.1 | 164.17 | 164.1 | 164.17 | 600.0 |
| 2013-06-04 04:05:00 | SPY | ETF | 164.19 | 164.22 | 164.19 | 164.2 | 800.0 |
| 2013-06-04 04:10:00 | SPY | ETF | 164.16 | 164.16 | 164.08 | 164.08 | 600.0 |
| 2013-06-04 04:15:00 | SPY | ETF | 164.09 | 164.16 | 164.09 | 164.12 | 7600.0 |
| 2013-06-04 04:20:00 | SPY | ETF | 164.16 | 164.2 | 164.16 | 164.16 | 600.0 |
| 2013-06-04 04:25:00 | SPY | ETF | 164.12 | 164.12 | 164.08 | 164.12 | 800.0 |
| 2013-06-04 04:30:00 | SPY | ETF | 164.16 | 164.2 | 164.16 | 164.2 | 400.0 |
| 2013-06-04 04:35:00 | SPY | ETF | 164.21 | 164.21 | 164.21 | 164.21 | 200.0 |
| 2013-06-04 04:45:00 | SPY | ETF | 164.24 | 164.28 | 164.24 | 164.24 | 600.0 |
| 2013-06-04 04:50:00 | SPY | ETF | 164.2 | 164.2 | 164.1 | 164.1 | 800.0 |
| 2013-06-04 04:55:00 | SPY | ETF | 164.08 | 164.08 | 164.04 | 164.04 | 400.0 |
| 2013-06-04 05:00:00 | SPY | ETF | 164.08 | 164.12 | 164.06 | 164.12 | 600.0 |
| 2013-06-04 05:05:00 | SPY | ETF | 164.14 | 164.16 | 164.04 | 164.04 | 2300.0 |
| 2013-06-04 05:10:00 | SPY | ETF | 164.05 | 164.05 | 164.01 | 164.05 | 2000.0 |
| 2013-06-04 05:15:00 | SPY | ETF | 164.08 | 164.12 | 164.04 | 164.04 | 900.0 |
| 2013-06-04 05:20:00 | SPY | ETF | 164.08 | 164.08 | 164.04 | 164.04 | 400.0 |
| 2013-06-04 05:25:00 | SPY | ETF | 164.03 | 164.05 | 164.03 | 164.05 | 6000.0 |
| 2013-06-04 05:30:00 | SPY | ETF | 164.0 | 164.08 | 164.0 | 164.08 | 2600.0 |
| 2013-06-04 05:35:00 | SPY | ETF | 164.07 | 164.08 | 164.04 | 164.08 | 13700.0 |
| 2013-06-04 05:40:00 | SPY | ETF | 164.08 | 164.08 | 164.04 | 164.04 | 500.0 |
| 2013-06-04 05:45:00 | SPY | ETF | 164.03 | 164.04 | 164.03 | 164.04 | 500.0 |
| 2013-06-04 05:50:00 | SPY | ETF | 164.08 | 164.12 | 164.08 | 164.12 | 13000.0 |
| 2013-06-04 05:55:00 | SPY | ETF | 164.08 | 164.13 | 164.08 | 164.13 | 12700.0 |
| 2013-06-04 06:05:00 | SPY | ETF | 164.16 | 164.32 | 164.16 | 164.28 | 1300.0 |
| 2013-06-04 06:15:00 | SPY | ETF | 164.28 | 164.28 | 164.2 | 164.23 | 21400.0 |
| 2013-06-04 06:20:00 | SPY | ETF | 164.26 | 164.26 | 164.18 | 164.18 | 8200.0 |
| 2013-06-04 06:30:00 | SPY | ETF | 164.26 | 164.26 | 164.24 | 164.24 | 400.0 |
| 2013-06-04 06:35:00 | SPY | ETF | 164.2 | 164.2 | 164.08 | 164.08 | 1100.0 |
| 2013-06-04 06:40:00 | SPY | ETF | 164.1 | 164.1 | 164.01 | 164.03 | 1600.0 |
| 2013-06-04 06:45:00 | SPY | ETF | 164.03 | 164.09 | 164.03 | 164.06 | 15000.0 |
| 2013-06-04 06:50:00 | SPY | ETF | 164.06 | 164.21 | 164.05 | 164.21 | 35500.0 |
| 2013-06-04 06:55:00 | SPY | ETF | 164.13 | 164.21 | 164.13 | 164.21 | 13700.0 |
| 2013-06-04 07:00:00 | SPY | ETF | 164.21 | 164.21 | 164.13 | 164.16 | 8365.0 |
| 2013-06-04 07:05:00 | SPY | ETF | 164.14 | 164.16 | 164.1 | 164.1 | 5810.0 |
| 2013-06-04 07:10:00 | SPY | ETF | 164.09 | 164.12 | 164.06 | 164.12 | 6300.0 |
| 2013-06-04 07:15:00 | SPY | ETF | 164.08 | 164.08 | 164.08 | 164.08 | 1000.0 |
| 2013-06-04 07:20:00 | SPY | ETF | 164.12 | 164.17 | 164.12 | 164.17 | 1700.0 |
| 2013-06-04 07:25:00 | SPY | ETF | 164.19 | 164.24 | 164.19 | 164.24 | 12900.0 |
| 2013-06-04 07:30:00 | SPY | ETF | 164.21 | 164.21 | 164.15 | 164.19 | 4700.0 |
| 2013-06-04 07:35:00 | SPY | ETF | 164.21 | 164.29 | 164.2 | 164.26 | 9900.0 |
| 2013-06-04 07:40:00 | SPY | ETF | 164.24 | 164.28 | 164.24 | 164.26 | 31600.0 |
| 2013-06-04 07:45:00 | SPY | ETF | 164.28 | 164.29 | 164.26 | 164.26 | 14400.0 |
| 2013-06-04 07:50:00 | SPY | ETF | 164.24 | 164.24 | 164.2 | 164.24 | 16290.0 |
| 2013-06-04 07:55:00 | SPY | ETF | 164.24 | 164.24 | 164.16 | 164.16 | 1400.0 |
| 2013-06-04 08:00:00 | SPY | ETF | 164.19 | 164.29 | 164.08 | 164.26 | 45300.0 |
| 2013-06-04 08:05:00 | SPY | ETF | 164.28 | 164.36 | 164.28 | 164.35 | 15620.0 |
| 2013-06-04 08:10:00 | SPY | ETF | 164.35 | 164.44 | 164.31 | 164.43 | 17140.0 |
| 2013-06-04 08:15:00 | SPY | ETF | 164.42 | 164.44 | 164.37 | 164.44 | 89355.0 |
| 2013-06-04 08:20:00 | SPY | ETF | 164.41 | 164.43 | 164.38 | 164.38 | 57492.0 |
| 2013-06-04 08:25:00 | SPY | ETF | 164.38 | 164.45 | 164.38 | 164.45 | 13350.0 |
> showing 50 of 42,651 rows — these rows as CSV