PREVIEW / etf_5min / 2020-03-10

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-10.parquet
  size:    2.0 MB
  rows:    87,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
2020-03-10 04:00:00	SPY	ETF	281.96	282.36	281.69	282.17	29432.0
2020-03-10 04:05:00	SPY	ETF	281.93	283.42	281.89	283.34	23413.0
2020-03-10 04:10:00	SPY	ETF	283.01	283.01	281.24	281.38	35835.0
2020-03-10 04:15:00	SPY	ETF	281.32	282.64	281.32	282.64	8664.0
2020-03-10 04:20:00	SPY	ETF	282.59	283.39	282.26	283.39	17321.0
2020-03-10 04:25:00	SPY	ETF	283.49	283.8	283.18	283.5	14151.0
2020-03-10 04:30:00	SPY	ETF	283.6	284.0	283.37	283.83	19567.0
2020-03-10 04:35:00	SPY	ETF	283.73	284.29	283.73	284.29	17453.0
2020-03-10 04:40:00	SPY	ETF	284.35	285.13	284.35	285.07	21162.0
2020-03-10 04:45:00	SPY	ETF	285.05	285.14	284.7	284.83	10535.0
2020-03-10 04:50:00	SPY	ETF	284.94	285.42	284.61	285.42	20853.0
2020-03-10 04:55:00	SPY	ETF	285.16	286.04	285.1	285.9	36252.0
2020-03-10 05:00:00	SPY	ETF	285.9	286.1	285.52	286.06	31583.0
2020-03-10 05:05:00	SPY	ETF	286.05	286.05	285.65	285.7	13333.0
2020-03-10 05:10:00	SPY	ETF	285.71	285.71	285.1	285.33	8079.0
2020-03-10 05:15:00	SPY	ETF	285.43	286.05	285.42	286.05	7603.0
2020-03-10 05:20:00	SPY	ETF	285.95	286.88	285.86	286.31	34814.0
2020-03-10 05:25:00	SPY	ETF	286.31	286.53	286.26	286.4	13587.0
2020-03-10 05:30:00	SPY	ETF	286.34	286.82	286.3	286.49	8381.0
2020-03-10 05:35:00	SPY	ETF	286.53	287.56	286.53	287.53	23542.0
2020-03-10 05:40:00	SPY	ETF	287.38	287.9	287.38	287.45	20984.0
2020-03-10 05:45:00	SPY	ETF	287.32	288.26	287.32	288.08	20955.0
2020-03-10 05:50:00	SPY	ETF	288.03	288.13	287.67	287.75	58746.0
2020-03-10 05:55:00	SPY	ETF	287.74	288.33	287.67	287.91	50496.0
2020-03-10 06:00:00	SPY	ETF	287.96	287.96	287.01	287.4	48874.0
2020-03-10 06:05:00	SPY	ETF	287.54	287.74	287.43	287.65	38324.0
2020-03-10 06:10:00	SPY	ETF	287.61	288.24	287.61	287.99	56926.0
2020-03-10 06:15:00	SPY	ETF	288.2	288.2	287.45	287.9	115172.0
2020-03-10 06:20:00	SPY	ETF	287.85	287.85	287.11	287.17	72812.0
2020-03-10 06:25:00	SPY	ETF	287.16	287.5	287.16	287.26	29739.0
2020-03-10 06:30:00	SPY	ETF	287.2	287.97	287.11	287.64	33987.0
2020-03-10 06:35:00	SPY	ETF	287.66	287.66	286.91	287.29	37692.0
2020-03-10 06:40:00	SPY	ETF	287.33	287.91	287.26	287.88	69039.0
2020-03-10 06:45:00	SPY	ETF	287.94	288.45	287.94	288.26	66597.0
2020-03-10 06:50:00	SPY	ETF	288.15	288.34	287.98	288.34	59592.0
2020-03-10 06:55:00	SPY	ETF	288.34	288.44	287.86	287.86	52242.0
2020-03-10 07:00:00	SPY	ETF	287.85	288.01	287.24	287.34	119259.0
2020-03-10 07:05:00	SPY	ETF	287.35	287.45	287.04	287.11	74624.0
2020-03-10 07:10:00	SPY	ETF	287.22	287.57	287.0	287.15	74224.0
2020-03-10 07:15:00	SPY	ETF	287.04	287.12	286.57	286.74	136857.0
2020-03-10 07:20:00	SPY	ETF	286.64	286.64	286.27	286.45	129231.0
2020-03-10 07:25:00	SPY	ETF	286.5	286.55	286.11	286.2	93873.0
2020-03-10 07:30:00	SPY	ETF	286.17	286.88	286.17	286.5	37878.0
2020-03-10 07:35:00	SPY	ETF	286.5	286.77	286.3	286.69	54364.0
2020-03-10 07:40:00	SPY	ETF	286.63	286.9	286.54	286.59	70813.0
2020-03-10 07:45:00	SPY	ETF	286.42	286.62	286.0	286.0	64433.0
2020-03-10 07:50:00	SPY	ETF	286.02	286.2	285.72	285.72	76662.0
2020-03-10 07:55:00	SPY	ETF	285.72	286.28	285.6	286.0	141910.0
2020-03-10 08:00:00	SPY	ETF	285.96	287.8904	281.92	286.125	219665.0
2020-03-10 08:05:00	SPY	ETF	286.79	286.86	284.25	284.47	484685.0

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

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