PREVIEW / etf_5min / 2018-06-19

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-06-19.parquet
  size:    1.4 MB
  rows:    61,070

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-06-19 04:00:00	SPY	ETF	273.45	273.8	273.3	273.4	21810.0
2018-06-19 04:05:00	SPY	ETF	273.42	273.42	273.3	273.3	2794.0
2018-06-19 04:10:00	SPY	ETF	273.16	273.3	273.1	273.3	7918.0
2018-06-19 04:15:00	SPY	ETF	273.28	273.37	273.25	273.25	5577.0
2018-06-19 04:20:00	SPY	ETF	273.1	273.14	272.95	272.95	8609.0
2018-06-19 04:25:00	SPY	ETF	273.0	273.05	272.81	273.0	12183.0
2018-06-19 04:30:00	SPY	ETF	272.92	272.96	272.86	272.96	7690.0
2018-06-19 04:35:00	SPY	ETF	272.85	272.85	272.8	272.8	745.0
2018-06-19 04:40:00	SPY	ETF	273.06	273.21	272.9	273.21	2939.0
2018-06-19 04:45:00	SPY	ETF	273.23	273.23	273.18	273.18	1345.0
2018-06-19 04:50:00	SPY	ETF	273.19	273.3	273.19	273.3	900.0
2018-06-19 04:55:00	SPY	ETF	273.29	273.44	273.29	273.44	840.0
2018-06-19 05:00:00	SPY	ETF	273.4	273.44	273.37	273.37	3674.0
2018-06-19 05:05:00	SPY	ETF	273.5	273.59	273.5	273.52	2140.0
2018-06-19 05:10:00	SPY	ETF	273.58	273.58	273.48	273.48	1440.0
2018-06-19 05:15:00	SPY	ETF	273.54	273.56	273.48	273.49	1750.0
2018-06-19 05:20:00	SPY	ETF	273.54	273.57	273.48	273.57	3500.0
2018-06-19 05:25:00	SPY	ETF	273.52	273.57	273.52	273.53	6125.0
2018-06-19 05:30:00	SPY	ETF	273.5	273.69	273.5	273.53	4930.0
2018-06-19 05:35:00	SPY	ETF	273.52	273.61	273.52	273.56	2109.0
2018-06-19 05:40:00	SPY	ETF	273.65	273.65	273.57	273.57	1630.0
2018-06-19 05:50:00	SPY	ETF	273.51	273.59	273.51	273.59	3200.0
2018-06-19 05:55:00	SPY	ETF	273.62	273.64	273.61	273.61	3750.0
2018-06-19 06:00:00	SPY	ETF	273.73	273.74	273.65	273.65	9425.0
2018-06-19 06:05:00	SPY	ETF	273.7	273.73	273.7	273.71	1700.0
2018-06-19 06:10:00	SPY	ETF	273.75	273.79	273.73	273.73	9570.0
2018-06-19 06:15:00	SPY	ETF	273.79	273.79	273.79	273.79	1000.0
2018-06-19 06:20:00	SPY	ETF	273.96	274.0	273.86	273.86	3400.0
2018-06-19 06:25:00	SPY	ETF	273.89	273.95	273.87	273.95	4215.0
2018-06-19 06:30:00	SPY	ETF	273.96	273.99	273.8	273.85	19551.0
2018-06-19 06:35:00	SPY	ETF	273.84	273.84	273.78	273.8	29490.0
2018-06-19 06:40:00	SPY	ETF	273.86	273.86	273.67	273.69	61732.0
2018-06-19 06:45:00	SPY	ETF	273.71	273.84	273.7	273.73	6888.0
2018-06-19 06:50:00	SPY	ETF	273.72	273.72	273.6	273.71	10842.0
2018-06-19 06:55:00	SPY	ETF	273.72	273.79	273.72	273.78	3350.0
2018-06-19 07:00:00	SPY	ETF	273.78	273.92	273.78	273.89	70981.0
2018-06-19 07:05:00	SPY	ETF	273.89	273.92	273.8	273.87	29602.0
2018-06-19 07:10:00	SPY	ETF	273.85	273.89	273.75	273.76	13769.0
2018-06-19 07:15:00	SPY	ETF	273.79	273.82	273.66	273.68	27074.0
2018-06-19 07:20:00	SPY	ETF	273.69	273.69	273.5	273.55	71262.0
2018-06-19 07:25:00	SPY	ETF	273.55	273.6	273.36	273.38	102418.0
2018-06-19 07:30:00	SPY	ETF	273.35	273.49	273.25	273.49	108896.0
2018-06-19 07:35:00	SPY	ETF	273.49	273.64	273.4	273.64	33397.0
2018-06-19 07:40:00	SPY	ETF	273.63	273.7	273.63	273.69	17854.0
2018-06-19 07:45:00	SPY	ETF	273.69	273.83	273.6	273.83	31465.0
2018-06-19 07:50:00	SPY	ETF	273.8	274.0	273.8	273.98	28237.0
2018-06-19 07:55:00	SPY	ETF	273.91	274.08	273.91	274.08	66641.0
2018-06-19 08:00:00	SPY	ETF	274.07	274.5	272.55	273.9	219460.0
2018-06-19 08:05:00	SPY	ETF	273.89	274.25	273.88	274.18	124344.0
2018-06-19 08:10:00	SPY	ETF	274.18	274.32	274.17	274.2	86479.0

> showing 50 of 61,070 rows — these rows as CSV

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