PREVIEW / etf_1min / 2019-01-04

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-01-04.parquet
  size:    3.7 MB
  rows:    190,532

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-04 04:00:00	SPY	ETF	246.5	246.6	246.5	246.5	5453.0
2019-01-04 04:01:00	SPY	ETF	246.5	246.5	246.45	246.45	714.0
2019-01-04 04:03:00	SPY	ETF	246.39	246.45	246.39	246.45	1400.0
2019-01-04 04:06:00	SPY	ETF	246.44	246.6	246.44	246.6	7395.0
2019-01-04 04:07:00	SPY	ETF	246.6	246.6	246.6	246.6	550.0
2019-01-04 04:08:00	SPY	ETF	246.6	246.63	246.6	246.63	754.0
2019-01-04 04:09:00	SPY	ETF	246.65	246.7	246.65	246.7	886.0
2019-01-04 04:10:00	SPY	ETF	246.66	246.8	246.66	246.8	707.0
2019-01-04 04:11:00	SPY	ETF	246.7	246.73	246.7	246.73	338.0
2019-01-04 04:13:00	SPY	ETF	246.6	246.6	246.6	246.6	199.0
2019-01-04 04:14:00	SPY	ETF	246.6	246.6	246.6	246.6	469.0
2019-01-04 04:16:00	SPY	ETF	246.56	246.56	246.56	246.56	110.0
2019-01-04 04:17:00	SPY	ETF	246.59	246.59	246.56	246.56	469.0
2019-01-04 04:18:00	SPY	ETF	246.52	246.54	246.52	246.54	1225.0
2019-01-04 04:19:00	SPY	ETF	246.54	246.54	246.54	246.54	235.0
2019-01-04 04:21:00	SPY	ETF	246.39	246.39	246.39	246.39	169.0
2019-01-04 04:22:00	SPY	ETF	246.36	247.0	246.28	246.86	3235.0
2019-01-04 04:23:00	SPY	ETF	246.9	247.05	246.88	247.05	6089.0
2019-01-04 04:24:00	SPY	ETF	246.94	246.94	246.94	246.94	150.0
2019-01-04 04:25:00	SPY	ETF	246.84	246.89	246.84	246.86	880.0
2019-01-04 04:27:00	SPY	ETF	246.88	247.04	246.88	247.0	4451.0
2019-01-04 04:28:00	SPY	ETF	247.09	247.09	247.01	247.01	1210.0
2019-01-04 04:29:00	SPY	ETF	246.95	247.43	246.95	247.43	13154.0
2019-01-04 04:30:00	SPY	ETF	247.34	247.34	247.31	247.33	1420.0
2019-01-04 04:31:00	SPY	ETF	247.27	247.29	247.27	247.29	900.0
2019-01-04 04:32:00	SPY	ETF	247.25	247.32	247.25	247.25	2534.0
2019-01-04 04:34:00	SPY	ETF	247.3	247.35	247.3	247.35	269.0
2019-01-04 04:35:00	SPY	ETF	247.31	247.35	247.3	247.35	632.0
2019-01-04 04:36:00	SPY	ETF	247.3	247.33	247.29	247.33	638.0
2019-01-04 04:37:00	SPY	ETF	247.35	247.36	247.33	247.33	539.0
2019-01-04 04:38:00	SPY	ETF	247.36	247.36	247.36	247.36	200.0
2019-01-04 04:39:00	SPY	ETF	247.4	247.59	247.4	247.58	2692.0
2019-01-04 04:40:00	SPY	ETF	247.55	247.58	247.55	247.58	469.0
2019-01-04 04:41:00	SPY	ETF	247.52	247.58	247.52	247.58	450.0
2019-01-04 04:43:00	SPY	ETF	247.48	247.48	247.48	247.48	1730.0
2019-01-04 04:44:00	SPY	ETF	247.48	247.48	247.48	247.48	300.0
2019-01-04 04:45:00	SPY	ETF	247.49	247.49	247.47	247.47	1267.0
2019-01-04 04:46:00	SPY	ETF	247.47	247.47	247.41	247.42	2339.0
2019-01-04 04:47:00	SPY	ETF	247.41	247.41	247.35	247.35	572.0
2019-01-04 04:48:00	SPY	ETF	247.27	247.3	247.25	247.25	1638.0
2019-01-04 04:49:00	SPY	ETF	247.3	247.3	247.3	247.3	500.0
2019-01-04 04:50:00	SPY	ETF	247.35	247.35	247.34	247.34	369.0
2019-01-04 04:51:00	SPY	ETF	247.28	247.28	247.2	247.2	942.0
2019-01-04 04:52:00	SPY	ETF	247.22	247.22	247.22	247.22	127.0
2019-01-04 04:53:00	SPY	ETF	247.18	247.18	247.16	247.16	569.0
2019-01-04 04:54:00	SPY	ETF	247.17	247.17	247.17	247.17	431.0
2019-01-04 04:55:00	SPY	ETF	247.17	247.26	247.17	247.26	468.0
2019-01-04 04:56:00	SPY	ETF	247.24	247.24	247.24	247.24	320.0
2019-01-04 04:57:00	SPY	ETF	247.2	247.2	247.14	247.14	1338.0
2019-01-04 04:58:00	SPY	ETF	247.14	247.14	247.14	247.14	598.0

> showing 50 of 190,532 rows — these rows as CSV

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