PREVIEW / etf_5min / 2019-05-07

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-05-07.parquet
  size:    1.6 MB
  rows:    66,355

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
2019-05-07 04:00:00	SPY	ETF	291.81	292.07	291.81	292.07	24925.0
2019-05-07 04:05:00	SPY	ETF	291.85	291.85	291.85	291.85	250.0
2019-05-07 04:10:00	SPY	ETF	291.85	291.85	291.85	291.85	669.0
2019-05-07 04:20:00	SPY	ETF	291.73	291.75	291.73	291.75	350.0
2019-05-07 04:30:00	SPY	ETF	291.81	291.81	291.7	291.7	1215.0
2019-05-07 04:35:00	SPY	ETF	291.75	291.75	291.75	291.75	1000.0
2019-05-07 04:40:00	SPY	ETF	291.7	291.71	291.7	291.71	2000.0
2019-05-07 04:45:00	SPY	ETF	291.7	291.7	291.7	291.7	2000.0
2019-05-07 04:55:00	SPY	ETF	291.5	291.56	291.48	291.48	2580.0
2019-05-07 05:10:00	SPY	ETF	291.41	291.42	291.41	291.42	300.0
2019-05-07 05:15:00	SPY	ETF	291.46	291.46	291.46	291.46	100.0
2019-05-07 05:20:00	SPY	ETF	291.38	291.38	291.38	291.38	100.0
2019-05-07 05:25:00	SPY	ETF	291.4	291.4	291.37	291.37	400.0
2019-05-07 05:30:00	SPY	ETF	291.25	291.25	291.16	291.21	915.0
2019-05-07 05:35:00	SPY	ETF	291.15	291.15	291.15	291.15	100.0
2019-05-07 05:40:00	SPY	ETF	291.26	291.26	291.26	291.26	2000.0
2019-05-07 05:45:00	SPY	ETF	291.32	291.32	291.32	291.32	104.0
2019-05-07 05:50:00	SPY	ETF	291.36	291.43	291.36	291.43	1952.0
2019-05-07 05:55:00	SPY	ETF	291.38	291.4	291.38	291.4	504.0
2019-05-07 06:00:00	SPY	ETF	291.39	291.43	291.39	291.4	2800.0
2019-05-07 06:10:00	SPY	ETF	291.3	291.3	291.3	291.3	100.0
2019-05-07 06:20:00	SPY	ETF	291.33	291.33	291.3	291.3	1800.0
2019-05-07 06:25:00	SPY	ETF	291.3	291.3	291.3	291.3	500.0
2019-05-07 06:30:00	SPY	ETF	291.35	291.35	291.3	291.31	1900.0
2019-05-07 06:35:00	SPY	ETF	291.35	291.39	291.3	291.37	43115.0
2019-05-07 06:40:00	SPY	ETF	291.38	291.41	291.36	291.38	4780.0
2019-05-07 06:45:00	SPY	ETF	291.36	291.36	291.29	291.29	31050.0
2019-05-07 06:50:00	SPY	ETF	291.3	291.32	291.25	291.31	7960.0
2019-05-07 06:55:00	SPY	ETF	291.28	291.28	290.88	290.91	12908.0
2019-05-07 07:00:00	SPY	ETF	290.93	290.95	290.81	290.91	19991.0
2019-05-07 07:05:00	SPY	ETF	290.89	290.91	290.83	290.9	3027.0
2019-05-07 07:10:00	SPY	ETF	290.89	290.96	290.87	290.93	42630.0
2019-05-07 07:15:00	SPY	ETF	290.93	291.0	290.9	290.99	29270.0
2019-05-07 07:20:00	SPY	ETF	290.98	290.99	290.92	290.98	9552.0
2019-05-07 07:25:00	SPY	ETF	290.97	291.02	290.97	290.99	27523.0
2019-05-07 07:30:00	SPY	ETF	290.99	291.03	290.98	291.03	26580.0
2019-05-07 07:35:00	SPY	ETF	290.99	291.11	290.99	291.08	51589.0
2019-05-07 07:40:00	SPY	ETF	291.09	291.12	290.99	291.09	51262.0
2019-05-07 07:45:00	SPY	ETF	291.09	291.25	291.07	291.2	133781.0
2019-05-07 07:50:00	SPY	ETF	291.19	291.19	290.76	290.79	31241.0
2019-05-07 07:55:00	SPY	ETF	290.76	290.76	290.43	290.55	76950.0
2019-05-07 08:00:00	SPY	ETF	290.55	292.5	290.4	290.53	157892.0
2019-05-07 08:05:00	SPY	ETF	290.55	290.75	290.5	290.75	92169.0
2019-05-07 08:10:00	SPY	ETF	290.74	290.78	290.7	290.76	54090.0
2019-05-07 08:15:00	SPY	ETF	290.78	290.96	290.78	290.92	58643.0
2019-05-07 08:20:00	SPY	ETF	290.9	290.92	290.79	290.86	52098.0
2019-05-07 08:25:00	SPY	ETF	290.86	290.98	290.86	290.94	72641.0
2019-05-07 08:30:00	SPY	ETF	290.92	291.01	290.91	290.99	45462.0
2019-05-07 08:35:00	SPY	ETF	290.98	291.02	290.97	291.0	13729.0
2019-05-07 08:40:00	SPY	ETF	290.99	291.0	290.81	290.99	22786.0

> showing 50 of 66,355 rows — these rows as CSV

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