PREVIEW / etf_5min / 2018-04-16

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-16.parquet
  size:    1.3 MB
  rows:    56,573

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-04-16 04:00:00	SPY	ETF	266.0	266.29	266.0	266.29	2043.0
2018-04-16 04:05:00	SPY	ETF	266.28	266.29	266.28	266.29	1150.0
2018-04-16 04:10:00	SPY	ETF	266.34	266.34	266.29	266.29	500.0
2018-04-16 04:15:00	SPY	ETF	266.4	266.4	266.39	266.4	430.0
2018-04-16 04:20:00	SPY	ETF	266.38	266.38	266.22	266.22	1217.0
2018-04-16 04:50:00	SPY	ETF	266.26	266.26	266.26	266.26	100.0
2018-04-16 04:55:00	SPY	ETF	266.43	266.43	266.43	266.43	900.0
2018-04-16 05:00:00	SPY	ETF	266.41	266.44	266.41	266.44	700.0
2018-04-16 05:05:00	SPY	ETF	266.46	266.5	266.46	266.5	1800.0
2018-04-16 05:10:00	SPY	ETF	266.46	266.46	266.46	266.46	600.0
2018-04-16 05:15:00	SPY	ETF	266.52	266.79	266.52	266.71	4660.0
2018-04-16 05:20:00	SPY	ETF	266.73	266.8	266.73	266.8	700.0
2018-04-16 05:25:00	SPY	ETF	266.83	266.89	266.83	266.89	1061.0
2018-04-16 05:30:00	SPY	ETF	266.86	266.86	266.86	266.86	1000.0
2018-04-16 05:35:00	SPY	ETF	266.83	266.95	266.83	266.95	1300.0
2018-04-16 05:40:00	SPY	ETF	266.92	266.92	266.92	266.92	1000.0
2018-04-16 05:45:00	SPY	ETF	266.94	266.94	266.88	266.88	1550.0
2018-04-16 05:50:00	SPY	ETF	266.95	266.95	266.9	266.9	540.0
2018-04-16 05:55:00	SPY	ETF	266.9	266.96	266.9	266.96	34600.0
2018-04-16 06:00:00	SPY	ETF	266.92	266.92	266.92	266.92	18000.0
2018-04-16 06:05:00	SPY	ETF	266.74	266.78	266.74	266.78	3000.0
2018-04-16 06:15:00	SPY	ETF	266.92	266.92	266.92	266.92	300.0
2018-04-16 06:20:00	SPY	ETF	266.94	267.0	266.87	266.87	2253.0
2018-04-16 06:25:00	SPY	ETF	266.87	267.01	266.87	267.01	1600.0
2018-04-16 06:30:00	SPY	ETF	266.92	266.92	266.92	266.92	200.0
2018-04-16 06:35:00	SPY	ETF	266.78	266.84	266.78	266.84	350.0
2018-04-16 06:40:00	SPY	ETF	266.81	266.81	266.7	266.72	4400.0
2018-04-16 06:45:00	SPY	ETF	266.8	266.83	266.69	266.71	5355.0
2018-04-16 06:50:00	SPY	ETF	266.69	266.83	266.69	266.83	31750.0
2018-04-16 06:55:00	SPY	ETF	266.81	266.84	266.81	266.84	12750.0
2018-04-16 07:00:00	SPY	ETF	266.91	267.01	266.84	266.95	45363.0
2018-04-16 07:05:00	SPY	ETF	266.87	266.9	266.78	266.81	20020.0
2018-04-16 07:10:00	SPY	ETF	266.84	266.89	266.83	266.83	13565.0
2018-04-16 07:15:00	SPY	ETF	266.84	266.84	266.7	266.77	34800.0
2018-04-16 07:20:00	SPY	ETF	266.77	266.81	266.72	266.72	50255.0
2018-04-16 07:25:00	SPY	ETF	266.75	266.75	266.64	266.69	29720.0
2018-04-16 07:30:00	SPY	ETF	266.69	266.7	266.5	266.7	29728.0
2018-04-16 07:35:00	SPY	ETF	266.75	266.76	266.68	266.7	2888.0
2018-04-16 07:40:00	SPY	ETF	266.74	266.75	266.62	266.73	2415.0
2018-04-16 07:45:00	SPY	ETF	266.7	266.72	266.64	266.7	4150.0
2018-04-16 07:50:00	SPY	ETF	266.7	266.73	266.66	266.7	12066.0
2018-04-16 07:55:00	SPY	ETF	266.65	266.69	266.62	266.63	15575.0
2018-04-16 08:00:00	SPY	ETF	266.64	266.93	265.8	266.65	230437.0
2018-04-16 08:05:00	SPY	ETF	266.68	266.7	266.57	266.7	12127.0
2018-04-16 08:10:00	SPY	ETF	266.67	266.69	266.64	266.69	4548.0
2018-04-16 08:15:00	SPY	ETF	266.69	266.77	266.67	266.75	7802.0
2018-04-16 08:20:00	SPY	ETF	266.76	266.76	266.71	266.72	23413.0
2018-04-16 08:25:00	SPY	ETF	266.71	266.74	266.68	266.72	20845.0
2018-04-16 08:30:00	SPY	ETF	266.72	266.86	266.52	266.83	76309.0
2018-04-16 08:35:00	SPY	ETF	266.77	266.85	266.72	266.85	22187.0

> showing 50 of 56,573 rows — these rows as CSV

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