PREVIEW / etf_5min / 2018-03-07

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-03-07.parquet
  size:    1.4 MB
  rows:    57,920

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
2018-03-07 04:00:00	SPY	ETF	270.08	270.28	270.0	270.12	15074.0
2018-03-07 04:05:00	SPY	ETF	270.1	270.15	270.1	270.13	5071.0
2018-03-07 04:10:00	SPY	ETF	270.08	270.08	269.86	270.0	41049.0
2018-03-07 04:15:00	SPY	ETF	270.0	270.02	269.73	269.75	34535.0
2018-03-07 04:20:00	SPY	ETF	269.7	269.84	269.67	269.84	20200.0
2018-03-07 04:25:00	SPY	ETF	269.87	270.08	269.87	270.05	16995.0
2018-03-07 04:30:00	SPY	ETF	270.0	270.0	269.97	269.99	2400.0
2018-03-07 04:35:00	SPY	ETF	269.88	269.88	269.65	269.65	3817.0
2018-03-07 04:40:00	SPY	ETF	269.65	269.76	269.65	269.76	3608.0
2018-03-07 04:45:00	SPY	ETF	269.67	269.76	269.67	269.76	1630.0
2018-03-07 04:50:00	SPY	ETF	269.74	269.87	269.74	269.87	5020.0
2018-03-07 04:55:00	SPY	ETF	269.83	269.83	269.83	269.83	1020.0
2018-03-07 05:00:00	SPY	ETF	269.91	269.92	269.84	269.92	4857.0
2018-03-07 05:05:00	SPY	ETF	269.92	270.3	269.92	270.25	11969.0
2018-03-07 05:10:00	SPY	ETF	270.32	270.45	270.32	270.45	27090.0
2018-03-07 05:15:00	SPY	ETF	270.56	270.56	270.43	270.55	7318.0
2018-03-07 05:20:00	SPY	ETF	270.55	270.55	270.33	270.33	2100.0
2018-03-07 05:25:00	SPY	ETF	270.35	270.37	270.34	270.35	2070.0
2018-03-07 05:30:00	SPY	ETF	270.5	270.59	270.48	270.48	3100.0
2018-03-07 05:35:00	SPY	ETF	270.3	270.33	270.3	270.31	1560.0
2018-03-07 05:40:00	SPY	ETF	270.18	270.27	270.18	270.22	2186.0
2018-03-07 05:45:00	SPY	ETF	270.26	270.26	270.06	270.2	2560.0
2018-03-07 05:50:00	SPY	ETF	270.07	270.16	270.07	270.1	6850.0
2018-03-07 05:55:00	SPY	ETF	270.07	270.12	269.92	269.94	3930.0
2018-03-07 06:00:00	SPY	ETF	269.96	269.99	269.81	269.99	10705.0
2018-03-07 06:05:00	SPY	ETF	270.01	270.03	269.77	269.77	7850.0
2018-03-07 06:10:00	SPY	ETF	269.76	269.77	269.63	269.66	5187.0
2018-03-07 06:15:00	SPY	ETF	269.71	269.75	269.56	269.7	10940.0
2018-03-07 06:20:00	SPY	ETF	269.7	269.7	269.64	269.68	1919.0
2018-03-07 06:25:00	SPY	ETF	269.69	269.87	269.69	269.82	1266.0
2018-03-07 06:30:00	SPY	ETF	269.9	269.95	269.89	269.95	13944.0
2018-03-07 06:35:00	SPY	ETF	269.95	270.01	269.87	269.93	19495.0
2018-03-07 06:40:00	SPY	ETF	269.89	270.2	269.89	270.12	18159.0
2018-03-07 06:45:00	SPY	ETF	270.03	270.05	269.83	270.05	10160.0
2018-03-07 06:50:00	SPY	ETF	270.07	270.08	269.88	270.0	22400.0
2018-03-07 06:55:00	SPY	ETF	269.98	270.05	269.94	269.99	17598.0
2018-03-07 07:00:00	SPY	ETF	269.98	270.41	269.92	270.14	55426.0
2018-03-07 07:05:00	SPY	ETF	270.14	270.29	270.09	270.25	60046.0
2018-03-07 07:10:00	SPY	ETF	270.29	270.6	270.28	270.5	88760.0
2018-03-07 07:15:00	SPY	ETF	270.53	270.66	270.42	270.56	54601.0
2018-03-07 07:20:00	SPY	ETF	270.55	270.55	270.44	270.55	87752.0
2018-03-07 07:25:00	SPY	ETF	270.55	270.85	270.51	270.8	91147.0
2018-03-07 07:30:00	SPY	ETF	270.8	270.85	270.69	270.7	99372.0
2018-03-07 07:35:00	SPY	ETF	270.67	270.67	270.5	270.59	100353.0
2018-03-07 07:40:00	SPY	ETF	270.61	270.65	270.53	270.58	19350.0
2018-03-07 07:45:00	SPY	ETF	270.58	270.65	270.47	270.61	135730.0
2018-03-07 07:50:00	SPY	ETF	270.62	270.81	270.59	270.81	164482.0
2018-03-07 07:55:00	SPY	ETF	270.79	270.84	270.65	270.7	115198.0
2018-03-07 08:00:00	SPY	ETF	270.29	270.84	268.75	270.55	220795.0
2018-03-07 08:05:00	SPY	ETF	270.56	270.6	270.47	270.47	56444.0

> showing 50 of 57,920 rows — these rows as CSV

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