PREVIEW / etf_5min / 2018-06-28

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-06-28.parquet
  size:    1.3 MB
  rows:    58,644

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-06-28 04:00:00	SPY	ETF	270.3	270.58	270.28	270.58	2314.0
2018-06-28 04:05:00	SPY	ETF	270.64	270.82	270.59	270.82	7554.0
2018-06-28 04:10:00	SPY	ETF	270.73	270.73	270.73	270.73	200.0
2018-06-28 04:15:00	SPY	ETF	270.71	270.74	270.63	270.63	8934.0
2018-06-28 04:20:00	SPY	ETF	270.67	270.67	270.66	270.66	300.0
2018-06-28 04:25:00	SPY	ETF	270.5	270.54	270.5	270.54	2500.0
2018-06-28 04:30:00	SPY	ETF	270.51	270.51	270.32	270.32	1850.0
2018-06-28 04:35:00	SPY	ETF	270.29	270.29	270.11	270.11	4210.0
2018-06-28 04:40:00	SPY	ETF	270.01	270.09	270.0	270.09	1110.0
2018-06-28 04:45:00	SPY	ETF	270.01	270.01	269.94	270.01	1000.0
2018-06-28 04:50:00	SPY	ETF	270.12	270.14	270.05	270.14	18400.0
2018-06-28 04:55:00	SPY	ETF	270.19	270.22	270.16	270.16	2600.0
2018-06-28 05:00:00	SPY	ETF	270.19	270.19	270.05	270.05	7555.0
2018-06-28 05:05:00	SPY	ETF	270.05	270.05	270.05	270.05	500.0
2018-06-28 05:10:00	SPY	ETF	270.12	270.14	270.04	270.05	3000.0
2018-06-28 05:15:00	SPY	ETF	270.08	270.08	270.02	270.04	700.0
2018-06-28 05:20:00	SPY	ETF	270.02	270.14	270.02	270.14	300.0
2018-06-28 05:25:00	SPY	ETF	270.09	270.09	270.09	270.09	100.0
2018-06-28 05:30:00	SPY	ETF	269.99	269.99	269.72	269.72	2760.0
2018-06-28 05:35:00	SPY	ETF	269.69	269.69	269.64	269.64	200.0
2018-06-28 05:40:00	SPY	ETF	269.61	269.75	269.59	269.75	7135.0
2018-06-28 05:45:00	SPY	ETF	269.74	269.74	269.7	269.7	11925.0
2018-06-28 05:50:00	SPY	ETF	269.81	269.83	269.79	269.83	2300.0
2018-06-28 05:55:00	SPY	ETF	269.86	270.06	269.86	270.06	2127.0
2018-06-28 06:00:00	SPY	ETF	269.99	269.99	269.99	269.99	750.0
2018-06-28 06:05:00	SPY	ETF	269.99	270.0	269.99	270.0	600.0
2018-06-28 06:10:00	SPY	ETF	270.06	270.06	270.03	270.03	1600.0
2018-06-28 06:15:00	SPY	ETF	270.12	270.16	270.09	270.16	2860.0
2018-06-28 06:20:00	SPY	ETF	270.17	270.24	270.17	270.21	4950.0
2018-06-28 06:25:00	SPY	ETF	270.16	270.23	270.13	270.23	11700.0
2018-06-28 06:30:00	SPY	ETF	270.27	270.28	270.25	270.25	800.0
2018-06-28 06:35:00	SPY	ETF	270.38	270.43	270.35	270.43	6220.0
2018-06-28 06:40:00	SPY	ETF	270.44	270.69	270.44	270.69	10465.0
2018-06-28 06:45:00	SPY	ETF	270.63	270.68	270.59	270.6	69750.0
2018-06-28 06:50:00	SPY	ETF	270.54	270.54	270.37	270.39	7995.0
2018-06-28 06:55:00	SPY	ETF	270.4	270.4	270.15	270.17	4110.0
2018-06-28 07:00:00	SPY	ETF	270.18	270.23	270.03	270.23	16278.0
2018-06-28 07:05:00	SPY	ETF	270.05	270.08	269.84	269.84	31440.0
2018-06-28 07:10:00	SPY	ETF	269.88	270.02	269.83	269.95	29292.0
2018-06-28 07:15:00	SPY	ETF	269.96	269.99	269.9	269.93	3910.0
2018-06-28 07:20:00	SPY	ETF	269.93	270.06	269.93	270.06	22280.0
2018-06-28 07:25:00	SPY	ETF	270.02	270.02	269.86	269.86	9700.0
2018-06-28 07:30:00	SPY	ETF	269.83	270.03	269.81	270.03	6570.0
2018-06-28 07:35:00	SPY	ETF	270.02	270.02	269.99	269.99	1098.0
2018-06-28 07:40:00	SPY	ETF	269.96	270.02	269.85	270.02	4369.0
2018-06-28 07:45:00	SPY	ETF	269.88	269.88	269.6	269.69	36227.0
2018-06-28 07:50:00	SPY	ETF	269.69	269.81	269.69	269.72	11950.0
2018-06-28 07:55:00	SPY	ETF	269.69	269.85	269.69	269.85	15680.0
2018-06-28 08:00:00	SPY	ETF	269.77	270.56	269.44	269.44	77046.0
2018-06-28 08:05:00	SPY	ETF	269.44	269.5	269.35	269.41	83195.0

> showing 50 of 58,644 rows — these rows as CSV

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