PREVIEW / etf_5min / 2020-03-20

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-20.parquet
  size:    2.0 MB
  rows:    88,415

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-20 04:00:00	SPY	ETF	243.85	247.75	243.85	247.24	91887.0
2020-03-20 04:05:00	SPY	ETF	247.27	248.3	247.17	248.3	18012.0
2020-03-20 04:10:00	SPY	ETF	248.13	249.79	248.13	249.73	20388.0
2020-03-20 04:15:00	SPY	ETF	249.75	249.79	247.97	248.57	14626.0
2020-03-20 04:20:00	SPY	ETF	248.4	248.4	247.42	247.42	21912.0
2020-03-20 04:25:00	SPY	ETF	247.43	248.03	247.31	247.43	20705.0
2020-03-20 04:30:00	SPY	ETF	247.57	247.57	245.72	246.38	48380.0
2020-03-20 04:35:00	SPY	ETF	246.71	247.0	246.32	246.76	9336.0
2020-03-20 04:40:00	SPY	ETF	246.45	246.62	245.52	245.88	28634.0
2020-03-20 04:45:00	SPY	ETF	245.74	247.66	245.72	247.66	30653.0
2020-03-20 04:50:00	SPY	ETF	247.22	248.4	247.22	247.61	20567.0
2020-03-20 04:55:00	SPY	ETF	247.49	249.0	247.48	248.89	22803.0
2020-03-20 05:00:00	SPY	ETF	249.0	249.74	248.52	248.84	22685.0
2020-03-20 05:05:00	SPY	ETF	248.9	249.75	248.46	248.78	58677.0
2020-03-20 05:10:00	SPY	ETF	248.82	249.1	248.32	249.0	19438.0
2020-03-20 05:15:00	SPY	ETF	248.53	249.62	248.47	249.3	33206.0
2020-03-20 05:20:00	SPY	ETF	249.3	249.8	248.7	249.19	23759.0
2020-03-20 05:25:00	SPY	ETF	249.17	249.25	248.2	248.2	24159.0
2020-03-20 05:30:00	SPY	ETF	248.49	248.8	248.29	248.72	12990.0
2020-03-20 05:35:00	SPY	ETF	248.5	248.7	247.74	247.94	23564.0
2020-03-20 05:40:00	SPY	ETF	248.2	248.64	248.12	248.64	9157.0
2020-03-20 05:45:00	SPY	ETF	248.44	249.09	248.39	248.56	22254.0
2020-03-20 05:50:00	SPY	ETF	248.58	250.08	248.58	249.55	70761.0
2020-03-20 05:55:00	SPY	ETF	249.6	250.05	249.32	249.48	24631.0
2020-03-20 06:00:00	SPY	ETF	249.48	249.79	249.19	249.54	14695.0
2020-03-20 06:05:00	SPY	ETF	249.54	249.96	249.44	249.96	29273.0
2020-03-20 06:10:00	SPY	ETF	249.96	249.96	249.26	249.33	15938.0
2020-03-20 06:15:00	SPY	ETF	249.27	249.5	248.27	248.47	30071.0
2020-03-20 06:20:00	SPY	ETF	248.33	248.43	247.68	248.37	45966.0
2020-03-20 06:25:00	SPY	ETF	248.34	248.34	247.38	247.42	14121.0
2020-03-20 06:30:00	SPY	ETF	247.44	247.44	246.56	247.11	40029.0
2020-03-20 06:35:00	SPY	ETF	247.1	247.55	246.9	247.55	63835.0
2020-03-20 06:40:00	SPY	ETF	247.55	247.55	246.61	246.65	38406.0
2020-03-20 06:45:00	SPY	ETF	246.59	246.76	246.0	246.66	108304.0
2020-03-20 06:50:00	SPY	ETF	246.66	247.0	246.52	246.52	78112.0
2020-03-20 06:55:00	SPY	ETF	246.75	247.0	246.28	246.75	221330.0
2020-03-20 07:00:00	SPY	ETF	246.52	246.75	245.56	245.9	153765.0
2020-03-20 07:05:00	SPY	ETF	245.97	245.97	245.36	245.76	83334.0
2020-03-20 07:10:00	SPY	ETF	245.78	245.84	244.93	245.1	84994.0
2020-03-20 07:15:00	SPY	ETF	245.1	245.1	244.06	244.35	171822.0
2020-03-20 07:20:00	SPY	ETF	244.21	244.21	242.84	242.84	128744.0
2020-03-20 07:25:00	SPY	ETF	242.91	244.25	242.8	243.45	307992.0
2020-03-20 07:30:00	SPY	ETF	243.46	244.95	243.4	244.48	168277.0
2020-03-20 07:35:00	SPY	ETF	244.36	244.36	243.0	243.63	152239.0
2020-03-20 07:40:00	SPY	ETF	243.6	244.14	243.44	243.65	70349.0
2020-03-20 07:45:00	SPY	ETF	243.54	244.41	243.39	243.77	55671.0
2020-03-20 07:50:00	SPY	ETF	243.93	245.02	243.81	244.55	135707.0
2020-03-20 07:55:00	SPY	ETF	244.84	245.09	244.49	244.74	107771.0
2020-03-20 08:00:00	SPY	ETF	237.698	249.795	237.698	245.32	526409.0
2020-03-20 08:05:00	SPY	ETF	245.3	245.82	245.0	245.31	122619.0

> showing 50 of 88,415 rows — these rows as CSV

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