PREVIEW / etf_5min / 2020-05-05

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-05-05.parquet
  size:    1.7 MB
  rows:    75,175

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-05-05 04:00:00	SPY	ETF	286.17	286.44	286.17	286.34	14217.0
2020-05-05 04:05:00	SPY	ETF	286.36	286.71	286.3	286.53	14271.0
2020-05-05 04:10:00	SPY	ETF	286.63	286.82	286.46	286.46	16220.0
2020-05-05 04:15:00	SPY	ETF	286.34	286.34	285.68	285.82	12077.0
2020-05-05 04:20:00	SPY	ETF	285.82	286.38	285.76	286.32	3567.0
2020-05-05 04:25:00	SPY	ETF	286.6	286.68	286.51	286.51	3475.0
2020-05-05 04:30:00	SPY	ETF	286.52	286.52	285.63	285.75	18854.0
2020-05-05 04:35:00	SPY	ETF	285.82	285.93	285.6	285.68	12688.0
2020-05-05 04:40:00	SPY	ETF	285.55	285.61	284.92	285.26	36388.0
2020-05-05 04:45:00	SPY	ETF	285.13	285.15	284.45	284.48	27825.0
2020-05-05 04:50:00	SPY	ETF	284.48	284.63	283.99	283.99	39141.0
2020-05-05 04:55:00	SPY	ETF	284.0	284.23	283.72	283.78	14755.0
2020-05-05 05:00:00	SPY	ETF	283.7	284.45	283.61	284.13	18920.0
2020-05-05 05:05:00	SPY	ETF	284.21	284.5	284.01	284.5	9804.0
2020-05-05 05:10:00	SPY	ETF	284.51	284.61	284.49	284.55	4723.0
2020-05-05 05:15:00	SPY	ETF	284.67	285.04	284.67	284.79	11047.0
2020-05-05 05:20:00	SPY	ETF	284.91	284.91	284.4	284.63	2565.0
2020-05-05 05:25:00	SPY	ETF	284.5	284.65	284.29	284.65	2315.0
2020-05-05 05:30:00	SPY	ETF	284.39	284.68	284.39	284.59	1991.0
2020-05-05 05:35:00	SPY	ETF	284.54	284.72	284.5	284.72	2637.0
2020-05-05 05:40:00	SPY	ETF	284.79	285.26	284.79	285.26	6285.0
2020-05-05 05:45:00	SPY	ETF	285.16	285.39	285.0	285.25	10336.0
2020-05-05 05:50:00	SPY	ETF	285.25	285.45	285.2	285.45	2670.0
2020-05-05 05:55:00	SPY	ETF	285.11	285.38	285.11	285.17	3121.0
2020-05-05 06:00:00	SPY	ETF	285.39	285.7	285.38	285.6	9876.0
2020-05-05 06:05:00	SPY	ETF	285.7	285.73	285.45	285.5	2239.0
2020-05-05 06:10:00	SPY	ETF	285.66	285.97	285.47	285.5	6115.0
2020-05-05 06:15:00	SPY	ETF	285.44	285.44	285.27	285.27	4873.0
2020-05-05 06:20:00	SPY	ETF	285.39	285.39	285.35	285.35	894.0
2020-05-05 06:25:00	SPY	ETF	285.22	285.34	285.03	285.2	8902.0
2020-05-05 06:30:00	SPY	ETF	285.2	285.53	285.1	285.53	17834.0
2020-05-05 06:35:00	SPY	ETF	285.54	285.54	285.21	285.53	9084.0
2020-05-05 06:40:00	SPY	ETF	285.52	285.82	285.52	285.82	10174.0
2020-05-05 06:45:00	SPY	ETF	285.7	285.8	285.47	285.47	6720.0
2020-05-05 06:50:00	SPY	ETF	285.33	285.51	285.33	285.44	1746.0
2020-05-05 06:55:00	SPY	ETF	285.44	285.7	285.44	285.7	2420.0
2020-05-05 07:00:00	SPY	ETF	285.79	286.0	285.73	285.73	33675.0
2020-05-05 07:05:00	SPY	ETF	285.71	285.8	285.51	285.78	106016.0
2020-05-05 07:10:00	SPY	ETF	285.8	286.25	285.8	286.03	29809.0
2020-05-05 07:15:00	SPY	ETF	286.07	286.18	285.81	285.85	28309.0
2020-05-05 07:20:00	SPY	ETF	286.06	286.06	285.72	285.73	8290.0
2020-05-05 07:25:00	SPY	ETF	285.74	285.93	285.64	285.91	30473.0
2020-05-05 07:30:00	SPY	ETF	285.89	285.95	285.88	285.89	10869.0
2020-05-05 07:35:00	SPY	ETF	285.9	285.94	285.76	285.77	34830.0
2020-05-05 07:40:00	SPY	ETF	285.77	285.77	285.54	285.67	69644.0
2020-05-05 07:45:00	SPY	ETF	285.75	285.9	285.55	285.8	43535.0
2020-05-05 07:50:00	SPY	ETF	285.82	286.08	285.82	286.05	66243.0
2020-05-05 07:55:00	SPY	ETF	286.0	286.1	285.9	285.9	52223.0
2020-05-05 08:00:00	SPY	ETF	285.91	286.54	284.13	286.34	87925.0
2020-05-05 08:05:00	SPY	ETF	286.34	286.5499	286.28	286.52	49983.0

> showing 50 of 75,175 rows — these rows as CSV

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