PREVIEW / etf_5min / 2018-10-23

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-10-23.parquet
  size:    1.6 MB
  rows:    66,512

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
2018-10-23 04:00:00	SPY	ETF	272.11	272.11	271.79	271.79	13230.0
2018-10-23 04:05:00	SPY	ETF	271.8	271.84	271.75	271.75	9264.0
2018-10-23 04:10:00	SPY	ETF	271.77	271.81	271.56	271.61	9745.0
2018-10-23 04:15:00	SPY	ETF	271.59	271.62	271.48	271.54	15195.0
2018-10-23 04:20:00	SPY	ETF	271.57	271.77	271.57	271.77	17090.0
2018-10-23 04:25:00	SPY	ETF	271.74	271.77	271.62	271.62	5233.0
2018-10-23 04:30:00	SPY	ETF	271.66	271.92	271.51	271.89	10600.0
2018-10-23 04:35:00	SPY	ETF	271.89	271.89	271.69	271.69	8050.0
2018-10-23 04:40:00	SPY	ETF	271.71	271.93	271.67	271.9	10100.0
2018-10-23 04:45:00	SPY	ETF	271.97	271.98	271.74	271.74	17430.0
2018-10-23 04:50:00	SPY	ETF	271.78	271.78	271.6	271.6	5900.0
2018-10-23 04:55:00	SPY	ETF	271.68	271.68	271.64	271.66	5600.0
2018-10-23 05:00:00	SPY	ETF	271.65	271.65	271.37	271.4	9920.0
2018-10-23 05:05:00	SPY	ETF	271.4	271.5	271.4	271.48	2370.0
2018-10-23 05:10:00	SPY	ETF	271.45	271.45	271.18	271.25	25308.0
2018-10-23 05:15:00	SPY	ETF	271.18	271.2	270.86	270.93	23574.0
2018-10-23 05:20:00	SPY	ETF	270.91	271.09	270.85	270.85	18795.0
2018-10-23 05:25:00	SPY	ETF	270.99	271.09	270.91	271.01	11712.0
2018-10-23 05:30:00	SPY	ETF	270.91	271.07	270.8	271.0	16530.0
2018-10-23 05:35:00	SPY	ETF	271.0	271.29	270.95	271.29	11856.0
2018-10-23 05:40:00	SPY	ETF	271.28	271.32	271.11	271.14	23855.0
2018-10-23 05:45:00	SPY	ETF	271.21	271.31	271.21	271.3	7850.0
2018-10-23 05:50:00	SPY	ETF	271.34	271.62	271.33	271.5	17372.0
2018-10-23 05:55:00	SPY	ETF	271.53	271.63	271.31	271.63	10171.0
2018-10-23 06:00:00	SPY	ETF	271.64	271.64	271.39	271.49	13028.0
2018-10-23 06:05:00	SPY	ETF	271.48	271.6	271.4	271.48	22785.0
2018-10-23 06:10:00	SPY	ETF	271.5	271.57	271.46	271.57	10150.0
2018-10-23 06:15:00	SPY	ETF	271.58	271.67	271.44	271.46	4005.0
2018-10-23 06:20:00	SPY	ETF	271.44	271.74	271.35	271.64	10063.0
2018-10-23 06:25:00	SPY	ETF	271.53	271.59	271.45	271.59	4135.0
2018-10-23 06:30:00	SPY	ETF	271.59	271.59	271.23	271.33	12699.0
2018-10-23 06:35:00	SPY	ETF	271.39	271.61	271.35	271.58	17030.0
2018-10-23 06:40:00	SPY	ETF	271.58	271.64	271.38	271.63	8490.0
2018-10-23 06:45:00	SPY	ETF	271.61	271.69	271.53	271.56	15441.0
2018-10-23 06:50:00	SPY	ETF	271.69	272.04	271.69	271.86	47537.0
2018-10-23 06:55:00	SPY	ETF	271.88	271.92	271.76	271.76	10747.0
2018-10-23 07:00:00	SPY	ETF	271.71	271.94	271.71	271.85	41963.0
2018-10-23 07:05:00	SPY	ETF	271.81	271.88	271.6	271.62	87215.0
2018-10-23 07:10:00	SPY	ETF	271.65	271.81	271.6	271.67	32754.0
2018-10-23 07:15:00	SPY	ETF	271.71	271.74	271.6	271.66	82560.0
2018-10-23 07:20:00	SPY	ETF	271.67	271.82	271.41	271.54	76468.0
2018-10-23 07:25:00	SPY	ETF	271.52	271.56	271.41	271.53	16620.0
2018-10-23 07:30:00	SPY	ETF	271.5	271.56	271.3	271.31	92055.0
2018-10-23 07:35:00	SPY	ETF	271.31	271.31	270.69	270.93	138590.0
2018-10-23 07:40:00	SPY	ETF	270.92	271.0	270.5	270.73	239005.0
2018-10-23 07:45:00	SPY	ETF	270.76	271.1	270.66	271.01	169227.0
2018-10-23 07:50:00	SPY	ETF	270.99	271.3	270.89	271.22	138412.0
2018-10-23 07:55:00	SPY	ETF	271.19	271.44	271.19	271.32	104385.0
2018-10-23 08:00:00	SPY	ETF	271.7701	272.9	270.75	271.37	268268.0
2018-10-23 08:05:00	SPY	ETF	271.36	271.4	271.13	271.18	114109.0

> showing 50 of 66,512 rows — these rows as CSV

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