PREVIEW / etf_5min / 2019-03-20

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-03-20.parquet
  size:    1.4 MB
  rows:    62,792

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
2019-03-20 04:00:00	SPY	ETF	282.43	282.53	282.33	282.53	1401.0
2019-03-20 04:05:00	SPY	ETF	282.48	282.48	282.48	282.48	201.0
2019-03-20 04:15:00	SPY	ETF	282.55	282.55	282.52	282.52	600.0
2019-03-20 04:20:00	SPY	ETF	282.49	282.53	282.46	282.53	1981.0
2019-03-20 04:25:00	SPY	ETF	282.54	282.55	282.5	282.52	1688.0
2019-03-20 04:30:00	SPY	ETF	282.53	282.69	282.51	282.69	2290.0
2019-03-20 04:35:00	SPY	ETF	282.71	282.75	282.68	282.71	2721.0
2019-03-20 04:40:00	SPY	ETF	282.72	282.76	282.72	282.75	2045.0
2019-03-20 04:45:00	SPY	ETF	282.73	282.73	282.73	282.73	100.0
2019-03-20 04:55:00	SPY	ETF	282.69	282.73	282.69	282.73	2183.0
2019-03-20 05:00:00	SPY	ETF	282.67	282.67	282.6	282.6	805.0
2019-03-20 05:05:00	SPY	ETF	282.49	282.55	282.49	282.54	4000.0
2019-03-20 05:10:00	SPY	ETF	282.47	282.47	282.47	282.47	500.0
2019-03-20 05:20:00	SPY	ETF	282.54	282.57	282.54	282.57	800.0
2019-03-20 05:25:00	SPY	ETF	282.52	282.52	282.52	282.52	300.0
2019-03-20 05:30:00	SPY	ETF	282.54	282.54	282.47	282.47	1400.0
2019-03-20 05:35:00	SPY	ETF	282.47	282.47	282.41	282.42	700.0
2019-03-20 05:40:00	SPY	ETF	282.42	282.42	282.37	282.42	1900.0
2019-03-20 05:45:00	SPY	ETF	282.4	282.46	282.4	282.46	2700.0
2019-03-20 05:50:00	SPY	ETF	282.49	282.49	282.49	282.49	300.0
2019-03-20 05:55:00	SPY	ETF	282.36	282.36	282.36	282.36	900.0
2019-03-20 06:05:00	SPY	ETF	282.4	282.44	282.38	282.44	1800.0
2019-03-20 06:10:00	SPY	ETF	282.34	282.34	282.34	282.34	500.0
2019-03-20 06:15:00	SPY	ETF	282.29	282.29	282.24	282.24	501.0
2019-03-20 06:20:00	SPY	ETF	282.18	282.18	282.18	282.18	100.0
2019-03-20 06:25:00	SPY	ETF	282.23	282.26	282.21	282.24	1900.0
2019-03-20 06:30:00	SPY	ETF	282.25	282.25	282.13	282.19	2100.0
2019-03-20 06:40:00	SPY	ETF	282.2	282.24	282.2	282.21	5200.0
2019-03-20 06:45:00	SPY	ETF	282.24	282.24	282.13	282.13	2037.0
2019-03-20 06:50:00	SPY	ETF	282.11	282.12	282.01	282.01	45506.0
2019-03-20 06:55:00	SPY	ETF	282.0	282.03	281.98	282.03	10350.0
2019-03-20 07:00:00	SPY	ETF	282.06	282.09	282.06	282.09	3630.0
2019-03-20 07:05:00	SPY	ETF	282.04	282.06	282.0	282.06	3826.0
2019-03-20 07:10:00	SPY	ETF	282.03	282.05	281.9	281.9	5485.0
2019-03-20 07:15:00	SPY	ETF	281.89	282.03	281.89	282.03	15730.0
2019-03-20 07:20:00	SPY	ETF	282.02	282.02	281.95	281.97	2229.0
2019-03-20 07:25:00	SPY	ETF	282.01	282.02	282.01	282.02	440.0
2019-03-20 07:30:00	SPY	ETF	282.02	282.04	282.02	282.03	5021.0
2019-03-20 07:35:00	SPY	ETF	282.03	282.05	281.95	282.0	4149.0
2019-03-20 07:40:00	SPY	ETF	282.02	282.02	281.97	281.99	4417.0
2019-03-20 07:45:00	SPY	ETF	282.01	282.01	281.95	281.99	5440.0
2019-03-20 07:50:00	SPY	ETF	282.0	282.05	281.99	282.05	18820.0
2019-03-20 07:55:00	SPY	ETF	282.08	282.25	282.07	282.24	7090.0
2019-03-20 08:00:00	SPY	ETF	282.29	282.34	281.95	282.31	28194.0
2019-03-20 08:05:00	SPY	ETF	282.33	282.36	282.32	282.33	20998.0
2019-03-20 08:10:00	SPY	ETF	282.35	282.42	282.33	282.42	10553.0
2019-03-20 08:15:00	SPY	ETF	282.44	282.45	282.38	282.4	20075.0
2019-03-20 08:20:00	SPY	ETF	282.42	282.43	282.28	282.28	18223.0
2019-03-20 08:25:00	SPY	ETF	282.25	282.31	282.23	282.3	12566.0
2019-03-20 08:30:00	SPY	ETF	282.29	282.33	282.25	282.25	6491.0

> showing 50 of 62,792 rows — these rows as CSV

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