PREVIEW / etf_5min / 2019-01-09

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-01-09.parquet
  size:    1.5 MB
  rows:    66,077

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
2019-01-09 04:00:00	SPY	ETF	257.5	257.5	257.36	257.39	4176.0
2019-01-09 04:05:00	SPY	ETF	257.31	257.44	257.3	257.4	3907.0
2019-01-09 04:10:00	SPY	ETF	257.46	257.6	257.38	257.48	5142.0
2019-01-09 04:15:00	SPY	ETF	257.49	257.56	257.48	257.55	2355.0
2019-01-09 04:20:00	SPY	ETF	257.5	257.75	257.5	257.67	5923.0
2019-01-09 04:25:00	SPY	ETF	257.65	257.65	257.59	257.59	1251.0
2019-01-09 04:30:00	SPY	ETF	257.67	257.74	257.65	257.71	2499.0
2019-01-09 04:35:00	SPY	ETF	257.74	257.75	257.72	257.75	1819.0
2019-01-09 04:40:00	SPY	ETF	257.7	257.75	257.68	257.68	4869.0
2019-01-09 04:45:00	SPY	ETF	257.71	257.77	257.65	257.65	4607.0
2019-01-09 04:50:00	SPY	ETF	257.6	257.6	257.46	257.46	2107.0
2019-01-09 04:55:00	SPY	ETF	257.49	257.55	257.49	257.54	3879.0
2019-01-09 05:00:00	SPY	ETF	257.47	257.47	257.37	257.44	2577.0
2019-01-09 05:05:00	SPY	ETF	257.48	257.49	257.48	257.49	500.0
2019-01-09 05:10:00	SPY	ETF	257.43	257.6	257.43	257.55	2583.0
2019-01-09 05:15:00	SPY	ETF	257.5	257.62	257.47	257.53	9388.0
2019-01-09 05:20:00	SPY	ETF	257.5	257.5	257.24	257.24	4719.0
2019-01-09 05:25:00	SPY	ETF	257.28	257.28	257.01	257.06	3989.0
2019-01-09 05:30:00	SPY	ETF	257.05	257.05	257.05	257.05	1000.0
2019-01-09 05:35:00	SPY	ETF	257.14	257.15	257.09	257.09	1080.0
2019-01-09 05:40:00	SPY	ETF	257.04	257.23	257.04	257.2	4800.0
2019-01-09 05:45:00	SPY	ETF	257.2	257.2	257.14	257.18	3705.0
2019-01-09 05:50:00	SPY	ETF	257.25	257.26	257.25	257.26	300.0
2019-01-09 05:55:00	SPY	ETF	257.39	257.42	257.31	257.34	14370.0
2019-01-09 06:00:00	SPY	ETF	257.42	257.49	257.42	257.44	1869.0
2019-01-09 06:05:00	SPY	ETF	257.4	257.46	257.21	257.21	2320.0
2019-01-09 06:10:00	SPY	ETF	257.13	257.34	257.13	257.34	551.0
2019-01-09 06:15:00	SPY	ETF	257.3	257.4	257.19	257.19	5907.0
2019-01-09 06:20:00	SPY	ETF	257.12	257.12	257.12	257.12	1270.0
2019-01-09 06:25:00	SPY	ETF	257.12	257.14	257.09	257.11	2100.0
2019-01-09 06:30:00	SPY	ETF	257.1	257.1	256.9	256.9	18776.0
2019-01-09 06:35:00	SPY	ETF	257.0	257.02	257.0	257.02	400.0
2019-01-09 06:40:00	SPY	ETF	257.06	257.16	257.06	257.16	1001.0
2019-01-09 06:45:00	SPY	ETF	257.14	257.16	257.1	257.14	30100.0
2019-01-09 06:50:00	SPY	ETF	257.19	257.2	257.07	257.07	16100.0
2019-01-09 06:55:00	SPY	ETF	257.15	257.29	257.15	257.29	3127.0
2019-01-09 07:00:00	SPY	ETF	257.17	257.23	257.15	257.21	20229.0
2019-01-09 07:05:00	SPY	ETF	257.18	257.18	256.95	256.95	33012.0
2019-01-09 07:10:00	SPY	ETF	256.97	256.97	256.75	256.88	75970.0
2019-01-09 07:15:00	SPY	ETF	256.9	257.08	256.89	257.06	27675.0
2019-01-09 07:20:00	SPY	ETF	256.96	257.09	256.94	257.05	4825.0
2019-01-09 07:25:00	SPY	ETF	257.1	257.1	256.99	257.0	6380.0
2019-01-09 07:30:00	SPY	ETF	257.0	257.03	256.93	257.0	22565.0
2019-01-09 07:35:00	SPY	ETF	257.0	257.23	256.86	257.19	38052.0
2019-01-09 07:40:00	SPY	ETF	257.22	257.3	257.17	257.19	17336.0
2019-01-09 07:45:00	SPY	ETF	257.3	257.33	257.17	257.2	30428.0
2019-01-09 07:50:00	SPY	ETF	257.2	257.25	257.17	257.21	5808.0
2019-01-09 07:55:00	SPY	ETF	257.25	257.45	257.25	257.38	21087.0
2019-01-09 08:00:00	SPY	ETF	257.41	257.68	256.77	257.39	79787.0
2019-01-09 08:05:00	SPY	ETF	257.39	257.53	257.34	257.52	64338.0

> showing 50 of 66,077 rows — these rows as CSV

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