PREVIEW / etf_5min / 2018-07-11

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-07-11.parquet
  size:    1.3 MB
  rows:    57,429

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-07-11 04:00:00	SPY	ETF	276.53	276.76	276.51	276.76	13745.0
2018-07-11 04:05:00	SPY	ETF	276.8	276.8	276.58	276.66	11670.0
2018-07-11 04:10:00	SPY	ETF	276.71	276.71	276.58	276.65	17300.0
2018-07-11 04:15:00	SPY	ETF	276.65	276.65	276.57	276.62	6520.0
2018-07-11 04:20:00	SPY	ETF	276.52	276.52	276.42	276.51	992.0
2018-07-11 04:25:00	SPY	ETF	276.47	276.54	276.47	276.54	1699.0
2018-07-11 04:30:00	SPY	ETF	276.53	276.63	276.53	276.63	810.0
2018-07-11 04:35:00	SPY	ETF	276.65	276.68	276.64	276.65	11500.0
2018-07-11 04:40:00	SPY	ETF	276.65	276.66	276.63	276.66	1600.0
2018-07-11 04:45:00	SPY	ETF	276.64	276.71	276.6	276.65	16500.0
2018-07-11 04:50:00	SPY	ETF	276.7	276.7	276.7	276.7	900.0
2018-07-11 04:55:00	SPY	ETF	276.76	276.88	276.76	276.88	750.0
2018-07-11 05:00:00	SPY	ETF	276.96	276.96	276.86	276.86	1470.0
2018-07-11 05:05:00	SPY	ETF	276.8	276.8	276.8	276.8	1000.0
2018-07-11 05:10:00	SPY	ETF	276.8	276.8	276.8	276.8	1000.0
2018-07-11 05:15:00	SPY	ETF	276.88	276.88	276.8	276.8	3000.0
2018-07-11 05:20:00	SPY	ETF	276.85	276.85	276.85	276.85	1000.0
2018-07-11 05:25:00	SPY	ETF	276.81	276.81	276.76	276.81	2550.0
2018-07-11 05:30:00	SPY	ETF	276.89	276.89	276.76	276.76	4550.0
2018-07-11 05:35:00	SPY	ETF	276.71	276.71	276.6	276.6	4402.0
2018-07-11 05:40:00	SPY	ETF	276.6	276.71	276.6	276.71	2110.0
2018-07-11 05:45:00	SPY	ETF	276.73	276.75	276.72	276.72	13550.0
2018-07-11 05:50:00	SPY	ETF	276.7	276.73	276.7	276.73	298.0
2018-07-11 05:55:00	SPY	ETF	276.74	276.74	276.67	276.74	4560.0
2018-07-11 06:00:00	SPY	ETF	276.78	276.79	276.74	276.76	3718.0
2018-07-11 06:05:00	SPY	ETF	276.74	276.77	276.69	276.77	6385.0
2018-07-11 06:10:00	SPY	ETF	276.76	276.78	276.72	276.72	2900.0
2018-07-11 06:15:00	SPY	ETF	276.85	277.14	276.85	277.14	15550.0
2018-07-11 06:20:00	SPY	ETF	277.13	277.13	276.98	277.13	7750.0
2018-07-11 06:25:00	SPY	ETF	277.11	277.17	277.1	277.12	13700.0
2018-07-11 06:30:00	SPY	ETF	277.11	277.11	277.02	277.06	11200.0
2018-07-11 06:35:00	SPY	ETF	277.1	277.11	277.05	277.07	22400.0
2018-07-11 06:40:00	SPY	ETF	277.08	277.19	277.02	277.19	32042.0
2018-07-11 06:45:00	SPY	ETF	277.21	277.21	277.14	277.15	6962.0
2018-07-11 06:50:00	SPY	ETF	277.15	277.27	277.14	277.27	16620.0
2018-07-11 06:55:00	SPY	ETF	277.25	277.25	277.13	277.14	13850.0
2018-07-11 07:00:00	SPY	ETF	277.17	277.3	277.17	277.18	44387.0
2018-07-11 07:05:00	SPY	ETF	277.18	277.25	277.15	277.15	6310.0
2018-07-11 07:10:00	SPY	ETF	277.18	277.3	277.17	277.18	14910.0
2018-07-11 07:15:00	SPY	ETF	277.18	277.27	277.17	277.27	8622.0
2018-07-11 07:20:00	SPY	ETF	277.27	277.27	277.08	277.15	24940.0
2018-07-11 07:25:00	SPY	ETF	277.11	277.13	277.07	277.1	3704.0
2018-07-11 07:30:00	SPY	ETF	277.1	277.2	277.06	277.2	2041.0
2018-07-11 07:35:00	SPY	ETF	277.2	277.2	277.04	277.04	6300.0
2018-07-11 07:40:00	SPY	ETF	277.08	277.08	276.99	277.06	69327.0
2018-07-11 07:45:00	SPY	ETF	277.06	277.12	277.05	277.06	27779.0
2018-07-11 07:50:00	SPY	ETF	277.1	277.1	277.06	277.06	9385.0
2018-07-11 07:55:00	SPY	ETF	277.09	277.12	277.06	277.12	41590.0
2018-07-11 08:00:00	SPY	ETF	277.1738	277.3	276.46	277.1	14859.0
2018-07-11 08:05:00	SPY	ETF	277.15	277.32	277.14	277.32	46813.0

> showing 50 of 57,429 rows — these rows as CSV

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