PREVIEW / etf_1min / 2018-03-01

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-03-01.parquet
  size:    3.5 MB
  rows:    179,637

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-03-01 04:00:00	SPY	ETF	272.0	272.0	272.0	272.0	2745.0
2018-03-01 04:03:00	SPY	ETF	271.82	271.82	271.62	271.62	12525.0
2018-03-01 04:04:00	SPY	ETF	271.66	271.68	271.65	271.68	1950.0
2018-03-01 04:05:00	SPY	ETF	271.71	271.72	271.66	271.71	10800.0
2018-03-01 04:06:00	SPY	ETF	271.67	271.67	271.51	271.51	600.0
2018-03-01 04:08:00	SPY	ETF	271.59	271.59	271.59	271.59	5000.0
2018-03-01 04:09:00	SPY	ETF	271.59	271.59	271.59	271.59	300.0
2018-03-01 04:10:00	SPY	ETF	271.65	271.67	271.65	271.67	1540.0
2018-03-01 04:11:00	SPY	ETF	271.59	271.59	271.59	271.59	200.0
2018-03-01 04:14:00	SPY	ETF	271.58	271.58	271.49	271.49	574.0
2018-03-01 04:16:00	SPY	ETF	271.46	271.54	271.46	271.54	1015.0
2018-03-01 04:17:00	SPY	ETF	271.54	271.54	271.54	271.54	2800.0
2018-03-01 04:19:00	SPY	ETF	271.59	271.59	271.59	271.59	1550.0
2018-03-01 04:20:00	SPY	ETF	271.55	271.55	271.55	271.55	200.0
2018-03-01 04:21:00	SPY	ETF	271.56	271.56	271.56	271.56	130.0
2018-03-01 04:23:00	SPY	ETF	271.58	271.58	271.56	271.56	450.0
2018-03-01 04:25:00	SPY	ETF	271.74	271.74	271.74	271.74	270.0
2018-03-01 04:26:00	SPY	ETF	271.76	271.76	271.76	271.76	100.0
2018-03-01 04:28:00	SPY	ETF	271.7	271.72	271.69	271.69	2100.0
2018-03-01 04:29:00	SPY	ETF	271.73	271.73	271.72	271.72	1000.0
2018-03-01 04:32:00	SPY	ETF	271.76	271.76	271.76	271.76	520.0
2018-03-01 04:33:00	SPY	ETF	271.81	271.81	271.81	271.81	510.0
2018-03-01 04:34:00	SPY	ETF	271.77	271.78	271.77	271.78	2000.0
2018-03-01 04:35:00	SPY	ETF	271.73	271.73	271.7	271.7	4080.0
2018-03-01 04:37:00	SPY	ETF	271.49	271.52	271.49	271.52	250.0
2018-03-01 04:39:00	SPY	ETF	271.27	271.27	271.27	271.27	301.0
2018-03-01 04:40:00	SPY	ETF	271.3	271.31	271.28	271.3	11552.0
2018-03-01 04:41:00	SPY	ETF	271.3	271.3	271.14	271.14	1588.0
2018-03-01 04:42:00	SPY	ETF	271.17	271.17	271.08	271.1	6910.0
2018-03-01 04:43:00	SPY	ETF	271.09	271.09	270.93	270.93	6696.0
2018-03-01 04:44:00	SPY	ETF	270.94	270.96	270.9	270.95	5311.0
2018-03-01 04:45:00	SPY	ETF	271.05	271.05	270.95	270.95	2090.0
2018-03-01 04:46:00	SPY	ETF	271.05	271.05	271.04	271.04	1802.0
2018-03-01 04:47:00	SPY	ETF	271.02	271.12	271.02	271.12	1187.0
2018-03-01 04:48:00	SPY	ETF	271.08	271.15	271.08	271.08	2709.0
2018-03-01 04:49:00	SPY	ETF	271.08	271.08	271.08	271.08	203.0
2018-03-01 04:50:00	SPY	ETF	271.03	271.03	271.03	271.03	307.0
2018-03-01 04:51:00	SPY	ETF	271.0	271.0	270.98	271.0	1979.0
2018-03-01 04:52:00	SPY	ETF	270.92	270.92	270.92	270.92	454.0
2018-03-01 04:53:00	SPY	ETF	270.91	270.91	270.91	270.91	704.0
2018-03-01 04:54:00	SPY	ETF	270.77	270.77	270.77	270.77	1310.0
2018-03-01 04:55:00	SPY	ETF	270.74	270.75	270.72	270.75	1906.0
2018-03-01 04:56:00	SPY	ETF	270.87	270.92	270.87	270.92	1009.0
2018-03-01 04:57:00	SPY	ETF	270.83	270.83	270.83	270.83	511.0
2018-03-01 05:00:00	SPY	ETF	270.95	270.95	270.95	270.95	506.0
2018-03-01 05:01:00	SPY	ETF	270.85	270.85	270.8	270.8	459.0
2018-03-01 05:03:00	SPY	ETF	271.13	271.13	271.13	271.13	153.0
2018-03-01 05:04:00	SPY	ETF	271.15	271.15	271.15	271.15	507.0
2018-03-01 05:06:00	SPY	ETF	271.13	271.15	271.13	271.15	1108.0
2018-03-01 05:07:00	SPY	ETF	271.09	271.17	271.09	271.17	1760.0

> showing 50 of 179,637 rows — these rows as CSV

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