PREVIEW / etf_5min / 2018-04-17

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-17.parquet
  size:    1.4 MB
  rows:    58,914

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-17 04:00:00	SPY	ETF	268.59	268.8	268.59	268.8	1736.0
2018-04-17 04:05:00	SPY	ETF	268.7	268.7	268.65	268.65	2800.0
2018-04-17 04:10:00	SPY	ETF	268.66	268.66	268.63	268.63	400.0
2018-04-17 04:15:00	SPY	ETF	268.64	268.64	268.54	268.54	603.0
2018-04-17 04:20:00	SPY	ETF	268.63	268.63	268.5	268.5	1097.0
2018-04-17 04:25:00	SPY	ETF	268.54	268.54	268.5	268.5	20300.0
2018-04-17 04:30:00	SPY	ETF	268.5	268.51	268.36	268.41	1300.0
2018-04-17 04:35:00	SPY	ETF	268.46	268.46	268.46	268.46	300.0
2018-04-17 04:40:00	SPY	ETF	268.41	268.41	268.41	268.41	300.0
2018-04-17 04:45:00	SPY	ETF	268.48	268.55	268.48	268.55	6820.0
2018-04-17 04:50:00	SPY	ETF	268.71	268.71	268.71	268.71	100.0
2018-04-17 04:55:00	SPY	ETF	268.86	268.86	268.86	268.86	600.0
2018-04-17 05:00:00	SPY	ETF	268.73	268.73	268.73	268.73	580.0
2018-04-17 05:10:00	SPY	ETF	268.79	268.79	268.79	268.79	200.0
2018-04-17 05:15:00	SPY	ETF	268.74	268.74	268.74	268.74	100.0
2018-04-17 05:20:00	SPY	ETF	268.73	268.73	268.71	268.71	800.0
2018-04-17 05:25:00	SPY	ETF	268.75	268.75	268.75	268.75	1360.0
2018-04-17 05:30:00	SPY	ETF	268.73	268.73	268.73	268.73	500.0
2018-04-17 05:35:00	SPY	ETF	268.7	268.79	268.7	268.79	600.0
2018-04-17 05:45:00	SPY	ETF	268.65	268.72	268.63	268.72	3650.0
2018-04-17 05:50:00	SPY	ETF	268.67	268.72	268.66	268.72	1910.0
2018-04-17 05:55:00	SPY	ETF	268.79	268.87	268.79	268.87	8028.0
2018-04-17 06:00:00	SPY	ETF	268.83	268.83	268.83	268.83	100.0
2018-04-17 06:05:00	SPY	ETF	268.8	268.98	268.8	268.98	3743.0
2018-04-17 06:10:00	SPY	ETF	268.97	269.0	268.97	268.98	3846.0
2018-04-17 06:15:00	SPY	ETF	268.95	268.95	268.93	268.93	2700.0
2018-04-17 06:20:00	SPY	ETF	268.96	268.98	268.95	268.95	1100.0
2018-04-17 06:30:00	SPY	ETF	269.03	269.12	269.03	269.11	9535.0
2018-04-17 06:35:00	SPY	ETF	269.06	269.06	268.97	269.02	25779.0
2018-04-17 06:40:00	SPY	ETF	269.03	269.08	268.97	268.97	68375.0
2018-04-17 06:45:00	SPY	ETF	268.98	269.05	268.92	269.05	42350.0
2018-04-17 06:50:00	SPY	ETF	269.03	269.17	269.03	269.14	39361.0
2018-04-17 06:55:00	SPY	ETF	269.15	269.15	269.08	269.11	1800.0
2018-04-17 07:00:00	SPY	ETF	269.09	269.09	268.88	268.88	31088.0
2018-04-17 07:05:00	SPY	ETF	268.93	269.04	268.93	269.01	6835.0
2018-04-17 07:10:00	SPY	ETF	269.02	269.02	268.89	269.0	9300.0
2018-04-17 07:15:00	SPY	ETF	269.0	269.01	268.96	268.98	7100.0
2018-04-17 07:20:00	SPY	ETF	268.99	269.04	268.88	268.88	17325.0
2018-04-17 07:25:00	SPY	ETF	268.92	268.92	268.9	268.91	2050.0
2018-04-17 07:30:00	SPY	ETF	268.9	268.9	268.88	268.9	13850.0
2018-04-17 07:35:00	SPY	ETF	268.9	269.08	268.9	269.02	30475.0
2018-04-17 07:40:00	SPY	ETF	269.02	269.05	269.02	269.04	14955.0
2018-04-17 07:45:00	SPY	ETF	269.03	269.08	269.03	269.08	13417.0
2018-04-17 07:50:00	SPY	ETF	269.04	269.05	269.01	269.02	2595.0
2018-04-17 07:55:00	SPY	ETF	269.04	269.05	269.01	269.03	22660.0
2018-04-17 08:00:00	SPY	ETF	269.04	269.25	268.37	269.24	182628.0
2018-04-17 08:05:00	SPY	ETF	269.25	269.35	269.25	269.32	45082.0
2018-04-17 08:10:00	SPY	ETF	269.32	269.35	269.25	269.3	28092.0
2018-04-17 08:15:00	SPY	ETF	269.3	269.33	269.3	269.31	14725.0
2018-04-17 08:20:00	SPY	ETF	269.3	269.35	269.23	269.28	36114.0

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

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