PREVIEW / etf_5min / 2020-03-19

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-19.parquet
  size:    2.0 MB
  rows:    89,291

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-19 04:00:00	SPY	ETF	240.23	240.23	236.01	239.03	49705.0
2020-03-19 04:05:00	SPY	ETF	239.12	239.13	237.2	237.43	15270.0
2020-03-19 04:10:00	SPY	ETF	238.03	239.05	237.66	237.73	9413.0
2020-03-19 04:15:00	SPY	ETF	238.69	240.15	238.3	240.03	17783.0
2020-03-19 04:20:00	SPY	ETF	239.98	241.25	239.98	241.13	14788.0
2020-03-19 04:25:00	SPY	ETF	240.97	241.85	240.56	241.81	13163.0
2020-03-19 04:30:00	SPY	ETF	241.89	243.17	241.55	242.8	153718.0
2020-03-19 04:35:00	SPY	ETF	242.92	243.06	242.12	242.12	61290.0
2020-03-19 04:40:00	SPY	ETF	242.12	242.24	241.32	241.99	25410.0
2020-03-19 04:45:00	SPY	ETF	241.5	241.5	240.37	240.75	24195.0
2020-03-19 04:50:00	SPY	ETF	240.75	241.39	240.5	241.27	9806.0
2020-03-19 04:55:00	SPY	ETF	241.12	242.42	241.12	242.39	18556.0
2020-03-19 05:00:00	SPY	ETF	242.15	242.89	240.6	241.25	16452.0
2020-03-19 05:05:00	SPY	ETF	241.39	242.12	241.2	241.76	11042.0
2020-03-19 05:10:00	SPY	ETF	241.75	242.36	241.42	242.05	19868.0
2020-03-19 05:15:00	SPY	ETF	242.17	242.23	241.22	241.77	12477.0
2020-03-19 05:20:00	SPY	ETF	241.53	242.21	240.88	240.88	25866.0
2020-03-19 05:25:00	SPY	ETF	240.83	240.87	239.12	239.27	30500.0
2020-03-19 05:30:00	SPY	ETF	239.28	240.15	238.56	239.57	28160.0
2020-03-19 05:35:00	SPY	ETF	239.51	239.81	239.39	239.78	6738.0
2020-03-19 05:40:00	SPY	ETF	239.81	240.52	239.09	240.39	10791.0
2020-03-19 05:45:00	SPY	ETF	240.37	240.55	239.81	239.81	14193.0
2020-03-19 05:50:00	SPY	ETF	239.93	240.66	239.9	239.93	2346.0
2020-03-19 05:55:00	SPY	ETF	239.35	239.54	239.35	239.35	3630.0
2020-03-19 06:00:00	SPY	ETF	239.23	239.23	238.53	238.96	18938.0
2020-03-19 06:05:00	SPY	ETF	238.97	238.97	237.47	237.67	62497.0
2020-03-19 06:10:00	SPY	ETF	237.49	237.98	236.87	237.06	40695.0
2020-03-19 06:15:00	SPY	ETF	236.89	237.23	236.76	237.11	15394.0
2020-03-19 06:20:00	SPY	ETF	237.2	237.61	237.1	237.21	15639.0
2020-03-19 06:25:00	SPY	ETF	237.14	237.81	237.14	237.81	49176.0
2020-03-19 06:30:00	SPY	ETF	237.98	238.49	237.94	238.11	18176.0
2020-03-19 06:35:00	SPY	ETF	237.96	238.7	237.56	237.74	17742.0
2020-03-19 06:40:00	SPY	ETF	237.6	239.0	237.56	238.41	14642.0
2020-03-19 06:45:00	SPY	ETF	238.3	238.31	237.77	237.93	11952.0
2020-03-19 06:50:00	SPY	ETF	238.13	238.36	237.68	237.72	15092.0
2020-03-19 06:55:00	SPY	ETF	237.62	237.76	237.55	237.6	44241.0
2020-03-19 07:00:00	SPY	ETF	238.0	239.41	237.82	239.33	102753.0
2020-03-19 07:05:00	SPY	ETF	239.39	239.56	238.85	239.22	65881.0
2020-03-19 07:10:00	SPY	ETF	239.07	239.44	238.8	238.9	99854.0
2020-03-19 07:15:00	SPY	ETF	238.9	239.37	238.74	238.8	75000.0
2020-03-19 07:20:00	SPY	ETF	238.66	238.87	238.19	238.2	36383.0
2020-03-19 07:25:00	SPY	ETF	238.24	238.72	237.87	237.97	46603.0
2020-03-19 07:30:00	SPY	ETF	237.82	237.97	237.0	237.01	95688.0
2020-03-19 07:35:00	SPY	ETF	237.03	237.11	235.53	235.58	128145.0
2020-03-19 07:40:00	SPY	ETF	235.51	235.82	235.03	235.77	139344.0
2020-03-19 07:45:00	SPY	ETF	235.56	236.72	235.09	236.54	157612.0
2020-03-19 07:50:00	SPY	ETF	236.65	237.24	236.2	236.2	96457.0
2020-03-19 07:55:00	SPY	ETF	236.24	236.5	235.6	235.6	113785.0
2020-03-19 08:00:00	SPY	ETF	239.2999	241.02	229.31	236.33	300491.0
2020-03-19 08:05:00	SPY	ETF	236.5	236.57	235.97	236.37	119051.0

> showing 50 of 89,291 rows — these rows as CSV

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