PREVIEW / etf_5min / 2018-04-06

all etf 5-min files

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

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-06 04:00:00	SPY	ETF	263.23	263.56	263.23	263.45	2870.0
2018-04-06 04:05:00	SPY	ETF	263.49	263.53	263.34	263.34	3841.0
2018-04-06 04:10:00	SPY	ETF	263.43	263.5	263.43	263.47	535.0
2018-04-06 04:20:00	SPY	ETF	263.35	263.46	263.35	263.46	1820.0
2018-04-06 04:25:00	SPY	ETF	263.41	263.69	263.4	263.69	1709.0
2018-04-06 04:30:00	SPY	ETF	263.64	263.67	263.59	263.59	941.0
2018-04-06 04:35:00	SPY	ETF	263.58	263.61	263.5	263.61	10091.0
2018-04-06 04:45:00	SPY	ETF	263.67	263.7	263.67	263.7	3192.0
2018-04-06 04:50:00	SPY	ETF	263.71	263.71	263.71	263.71	500.0
2018-04-06 04:55:00	SPY	ETF	263.63	263.63	263.63	263.63	141.0
2018-04-06 05:00:00	SPY	ETF	263.65	263.65	263.65	263.65	241.0
2018-04-06 05:05:00	SPY	ETF	263.51	263.51	263.39	263.41	2971.0
2018-04-06 05:10:00	SPY	ETF	263.53	263.6	263.53	263.6	3076.0
2018-04-06 05:15:00	SPY	ETF	263.63	263.68	263.63	263.68	3325.0
2018-04-06 05:20:00	SPY	ETF	263.83	263.86	263.78	263.78	3961.0
2018-04-06 05:25:00	SPY	ETF	263.78	263.81	263.73	263.81	3641.0
2018-04-06 05:30:00	SPY	ETF	263.78	263.78	263.65	263.65	5941.0
2018-04-06 05:35:00	SPY	ETF	263.7	263.7	263.7	263.7	500.0
2018-04-06 05:40:00	SPY	ETF	263.75	263.81	263.75	263.81	1620.0
2018-04-06 05:45:00	SPY	ETF	263.83	263.83	263.68	263.79	2741.0
2018-04-06 05:50:00	SPY	ETF	263.7	263.89	263.7	263.89	11544.0
2018-04-06 05:55:00	SPY	ETF	263.96	263.96	263.91	263.91	3191.0
2018-04-06 06:00:00	SPY	ETF	263.88	264.07	263.88	264.07	9871.0
2018-04-06 06:05:00	SPY	ETF	264.07	264.1	264.02	264.02	1342.0
2018-04-06 06:10:00	SPY	ETF	264.03	264.03	263.97	263.98	5261.0
2018-04-06 06:15:00	SPY	ETF	264.12	264.23	264.05	264.21	8950.0
2018-04-06 06:20:00	SPY	ETF	264.13	264.14	264.07	264.12	9071.0
2018-04-06 06:25:00	SPY	ETF	264.15	264.24	264.15	264.24	1100.0
2018-04-06 06:30:00	SPY	ETF	264.24	264.33	264.24	264.26	2406.0
2018-04-06 06:35:00	SPY	ETF	264.1	264.13	264.09	264.09	8758.0
2018-04-06 06:40:00	SPY	ETF	264.09	264.13	264.09	264.13	4100.0
2018-04-06 06:45:00	SPY	ETF	264.05	264.12	263.9	263.9	9581.0
2018-04-06 06:50:00	SPY	ETF	263.86	263.96	263.84	263.96	7311.0
2018-04-06 06:55:00	SPY	ETF	263.97	264.0	263.85	263.95	24712.0
2018-04-06 07:00:00	SPY	ETF	263.96	264.02	263.55	263.56	24231.0
2018-04-06 07:05:00	SPY	ETF	263.61	263.61	263.15	263.3	39055.0
2018-04-06 07:10:00	SPY	ETF	263.25	263.36	263.15	263.32	47086.0
2018-04-06 07:15:00	SPY	ETF	263.3	263.3	263.05	263.09	47221.0
2018-04-06 07:20:00	SPY	ETF	263.1	263.36	263.1	263.36	23405.0
2018-04-06 07:25:00	SPY	ETF	263.36	263.5	263.25	263.45	30675.0
2018-04-06 07:30:00	SPY	ETF	263.45	263.55	263.31	263.49	31944.0
2018-04-06 07:35:00	SPY	ETF	263.45	263.6	263.31	263.5	7532.0
2018-04-06 07:40:00	SPY	ETF	263.49	263.5	263.39	263.39	33331.0
2018-04-06 07:45:00	SPY	ETF	263.39	263.39	263.0	263.01	30714.0
2018-04-06 07:50:00	SPY	ETF	263.02	263.1	262.92	262.96	32137.0
2018-04-06 07:55:00	SPY	ETF	263.0	263.13	262.88	262.91	43395.0
2018-04-06 08:00:00	SPY	ETF	263.46	263.96	262.49	263.14	102361.0
2018-04-06 08:05:00	SPY	ETF	262.3	263.25	262.3	263.18	91907.0
2018-04-06 08:10:00	SPY	ETF	263.17	263.26	263.14	263.26	42699.0
2018-04-06 08:15:00	SPY	ETF	263.25	263.54	263.25	263.54	50282.0

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

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