PREVIEW / etf_5min / 2018-11-20

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-11-20.parquet
  size:    1.6 MB
  rows:    67,526

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-20 04:00:00	SPY	ETF	267.93	267.93	267.7	267.7	3439.0
2018-11-20 04:05:00	SPY	ETF	267.63	267.76	267.27	267.27	4463.0
2018-11-20 04:10:00	SPY	ETF	267.43	267.62	267.4	267.55	5385.0
2018-11-20 04:15:00	SPY	ETF	267.5	267.7	267.4	267.7	6064.0
2018-11-20 04:20:00	SPY	ETF	267.58	267.64	267.58	267.64	1537.0
2018-11-20 04:25:00	SPY	ETF	267.79	267.83	267.72	267.72	924.0
2018-11-20 04:30:00	SPY	ETF	267.82	267.9	267.73	267.9	3900.0
2018-11-20 04:35:00	SPY	ETF	267.99	267.99	267.99	267.99	100.0
2018-11-20 04:40:00	SPY	ETF	268.0	268.05	267.85	267.92	1570.0
2018-11-20 04:45:00	SPY	ETF	267.92	267.92	267.66	267.66	1075.0
2018-11-20 04:50:00	SPY	ETF	267.67	267.67	267.67	267.67	500.0
2018-11-20 04:55:00	SPY	ETF	267.61	267.61	267.6	267.6	800.0
2018-11-20 05:00:00	SPY	ETF	267.61	267.61	267.52	267.54	5501.0
2018-11-20 05:05:00	SPY	ETF	267.47	267.48	267.4	267.48	6150.0
2018-11-20 05:10:00	SPY	ETF	267.51	267.51	267.4	267.45	4117.0
2018-11-20 05:15:00	SPY	ETF	267.44	267.44	267.35	267.41	4095.0
2018-11-20 05:20:00	SPY	ETF	267.58	267.76	267.54	267.73	6905.0
2018-11-20 05:25:00	SPY	ETF	267.86	267.99	267.81	267.92	14413.0
2018-11-20 05:30:00	SPY	ETF	267.92	267.93	267.66	267.66	19469.0
2018-11-20 05:35:00	SPY	ETF	267.66	267.69	267.51	267.65	24207.0
2018-11-20 05:40:00	SPY	ETF	267.66	267.86	267.6	267.78	7900.0
2018-11-20 05:45:00	SPY	ETF	267.78	267.93	267.77	267.93	13728.0
2018-11-20 05:50:00	SPY	ETF	267.92	267.96	267.75	267.79	14088.0
2018-11-20 05:55:00	SPY	ETF	267.76	267.78	267.52	267.66	11102.0
2018-11-20 06:00:00	SPY	ETF	267.63	267.66	267.45	267.48	3899.0
2018-11-20 06:05:00	SPY	ETF	267.5	267.68	267.49	267.61	4807.0
2018-11-20 06:10:00	SPY	ETF	267.59	267.72	267.59	267.72	6600.0
2018-11-20 06:15:00	SPY	ETF	267.79	267.82	267.67	267.74	26938.0
2018-11-20 06:20:00	SPY	ETF	267.74	267.75	267.54	267.54	8607.0
2018-11-20 06:25:00	SPY	ETF	267.51	267.51	267.47	267.47	6951.0
2018-11-20 06:30:00	SPY	ETF	267.47	267.75	267.27	267.74	28839.0
2018-11-20 06:35:00	SPY	ETF	267.72	268.06	267.71	268.04	13699.0
2018-11-20 06:40:00	SPY	ETF	268.04	268.12	267.93	268.12	13814.0
2018-11-20 06:45:00	SPY	ETF	268.15	268.31	268.1	268.12	15370.0
2018-11-20 06:50:00	SPY	ETF	268.15	268.16	268.1	268.1	30636.0
2018-11-20 06:55:00	SPY	ETF	268.1	268.15	268.06	268.1	293900.0
2018-11-20 07:00:00	SPY	ETF	268.1	268.1	267.39	267.51	183716.0
2018-11-20 07:05:00	SPY	ETF	267.52	267.61	267.38	267.61	140571.0
2018-11-20 07:10:00	SPY	ETF	267.63	267.69	267.5	267.58	101650.0
2018-11-20 07:15:00	SPY	ETF	267.56	267.6	267.42	267.45	49122.0
2018-11-20 07:20:00	SPY	ETF	267.5	267.52	267.33	267.36	39750.0
2018-11-20 07:25:00	SPY	ETF	267.31	267.35	267.15	267.24	23935.0
2018-11-20 07:30:00	SPY	ETF	267.2	267.21	267.1	267.16	18459.0
2018-11-20 07:35:00	SPY	ETF	267.11	267.34	267.11	267.34	22808.0
2018-11-20 07:40:00	SPY	ETF	267.36	267.36	267.07	267.09	31440.0
2018-11-20 07:45:00	SPY	ETF	267.07	267.13	266.67	266.7	71598.0
2018-11-20 07:50:00	SPY	ETF	266.69	266.81	266.5	266.62	114298.0
2018-11-20 07:55:00	SPY	ETF	266.63	266.66	266.21	266.31	101433.0
2018-11-20 08:00:00	SPY	ETF	267.46	268.95	266.32	266.36	106498.0
2018-11-20 08:05:00	SPY	ETF	266.38	266.71	266.24	266.63	59589.0

> showing 50 of 67,526 rows — these rows as CSV

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