PREVIEW / etf_5min / 2018-05-29

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-05-29.parquet
  size:    1.4 MB
  rows:    60,694

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-05-29 04:00:00	SPY	ETF	270.9	270.9	270.71	270.71	8798.0
2018-05-29 04:05:00	SPY	ETF	270.73	270.73	270.71	270.71	2908.0
2018-05-29 04:10:00	SPY	ETF	270.71	270.73	270.71	270.73	1250.0
2018-05-29 04:15:00	SPY	ETF	270.65	270.65	270.48	270.48	2139.0
2018-05-29 04:20:00	SPY	ETF	270.47	270.5	270.32	270.32	927.0
2018-05-29 04:25:00	SPY	ETF	270.34	270.34	270.0	270.0	9084.0
2018-05-29 04:30:00	SPY	ETF	269.94	269.94	269.33	269.56	28649.0
2018-05-29 04:35:00	SPY	ETF	269.5	269.73	269.48	269.73	9288.0
2018-05-29 04:40:00	SPY	ETF	269.67	269.92	269.67	269.84	6749.0
2018-05-29 04:45:00	SPY	ETF	269.92	270.01	269.92	269.97	6020.0
2018-05-29 04:50:00	SPY	ETF	270.02	270.02	269.84	269.84	2930.0
2018-05-29 04:55:00	SPY	ETF	269.81	270.0	269.81	269.92	21000.0
2018-05-29 05:00:00	SPY	ETF	269.92	269.94	269.74	269.94	31320.0
2018-05-29 05:05:00	SPY	ETF	269.96	270.11	269.94	270.11	2720.0
2018-05-29 05:10:00	SPY	ETF	270.11	270.12	270.06	270.1	5570.0
2018-05-29 05:15:00	SPY	ETF	270.09	270.11	269.91	269.94	8947.0
2018-05-29 05:20:00	SPY	ETF	269.98	270.01	269.95	269.95	860.0
2018-05-29 05:25:00	SPY	ETF	270.03	270.11	269.95	270.11	3520.0
2018-05-29 05:30:00	SPY	ETF	269.94	269.94	269.9	269.9	407.0
2018-05-29 05:35:00	SPY	ETF	270.04	270.1	270.04	270.1	1200.0
2018-05-29 05:40:00	SPY	ETF	270.03	270.03	269.93	269.93	1436.0
2018-05-29 05:45:00	SPY	ETF	269.91	269.91	269.79	269.83	8693.0
2018-05-29 05:50:00	SPY	ETF	269.86	270.07	269.86	270.01	13726.0
2018-05-29 05:55:00	SPY	ETF	270.01	270.29	270.01	270.29	2440.0
2018-05-29 06:00:00	SPY	ETF	270.35	270.51	270.35	270.47	10426.0
2018-05-29 06:05:00	SPY	ETF	270.39	270.41	270.34	270.34	25660.0
2018-05-29 06:10:00	SPY	ETF	270.38	270.49	270.38	270.49	70408.0
2018-05-29 06:15:00	SPY	ETF	270.34	270.42	270.3	270.3	11540.0
2018-05-29 06:20:00	SPY	ETF	270.31	270.31	270.24	270.24	10760.0
2018-05-29 06:25:00	SPY	ETF	270.24	270.41	270.23	270.35	26950.0
2018-05-29 06:30:00	SPY	ETF	270.24	270.36	270.01	270.01	9010.0
2018-05-29 06:35:00	SPY	ETF	270.02	270.07	269.89	270.05	25102.0
2018-05-29 06:40:00	SPY	ETF	270.14	270.18	270.08	270.18	11900.0
2018-05-29 06:45:00	SPY	ETF	270.08	270.08	270.0	270.0	2700.0
2018-05-29 06:50:00	SPY	ETF	269.92	269.92	269.8	269.82	15760.0
2018-05-29 06:55:00	SPY	ETF	269.81	269.88	269.81	269.87	3752.0
2018-05-29 07:00:00	SPY	ETF	269.87	269.98	269.66	269.72	69170.0
2018-05-29 07:05:00	SPY	ETF	269.7	269.72	269.57	269.7	46857.0
2018-05-29 07:10:00	SPY	ETF	269.7	269.77	269.69	269.75	7450.0
2018-05-29 07:15:00	SPY	ETF	269.84	269.9	269.82	269.9	30377.0
2018-05-29 07:20:00	SPY	ETF	269.9	270.04	269.88	270.04	48555.0
2018-05-29 07:25:00	SPY	ETF	270.02	270.03	269.97	270.02	24890.0
2018-05-29 07:30:00	SPY	ETF	270.0	270.28	270.0	270.15	61137.0
2018-05-29 07:35:00	SPY	ETF	270.13	270.26	270.12	270.23	20455.0
2018-05-29 07:40:00	SPY	ETF	270.2	270.2	270.16	270.19	30735.0
2018-05-29 07:45:00	SPY	ETF	270.13	270.25	270.12	270.25	18512.0
2018-05-29 07:50:00	SPY	ETF	270.24	270.44	270.24	270.38	116942.0
2018-05-29 07:55:00	SPY	ETF	270.32	270.32	270.21	270.24	42864.0
2018-05-29 08:00:00	SPY	ETF	269.6201	271.75	269.605	270.25	44406.0
2018-05-29 08:05:00	SPY	ETF	270.25	271.38	270.18	270.25	224013.0

> showing 50 of 60,694 rows — these rows as CSV

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