PREVIEW / etf_5min / 2020-11-05

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-11-05.parquet
  size:    1.7 MB
  rows:    80,698

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-11-05 04:00:00	SPY	ETF	347.87	348.15	347.6	347.66	11367.0
2020-11-05 04:05:00	SPY	ETF	347.66	347.73	347.51	347.6	2078.0
2020-11-05 04:10:00	SPY	ETF	347.5	347.5	347.28	347.5	5071.0
2020-11-05 04:15:00	SPY	ETF	347.58	347.81	347.53	347.73	18814.0
2020-11-05 04:20:00	SPY	ETF	347.57	347.97	347.57	347.97	2507.0
2020-11-05 04:25:00	SPY	ETF	347.94	347.94	347.63	347.76	3125.0
2020-11-05 04:30:00	SPY	ETF	347.7	347.77	347.5	347.74	4033.0
2020-11-05 04:35:00	SPY	ETF	347.85	348.34	347.83	348.34	3122.0
2020-11-05 04:40:00	SPY	ETF	348.4	348.95	348.4	348.75	6946.0
2020-11-05 04:45:00	SPY	ETF	348.68	348.71	348.6	348.6	1001.0
2020-11-05 04:50:00	SPY	ETF	348.59	349.05	348.59	349.05	8513.0
2020-11-05 04:55:00	SPY	ETF	348.97	349.02	348.8	349.0	14561.0
2020-11-05 05:00:00	SPY	ETF	349.0	349.8	348.81	349.7	27495.0
2020-11-05 05:05:00	SPY	ETF	349.53	349.87	349.53	349.79	45585.0
2020-11-05 05:10:00	SPY	ETF	349.78	349.78	349.6	349.6	11335.0
2020-11-05 05:15:00	SPY	ETF	349.77	349.82	349.68	349.82	2590.0
2020-11-05 05:20:00	SPY	ETF	349.88	350.37	349.87	350.32	8525.0
2020-11-05 05:25:00	SPY	ETF	349.9	349.94	349.56	349.7	12442.0
2020-11-05 05:30:00	SPY	ETF	349.65	349.72	349.41	349.72	3901.0
2020-11-05 05:35:00	SPY	ETF	350.1	350.24	349.79	349.79	2510.0
2020-11-05 05:40:00	SPY	ETF	349.86	350.23	349.82	349.82	7685.0
2020-11-05 05:45:00	SPY	ETF	349.78	350.06	349.71	350.04	7017.0
2020-11-05 05:50:00	SPY	ETF	349.92	350.15	349.7	349.7	4382.0
2020-11-05 05:55:00	SPY	ETF	350.03	350.66	349.97	350.66	13519.0
2020-11-05 06:00:00	SPY	ETF	350.59	350.63	350.32	350.4	10476.0
2020-11-05 06:05:00	SPY	ETF	350.18	350.38	349.79	349.87	14592.0
2020-11-05 06:10:00	SPY	ETF	349.98	350.17	349.98	350.11	15293.0
2020-11-05 06:15:00	SPY	ETF	350.03	350.37	349.96	350.27	19509.0
2020-11-05 06:20:00	SPY	ETF	350.18	350.77	350.01	350.74	25322.0
2020-11-05 06:25:00	SPY	ETF	350.69	350.7	350.2	350.54	9480.0
2020-11-05 06:30:00	SPY	ETF	350.6	350.6	349.71	349.71	26091.0
2020-11-05 06:35:00	SPY	ETF	349.73	349.93	349.73	349.86	5633.0
2020-11-05 06:40:00	SPY	ETF	349.84	350.24	349.72	350.2	32658.0
2020-11-05 06:45:00	SPY	ETF	350.19	350.39	350.19	350.27	8952.0
2020-11-05 06:50:00	SPY	ETF	350.26	350.26	349.9	349.94	6942.0
2020-11-05 06:55:00	SPY	ETF	349.93	350.34	349.93	349.99	9994.0
2020-11-05 07:00:00	SPY	ETF	349.96	350.0	349.25	349.39	86800.0
2020-11-05 07:05:00	SPY	ETF	349.39	349.5	349.06	349.36	49701.0
2020-11-05 07:10:00	SPY	ETF	349.3	349.31	349.07	349.2	20709.0
2020-11-05 07:15:00	SPY	ETF	349.21	349.61	349.14	349.6	15873.0
2020-11-05 07:20:00	SPY	ETF	349.57	349.59	349.36	349.5	20544.0
2020-11-05 07:25:00	SPY	ETF	349.54	349.72	349.43	349.69	21942.0
2020-11-05 07:30:00	SPY	ETF	349.7	349.82	349.66	349.72	27409.0
2020-11-05 07:35:00	SPY	ETF	349.68	349.81	349.56	349.62	16528.0
2020-11-05 07:40:00	SPY	ETF	349.63	349.79	349.41	349.79	15099.0
2020-11-05 07:45:00	SPY	ETF	349.74	349.83	349.54	349.66	22904.0
2020-11-05 07:50:00	SPY	ETF	349.66	350.12	349.38	350.05	73180.0
2020-11-05 07:55:00	SPY	ETF	350.03	350.3	350.012	350.12	52488.0
2020-11-05 08:00:00	SPY	ETF	350.11	350.64	345.75	347.5	139194.0
2020-11-05 08:05:00	SPY	ETF	349.86	350.04	349.72	349.78	26069.0

> showing 50 of 80,698 rows — these rows as CSV

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