PREVIEW / etf_5min / 2020-04-27

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-27.parquet
  size:    1.7 MB
  rows:    75,945

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-04-27 04:00:00	SPY	ETF	285.69	285.8	285.3	285.36	23173.0
2020-04-27 04:05:00	SPY	ETF	285.37	285.5	285.2	285.23	13060.0
2020-04-27 04:10:00	SPY	ETF	285.23	285.41	285.23	285.35	10375.0
2020-04-27 04:15:00	SPY	ETF	285.06	285.06	284.89	285.04	5481.0
2020-04-27 04:20:00	SPY	ETF	284.97	285.32	284.93	285.32	4100.0
2020-04-27 04:25:00	SPY	ETF	285.33	285.44	285.23	285.23	4529.0
2020-04-27 04:30:00	SPY	ETF	285.18	285.25	284.98	285.25	3570.0
2020-04-27 04:35:00	SPY	ETF	285.3	285.65	285.3	285.65	9454.0
2020-04-27 04:40:00	SPY	ETF	285.75	285.9	285.55	285.55	18798.0
2020-04-27 04:45:00	SPY	ETF	285.59	285.62	285.56	285.56	28587.0
2020-04-27 04:50:00	SPY	ETF	285.66	285.67	285.51	285.59	16400.0
2020-04-27 04:55:00	SPY	ETF	285.7	285.7	285.59	285.59	3749.0
2020-04-27 05:00:00	SPY	ETF	285.61	285.63	285.25	285.25	3355.0
2020-04-27 05:05:00	SPY	ETF	285.37	285.44	285.27	285.27	2910.0
2020-04-27 05:10:00	SPY	ETF	285.72	285.81	285.72	285.78	1560.0
2020-04-27 05:15:00	SPY	ETF	285.88	285.95	285.87	285.94	5253.0
2020-04-27 05:20:00	SPY	ETF	285.94	285.95	285.82	285.87	14655.0
2020-04-27 05:25:00	SPY	ETF	285.91	286.15	285.86	286.1	31189.0
2020-04-27 05:30:00	SPY	ETF	286.16	286.22	286.12	286.22	7053.0
2020-04-27 05:35:00	SPY	ETF	286.26	286.26	286.19	286.19	18878.0
2020-04-27 05:40:00	SPY	ETF	286.14	286.43	286.11	286.43	39068.0
2020-04-27 05:45:00	SPY	ETF	286.25	286.33	286.05	286.08	4600.0
2020-04-27 05:50:00	SPY	ETF	286.16	286.16	286.05	286.08	9210.0
2020-04-27 05:55:00	SPY	ETF	286.05	286.28	286.0	286.18	65297.0
2020-04-27 06:00:00	SPY	ETF	285.98	285.98	285.67	285.67	8671.0
2020-04-27 06:05:00	SPY	ETF	285.66	285.75	285.6	285.65	12425.0
2020-04-27 06:10:00	SPY	ETF	285.66	285.83	285.66	285.83	7859.0
2020-04-27 06:15:00	SPY	ETF	285.85	286.03	285.85	286.0	15734.0
2020-04-27 06:20:00	SPY	ETF	285.87	285.92	285.65	285.65	3936.0
2020-04-27 06:25:00	SPY	ETF	285.67	285.83	285.67	285.78	6884.0
2020-04-27 06:30:00	SPY	ETF	285.78	285.78	285.5	285.54	11483.0
2020-04-27 06:35:00	SPY	ETF	285.56	285.92	285.45	285.83	33679.0
2020-04-27 06:40:00	SPY	ETF	285.83	285.83	285.55	285.61	15294.0
2020-04-27 06:45:00	SPY	ETF	285.69	285.79	285.61	285.72	13872.0
2020-04-27 06:50:00	SPY	ETF	285.74	285.78	285.54	285.68	9802.0
2020-04-27 06:55:00	SPY	ETF	285.71	285.71	285.4	285.41	42238.0
2020-04-27 07:00:00	SPY	ETF	285.46	285.46	285.21	285.29	81165.0
2020-04-27 07:05:00	SPY	ETF	285.29	285.38	285.2	285.35	28309.0
2020-04-27 07:10:00	SPY	ETF	285.29	285.44	285.25	285.41	29502.0
2020-04-27 07:15:00	SPY	ETF	285.49	285.51	285.26	285.46	13097.0
2020-04-27 07:20:00	SPY	ETF	285.44	285.62	285.44	285.61	35948.0
2020-04-27 07:25:00	SPY	ETF	285.65	285.69	285.56	285.64	20497.0
2020-04-27 07:30:00	SPY	ETF	285.68	285.77	285.54	285.62	42533.0
2020-04-27 07:35:00	SPY	ETF	285.61	285.72	285.6	285.72	26986.0
2020-04-27 07:40:00	SPY	ETF	285.75	285.79	285.65	285.78	12702.0
2020-04-27 07:45:00	SPY	ETF	285.78	285.94	285.76	285.9	55175.0
2020-04-27 07:50:00	SPY	ETF	285.91	285.91	285.73	285.82	22824.0
2020-04-27 07:55:00	SPY	ETF	285.84	285.92	285.65	285.65	12365.0
2020-04-27 08:00:00	SPY	ETF	285.83	286.62	284.59	285.65	210646.0
2020-04-27 08:05:00	SPY	ETF	285.66	285.79	285.59	285.79	37695.0

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

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