PREVIEW / etf_5min / 2018-11-23

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-11-23.parquet
  size:    802 KB
  rows:    32,594

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-11-23 04:00:00	SPY	ETF	264.39	264.41	264.3	264.41	2973.0
2018-11-23 04:05:00	SPY	ETF	264.48	264.48	264.44	264.44	856.0
2018-11-23 04:10:00	SPY	ETF	264.33	264.33	264.28	264.28	1400.0
2018-11-23 04:15:00	SPY	ETF	264.44	264.44	264.3	264.3	450.0
2018-11-23 04:20:00	SPY	ETF	264.31	264.48	264.31	264.48	1850.0
2018-11-23 04:25:00	SPY	ETF	264.48	264.51	264.48	264.51	269.0
2018-11-23 04:30:00	SPY	ETF	264.51	264.51	264.4	264.4	4099.0
2018-11-23 04:40:00	SPY	ETF	264.42	264.42	264.38	264.38	330.0
2018-11-23 04:45:00	SPY	ETF	264.48	264.52	264.48	264.52	507.0
2018-11-23 04:50:00	SPY	ETF	264.54	264.56	264.54	264.56	569.0
2018-11-23 05:00:00	SPY	ETF	264.58	264.6	264.45	264.45	1147.0
2018-11-23 05:05:00	SPY	ETF	264.44	264.64	264.41	264.44	8480.0
2018-11-23 05:10:00	SPY	ETF	264.4	264.4	264.4	264.4	100.0
2018-11-23 05:15:00	SPY	ETF	264.35	264.35	264.3	264.3	338.0
2018-11-23 05:25:00	SPY	ETF	264.3	264.3	264.2	264.2	413.0
2018-11-23 05:30:00	SPY	ETF	264.2	264.2	264.2	264.2	338.0
2018-11-23 05:35:00	SPY	ETF	264.1	264.1	263.92	263.92	995.0
2018-11-23 05:40:00	SPY	ETF	263.95	264.19	263.94	263.94	1438.0
2018-11-23 05:45:00	SPY	ETF	263.89	263.89	263.79	263.79	5905.0
2018-11-23 05:50:00	SPY	ETF	263.81	263.81	263.65	263.74	1020.0
2018-11-23 05:55:00	SPY	ETF	263.78	263.85	263.74	263.82	2141.0
2018-11-23 06:05:00	SPY	ETF	263.79	263.9	263.79	263.9	1445.0
2018-11-23 06:10:00	SPY	ETF	263.9	264.0	263.9	264.0	1371.0
2018-11-23 06:15:00	SPY	ETF	263.9	263.95	263.9	263.95	304.0
2018-11-23 06:20:00	SPY	ETF	263.94	263.94	263.8	263.85	2769.0
2018-11-23 06:25:00	SPY	ETF	263.85	263.85	263.72	263.85	1432.0
2018-11-23 06:30:00	SPY	ETF	263.9	264.0	263.6	263.6	2397.0
2018-11-23 06:35:00	SPY	ETF	263.76	263.76	263.75	263.75	1000.0
2018-11-23 06:40:00	SPY	ETF	263.75	263.8	263.74	263.8	930.0
2018-11-23 06:45:00	SPY	ETF	263.76	263.85	263.74	263.78	5769.0
2018-11-23 06:50:00	SPY	ETF	263.84	263.9	263.8	263.8	1200.0
2018-11-23 06:55:00	SPY	ETF	263.75	263.79	263.55	263.79	1805.0
2018-11-23 07:00:00	SPY	ETF	263.74	263.9	263.64	263.9	11901.0
2018-11-23 07:05:00	SPY	ETF	263.8	263.83	263.57	263.6	16866.0
2018-11-23 07:10:00	SPY	ETF	263.57	263.68	263.55	263.67	2750.0
2018-11-23 07:15:00	SPY	ETF	263.67	263.89	263.6	263.89	5501.0
2018-11-23 07:20:00	SPY	ETF	263.85	263.85	263.65	263.85	16234.0
2018-11-23 07:25:00	SPY	ETF	263.83	263.88	263.65	263.86	11213.0
2018-11-23 07:30:00	SPY	ETF	263.8	263.81	263.7	263.7	11110.0
2018-11-23 07:35:00	SPY	ETF	263.83	263.94	263.83	263.9	30389.0
2018-11-23 07:40:00	SPY	ETF	263.95	263.98	263.93	263.93	5756.0
2018-11-23 07:45:00	SPY	ETF	263.93	263.95	263.93	263.93	8783.0
2018-11-23 07:50:00	SPY	ETF	263.97	264.08	263.93	264.02	9677.0
2018-11-23 07:55:00	SPY	ETF	264.02	264.05	264.0	264.0	24520.0
2018-11-23 08:00:00	SPY	ETF	263.71	264.55	263.6	264.02	63779.0
2018-11-23 08:05:00	SPY	ETF	264.0	264.01	263.82	263.87	23297.0
2018-11-23 08:10:00	SPY	ETF	263.88	263.92	263.86	263.87	29981.0
2018-11-23 08:15:00	SPY	ETF	263.83	263.83	263.67	263.73	9581.0
2018-11-23 08:20:00	SPY	ETF	263.72	263.72	263.6	263.67	40866.0
2018-11-23 08:25:00	SPY	ETF	263.67	263.67	263.5	263.6	106959.0

> showing 50 of 32,594 rows — these rows as CSV

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