PREVIEW / etf_5min / 2020-03-06

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-06.parquet
  size:    1.9 MB
  rows:    81,812

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-06 04:00:00	SPY	ETF	298.71	299.51	298.71	299.43	22575.0
2020-03-06 04:05:00	SPY	ETF	299.51	299.6	299.0	299.0	3264.0
2020-03-06 04:10:00	SPY	ETF	299.2	299.21	298.4	298.85	14706.0
2020-03-06 04:15:00	SPY	ETF	298.58	298.58	298.18	298.25	5271.0
2020-03-06 04:20:00	SPY	ETF	298.39	298.59	297.9	297.9	4482.0
2020-03-06 04:25:00	SPY	ETF	297.92	298.05	297.82	298.05	10538.0
2020-03-06 04:30:00	SPY	ETF	298.06	298.12	297.69	297.69	3484.0
2020-03-06 04:35:00	SPY	ETF	297.69	297.69	296.9	297.08	41132.0
2020-03-06 04:40:00	SPY	ETF	297.04	297.24	296.83	296.87	10951.0
2020-03-06 04:45:00	SPY	ETF	296.75	296.91	296.55	296.65	8482.0
2020-03-06 04:50:00	SPY	ETF	296.69	297.53	296.5	296.5	30999.0
2020-03-06 04:55:00	SPY	ETF	296.46	296.65	295.9	295.91	18658.0
2020-03-06 05:00:00	SPY	ETF	295.87	295.97	295.4	295.4	31177.0
2020-03-06 05:05:00	SPY	ETF	295.45	295.55	295.03	295.08	13933.0
2020-03-06 05:10:00	SPY	ETF	295.0	295.7	294.84	295.4	26684.0
2020-03-06 05:15:00	SPY	ETF	295.5	295.5	294.8	295.24	10871.0
2020-03-06 05:20:00	SPY	ETF	295.12	295.12	294.42	294.74	36435.0
2020-03-06 05:25:00	SPY	ETF	294.74	294.96	294.2	294.29	34151.0
2020-03-06 05:30:00	SPY	ETF	294.18	294.65	293.86	294.14	22424.0
2020-03-06 05:35:00	SPY	ETF	294.14	294.14	293.24	293.35	18175.0
2020-03-06 05:40:00	SPY	ETF	293.31	293.68	293.0	293.31	28453.0
2020-03-06 05:45:00	SPY	ETF	293.26	294.25	293.25	293.75	35570.0
2020-03-06 05:50:00	SPY	ETF	293.59	294.49	293.55	294.47	13691.0
2020-03-06 05:55:00	SPY	ETF	294.33	294.48	294.0	294.35	2954.0
2020-03-06 06:00:00	SPY	ETF	294.22	295.06	294.11	295.06	60544.0
2020-03-06 06:05:00	SPY	ETF	295.11	295.14	294.28	294.28	48474.0
2020-03-06 06:10:00	SPY	ETF	294.12	294.34	293.3	293.4	74937.0
2020-03-06 06:15:00	SPY	ETF	293.48	294.15	293.27	293.96	54812.0
2020-03-06 06:20:00	SPY	ETF	294.03	294.44	293.87	294.25	28730.0
2020-03-06 06:25:00	SPY	ETF	294.26	294.45	293.7	293.7	8042.0
2020-03-06 06:30:00	SPY	ETF	293.8	294.47	293.8	294.17	70142.0
2020-03-06 06:35:00	SPY	ETF	294.55	294.77	294.14	294.77	22371.0
2020-03-06 06:40:00	SPY	ETF	294.57	294.96	294.57	294.69	32345.0
2020-03-06 06:45:00	SPY	ETF	294.66	295.07	294.56	294.9	56831.0
2020-03-06 06:50:00	SPY	ETF	294.99	295.41	294.92	295.28	46789.0
2020-03-06 06:55:00	SPY	ETF	295.29	295.29	294.5	294.54	31727.0
2020-03-06 07:00:00	SPY	ETF	294.5	295.3	294.46	295.25	82459.0
2020-03-06 07:05:00	SPY	ETF	295.29	295.38	294.88	295.09	123367.0
2020-03-06 07:10:00	SPY	ETF	295.0	295.04	294.67	294.91	60455.0
2020-03-06 07:15:00	SPY	ETF	294.84	295.22	294.69	295.08	52749.0
2020-03-06 07:20:00	SPY	ETF	295.09	295.09	294.54	294.54	80975.0
2020-03-06 07:25:00	SPY	ETF	294.55	294.55	293.7	293.79	251063.0
2020-03-06 07:30:00	SPY	ETF	293.8	294.38	293.7	294.0	49952.0
2020-03-06 07:35:00	SPY	ETF	294.12	294.36	294.04	294.27	44246.0
2020-03-06 07:40:00	SPY	ETF	294.15	294.15	293.29	293.52	114828.0
2020-03-06 07:45:00	SPY	ETF	293.54	294.04	293.13	293.14	181176.0
2020-03-06 07:50:00	SPY	ETF	293.22	293.43	291.9	292.84	198987.0
2020-03-06 07:55:00	SPY	ETF	292.85	293.4	292.5	293.27	144460.0
2020-03-06 08:00:00	SPY	ETF	298.87	301.4	291.9798	292.95	743360.0
2020-03-06 08:05:00	SPY	ETF	292.95	302.8	292.4	292.47	377805.0

> showing 50 of 81,812 rows — these rows as CSV

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