PREVIEW / etf_5min / 2021-09-20

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-09-20.parquet
  size:    2.0 MB
  rows:    96,002

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
2021-09-20 04:00:00	SPY	ETF	436.91	439.49	436.55	436.85	41070.0
2021-09-20 04:05:00	SPY	ETF	436.83	436.99	436.57	436.93	15228.0
2021-09-20 04:10:00	SPY	ETF	436.95	436.95	436.56	436.6	22619.0
2021-09-20 04:15:00	SPY	ETF	436.65	436.68	436.4	436.42	16909.0
2021-09-20 04:20:00	SPY	ETF	436.39	436.46	436.26	436.36	82024.0
2021-09-20 04:25:00	SPY	ETF	436.33	436.53	436.03	436.44	37323.0
2021-09-20 04:30:00	SPY	ETF	436.44	436.63	436.16	436.63	46499.0
2021-09-20 04:35:00	SPY	ETF	436.63	436.68	436.5	436.6	33783.0
2021-09-20 04:40:00	SPY	ETF	436.55	436.55	436.32	436.46	3857.0
2021-09-20 04:45:00	SPY	ETF	436.47	436.77	436.46	436.52	7600.0
2021-09-20 04:50:00	SPY	ETF	436.71	436.9	436.64	436.69	9516.0
2021-09-20 04:55:00	SPY	ETF	436.72	436.75	436.33	436.37	1887.0
2021-09-20 05:00:00	SPY	ETF	436.42	436.48	436.24	436.24	2244.0
2021-09-20 05:05:00	SPY	ETF	436.2	436.38	436.15	436.36	1748.0
2021-09-20 05:10:00	SPY	ETF	436.36	436.5	436.28	436.48	4237.0
2021-09-20 05:15:00	SPY	ETF	436.37	436.4	436.28	436.3	3950.0
2021-09-20 05:20:00	SPY	ETF	436.23	436.23	435.75	435.83	131917.0
2021-09-20 05:25:00	SPY	ETF	435.82	436.12	435.55	435.9	72625.0
2021-09-20 05:30:00	SPY	ETF	435.94	435.95	435.8	435.84	16056.0
2021-09-20 05:35:00	SPY	ETF	435.77	435.83	435.6	435.68	60417.0
2021-09-20 05:40:00	SPY	ETF	435.66	435.66	435.4	435.44	5594.0
2021-09-20 05:45:00	SPY	ETF	435.44	435.48	435.25	435.32	42070.0
2021-09-20 05:50:00	SPY	ETF	435.33	435.53	435.15	435.52	39167.0
2021-09-20 05:55:00	SPY	ETF	435.49	435.57	435.43	435.52	62367.0
2021-09-20 06:00:00	SPY	ETF	435.48	435.72	435.48	435.59	9302.0
2021-09-20 06:05:00	SPY	ETF	435.58	435.99	435.58	435.82	11272.0
2021-09-20 06:10:00	SPY	ETF	435.81	435.81	435.64	435.69	11602.0
2021-09-20 06:15:00	SPY	ETF	435.74	435.9	435.74	435.8	4400.0
2021-09-20 06:20:00	SPY	ETF	435.84	435.92	435.8	435.84	14397.0
2021-09-20 06:25:00	SPY	ETF	435.85	436.15	435.85	436.01	16894.0
2021-09-20 06:30:00	SPY	ETF	436.03	436.07	436.0	436.02	18924.0
2021-09-20 06:35:00	SPY	ETF	435.99	436.02	435.75	435.75	4700.0
2021-09-20 06:40:00	SPY	ETF	435.75	435.9	435.71	435.87	14168.0
2021-09-20 06:45:00	SPY	ETF	435.87	435.96	435.85	435.9	10900.0
2021-09-20 06:50:00	SPY	ETF	435.9	435.91	435.79	435.81	9322.0
2021-09-20 06:55:00	SPY	ETF	435.78	435.78	435.5	435.52	8761.0
2021-09-20 07:00:00	SPY	ETF	435.54	435.92	435.5	435.83	80742.0
2021-09-20 07:05:00	SPY	ETF	435.83	435.88	435.67	435.7	38883.0
2021-09-20 07:10:00	SPY	ETF	435.7	435.96	435.67	435.88	18115.0
2021-09-20 07:15:00	SPY	ETF	435.87	435.88	435.66	435.66	20901.0
2021-09-20 07:20:00	SPY	ETF	435.65	435.65	435.18	435.23	39451.0
2021-09-20 07:25:00	SPY	ETF	435.24	435.32	435.05	435.27	48750.0
2021-09-20 07:30:00	SPY	ETF	435.26	435.26	434.5	434.62	115898.0
2021-09-20 07:35:00	SPY	ETF	434.57	434.99	434.57	434.97	119631.0
2021-09-20 07:40:00	SPY	ETF	434.97	434.97	434.6	434.82	220996.0
2021-09-20 07:45:00	SPY	ETF	434.84	434.88	434.7	434.83	91619.0
2021-09-20 07:50:00	SPY	ETF	434.83	435.0	434.52	434.52	146061.0
2021-09-20 07:55:00	SPY	ETF	434.52	434.67	434.51	434.54	124954.0
2021-09-20 08:00:00	SPY	ETF	434.53	438.6	434.34	434.72	216708.0
2021-09-20 08:05:00	SPY	ETF	434.71	434.86	434.38	434.39	49955.0

> showing 50 of 96,002 rows — these rows as CSV

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