PREVIEW / etf_1min / 2018-11-27

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-11-27.parquet
  size:    3.2 MB
  rows:    166,399

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-27 04:00:00	SPY	ETF	266.8	266.8	266.75	266.75	1200.0
2018-11-27 04:01:00	SPY	ETF	266.72	266.75	266.72	266.75	2457.0
2018-11-27 04:02:00	SPY	ETF	266.65	266.7	266.65	266.7	7515.0
2018-11-27 04:03:00	SPY	ETF	266.7	266.72	266.7	266.72	9000.0
2018-11-27 04:04:00	SPY	ETF	266.7	266.7	266.7	266.7	125.0
2018-11-27 04:05:00	SPY	ETF	266.7	266.7	266.7	266.7	4920.0
2018-11-27 04:08:00	SPY	ETF	266.97	267.0	266.97	267.0	410.0
2018-11-27 04:09:00	SPY	ETF	267.0	267.01	267.0	267.01	800.0
2018-11-27 04:10:00	SPY	ETF	266.97	266.97	266.95	266.95	900.0
2018-11-27 04:11:00	SPY	ETF	266.95	266.95	266.95	266.95	1000.0
2018-11-27 04:16:00	SPY	ETF	266.9	266.9	266.9	266.9	169.0
2018-11-27 04:17:00	SPY	ETF	267.0	267.01	267.0	267.01	500.0
2018-11-27 04:18:00	SPY	ETF	267.04	267.09	267.04	267.09	400.0
2018-11-27 04:19:00	SPY	ETF	267.15	267.15	267.15	267.15	3200.0
2018-11-27 04:20:00	SPY	ETF	267.15	267.15	267.13	267.13	700.0
2018-11-27 04:22:00	SPY	ETF	267.17	267.17	267.17	267.17	187.0
2018-11-27 04:24:00	SPY	ETF	267.18	267.3	267.18	267.28	3125.0
2018-11-27 04:27:00	SPY	ETF	267.18	267.39	267.17	267.38	5038.0
2018-11-27 04:28:00	SPY	ETF	267.37	267.43	267.37	267.43	1530.0
2018-11-27 04:29:00	SPY	ETF	267.34	267.34	267.34	267.34	169.0
2018-11-27 04:30:00	SPY	ETF	267.38	267.5	267.38	267.49	5197.0
2018-11-27 04:31:00	SPY	ETF	267.47	267.47	267.47	267.47	1000.0
2018-11-27 04:32:00	SPY	ETF	267.37	267.37	267.37	267.37	169.0
2018-11-27 04:34:00	SPY	ETF	267.32	267.32	267.32	267.32	1000.0
2018-11-27 04:35:00	SPY	ETF	267.31	267.31	267.31	267.31	169.0
2018-11-27 04:36:00	SPY	ETF	267.35	267.35	267.23	267.23	870.0
2018-11-27 04:42:00	SPY	ETF	267.21	267.21	267.21	267.21	172.0
2018-11-27 04:43:00	SPY	ETF	267.21	267.27	267.21	267.27	2000.0
2018-11-27 04:44:00	SPY	ETF	267.18	267.18	267.12	267.12	1600.0
2018-11-27 04:45:00	SPY	ETF	267.12	267.12	267.06	267.06	507.0
2018-11-27 04:46:00	SPY	ETF	267.02	267.04	267.02	267.02	838.0
2018-11-27 04:47:00	SPY	ETF	267.0	267.0	267.0	267.0	1600.0
2018-11-27 04:56:00	SPY	ETF	266.94	266.94	266.94	266.94	500.0
2018-11-27 04:57:00	SPY	ETF	266.84	266.84	266.84	266.84	100.0
2018-11-27 05:04:00	SPY	ETF	266.85	266.85	266.85	266.85	200.0
2018-11-27 05:08:00	SPY	ETF	266.99	266.99	266.99	266.99	100.0
2018-11-27 05:10:00	SPY	ETF	266.84	266.84	266.84	266.84	1000.0
2018-11-27 05:11:00	SPY	ETF	266.86	266.99	266.86	266.99	2500.0
2018-11-27 05:14:00	SPY	ETF	266.74	266.74	266.74	266.74	1100.0
2018-11-27 05:15:00	SPY	ETF	266.74	266.74	266.74	266.74	1700.0
2018-11-27 05:18:00	SPY	ETF	266.76	266.76	266.76	266.76	1200.0
2018-11-27 05:19:00	SPY	ETF	266.88	266.88	266.88	266.88	100.0
2018-11-27 05:22:00	SPY	ETF	266.74	266.74	266.65	266.66	3600.0
2018-11-27 05:25:00	SPY	ETF	266.74	266.74	266.74	266.74	100.0
2018-11-27 05:26:00	SPY	ETF	266.73	266.73	266.66	266.66	200.0
2018-11-27 05:27:00	SPY	ETF	266.84	266.84	266.84	266.84	800.0
2018-11-27 05:32:00	SPY	ETF	266.68	266.68	266.68	266.68	400.0
2018-11-27 05:33:00	SPY	ETF	266.64	266.64	266.64	266.64	100.0
2018-11-27 05:34:00	SPY	ETF	266.54	266.54	266.46	266.46	10215.0
2018-11-27 05:35:00	SPY	ETF	266.5	266.5	266.5	266.5	325.0

> showing 50 of 166,399 rows — these rows as CSV

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