PREVIEW / etf_5min / 2016-01-06

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-01-06.parquet
  size:    1.2 MB
  rows:    52,178

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
2016-01-06 04:00:00	SPY	ETF	199.52	199.81	199.48	199.48	164223.0
2016-01-06 04:05:00	SPY	ETF	199.48	199.5	199.37	199.44	22285.0
2016-01-06 04:10:00	SPY	ETF	199.46	199.54	199.42	199.54	1040.0
2016-01-06 04:15:00	SPY	ETF	199.57	199.57	199.54	199.54	1135.0
2016-01-06 04:20:00	SPY	ETF	199.7	199.81	199.63	199.81	1145.0
2016-01-06 04:25:00	SPY	ETF	199.78	199.85	199.74	199.74	12765.0
2016-01-06 04:30:00	SPY	ETF	199.75	199.75	199.61	199.65	8510.0
2016-01-06 04:35:00	SPY	ETF	199.57	199.67	199.57	199.6	22640.0
2016-01-06 04:40:00	SPY	ETF	199.67	199.69	199.67	199.67	1360.0
2016-01-06 04:45:00	SPY	ETF	199.6	199.6	199.5	199.52	9415.0
2016-01-06 04:50:00	SPY	ETF	199.5	199.56	199.35	199.39	16340.0
2016-01-06 04:55:00	SPY	ETF	199.41	199.59	199.38	199.53	21250.0
2016-01-06 05:00:00	SPY	ETF	199.5	199.59	199.24	199.33	20590.0
2016-01-06 05:05:00	SPY	ETF	199.35	199.38	199.3	199.32	6930.0
2016-01-06 05:10:00	SPY	ETF	199.37	199.37	199.3	199.3	3435.0
2016-01-06 05:15:00	SPY	ETF	199.29	199.32	199.04	199.04	15545.0
2016-01-06 05:20:00	SPY	ETF	199.13	199.17	199.03	199.03	27490.0
2016-01-06 05:25:00	SPY	ETF	199.0	199.0	198.83	198.83	49130.0
2016-01-06 05:30:00	SPY	ETF	198.84	199.0	198.77	198.93	14525.0
2016-01-06 05:35:00	SPY	ETF	198.88	198.95	198.83	198.95	2200.0
2016-01-06 05:40:00	SPY	ETF	198.93	198.95	198.93	198.95	5898.0
2016-01-06 05:45:00	SPY	ETF	198.97	199.04	198.95	198.95	1005.0
2016-01-06 05:50:00	SPY	ETF	198.98	199.0	198.95	198.95	2700.0
2016-01-06 05:55:00	SPY	ETF	198.81	198.84	198.75	198.79	13823.0
2016-01-06 06:00:00	SPY	ETF	198.79	198.79	198.06	198.26	46283.0
2016-01-06 06:05:00	SPY	ETF	198.25	198.46	198.15	198.42	19450.0
2016-01-06 06:10:00	SPY	ETF	198.41	198.54	198.37	198.47	12315.0
2016-01-06 06:15:00	SPY	ETF	198.48	198.51	198.32	198.32	11377.0
2016-01-06 06:20:00	SPY	ETF	198.42	198.5	198.42	198.47	25467.0
2016-01-06 06:25:00	SPY	ETF	198.5	198.53	198.5	198.53	975.0
2016-01-06 06:30:00	SPY	ETF	198.58	198.67	198.43	198.5	13163.0
2016-01-06 06:35:00	SPY	ETF	198.46	198.6	198.46	198.5	6578.0
2016-01-06 06:40:00	SPY	ETF	198.53	198.66	198.53	198.66	13777.0
2016-01-06 06:45:00	SPY	ETF	198.61	198.73	198.56	198.59	16543.0
2016-01-06 06:50:00	SPY	ETF	198.52	198.75	198.52	198.67	62013.0
2016-01-06 06:55:00	SPY	ETF	198.69	198.84	198.69	198.8	28576.0
2016-01-06 07:00:00	SPY	ETF	198.8	198.83	198.55	198.6	124189.0
2016-01-06 07:05:00	SPY	ETF	198.6	198.65	198.5	198.61	85054.0
2016-01-06 07:10:00	SPY	ETF	198.61	198.66	198.54	198.66	78500.0
2016-01-06 07:15:00	SPY	ETF	198.68	198.79	198.58	198.77	105750.0
2016-01-06 07:20:00	SPY	ETF	198.77	198.79	198.7	198.75	39820.0
2016-01-06 07:25:00	SPY	ETF	198.73	198.74	198.61	198.64	80525.0
2016-01-06 07:30:00	SPY	ETF	198.59	198.6	198.38	198.57	70591.0
2016-01-06 07:35:00	SPY	ETF	198.53	198.59	198.36	198.51	138491.0
2016-01-06 07:40:00	SPY	ETF	198.48	198.51	198.32	198.38	54942.0
2016-01-06 07:45:00	SPY	ETF	198.38	198.58	198.37	198.39	67230.0
2016-01-06 07:50:00	SPY	ETF	198.38	198.42	198.16	198.21	125579.0
2016-01-06 07:55:00	SPY	ETF	198.23	198.24	197.87	197.97	124056.0
2016-01-06 08:00:00	SPY	ETF	197.97	198.7901	197.92	198.13	310302.0
2016-01-06 08:05:00	SPY	ETF	198.12	198.18	197.95	197.98	232313.0

> showing 50 of 52,178 rows — these rows as CSV

> unlock the full archive -- $79 one-time