PREVIEW / etf_1min / 2018-03-19

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-03-19.parquet
  size:    3.1 MB
  rows:    159,252

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-19 04:00:00	SPY	ETF	273.78	273.78	273.6	273.6	1449.0
2018-03-19 04:02:00	SPY	ETF	273.65	273.65	273.65	273.65	474.0
2018-03-19 04:03:00	SPY	ETF	273.68	273.68	273.67	273.67	640.0
2018-03-19 04:04:00	SPY	ETF	273.7	273.7	273.7	273.7	200.0
2018-03-19 04:05:00	SPY	ETF	273.67	273.68	273.67	273.68	900.0
2018-03-19 04:07:00	SPY	ETF	273.7	273.7	273.65	273.65	1700.0
2018-03-19 04:08:00	SPY	ETF	273.65	273.69	273.64	273.64	2750.0
2018-03-19 04:09:00	SPY	ETF	273.67	273.77	273.67	273.76	2012.0
2018-03-19 04:10:00	SPY	ETF	273.7	273.7	273.69	273.69	225.0
2018-03-19 04:11:00	SPY	ETF	273.67	273.67	273.59	273.59	1150.0
2018-03-19 04:14:00	SPY	ETF	273.61	273.61	273.61	273.61	120.0
2018-03-19 04:16:00	SPY	ETF	273.57	273.57	273.57	273.57	200.0
2018-03-19 04:17:00	SPY	ETF	273.54	273.54	273.37	273.37	2463.0
2018-03-19 04:18:00	SPY	ETF	273.3	273.31	273.2	273.2	4377.0
2018-03-19 04:19:00	SPY	ETF	273.16	273.21	273.16	273.18	1253.0
2018-03-19 04:20:00	SPY	ETF	273.08	273.08	272.96	272.96	2280.0
2018-03-19 04:21:00	SPY	ETF	272.94	272.94	272.94	272.94	510.0
2018-03-19 04:22:00	SPY	ETF	273.02	273.02	272.99	273.01	1208.0
2018-03-19 04:23:00	SPY	ETF	273.03	273.03	272.95	272.95	444.0
2018-03-19 04:24:00	SPY	ETF	272.94	272.94	272.94	272.94	500.0
2018-03-19 04:25:00	SPY	ETF	272.92	272.98	272.92	272.98	2103.0
2018-03-19 04:26:00	SPY	ETF	272.98	272.98	272.94	272.94	1200.0
2018-03-19 04:27:00	SPY	ETF	272.9	272.9	272.57	272.62	6045.0
2018-03-19 04:28:00	SPY	ETF	272.64	272.64	272.47	272.47	2694.0
2018-03-19 04:29:00	SPY	ETF	272.48	272.52	272.44	272.44	2065.0
2018-03-19 04:30:00	SPY	ETF	272.37	272.61	272.37	272.61	2917.0
2018-03-19 04:31:00	SPY	ETF	272.59	272.68	272.56	272.56	1263.0
2018-03-19 04:32:00	SPY	ETF	272.6	272.6	272.56	272.56	240.0
2018-03-19 04:33:00	SPY	ETF	272.52	272.54	272.51	272.54	1167.0
2018-03-19 04:36:00	SPY	ETF	272.47	272.47	272.47	272.47	107.0
2018-03-19 04:38:00	SPY	ETF	272.3	272.3	272.25	272.25	311.0
2018-03-19 04:39:00	SPY	ETF	272.34	272.34	272.2	272.2	1686.0
2018-03-19 04:40:00	SPY	ETF	272.18	272.35	272.18	272.35	4506.0
2018-03-19 04:41:00	SPY	ETF	272.3	272.3	272.3	272.3	203.0
2018-03-19 04:42:00	SPY	ETF	272.42	272.42	272.41	272.41	2906.0
2018-03-19 04:43:00	SPY	ETF	272.37	272.4	272.36	272.4	1408.0
2018-03-19 04:44:00	SPY	ETF	272.35	272.36	272.33	272.33	652.0
2018-03-19 04:45:00	SPY	ETF	272.37	272.37	272.34	272.34	303.0
2018-03-19 04:46:00	SPY	ETF	272.49	272.49	272.49	272.49	156.0
2018-03-19 04:47:00	SPY	ETF	272.5	272.5	272.48	272.48	399.0
2018-03-19 04:51:00	SPY	ETF	272.63	272.64	272.63	272.64	1207.0
2018-03-19 04:52:00	SPY	ETF	272.65	272.65	272.65	272.65	1102.0
2018-03-19 04:53:00	SPY	ETF	272.57	272.57	272.57	272.57	902.0
2018-03-19 04:56:00	SPY	ETF	272.5	272.54	272.5	272.54	606.0
2018-03-19 04:58:00	SPY	ETF	272.56	272.7	272.56	272.7	1861.0
2018-03-19 05:01:00	SPY	ETF	272.58	272.65	272.58	272.65	1110.0
2018-03-19 05:02:00	SPY	ETF	272.76	272.78	272.76	272.78	3306.0
2018-03-19 05:03:00	SPY	ETF	272.7	272.71	272.7	272.7	2003.0
2018-03-19 05:04:00	SPY	ETF	272.72	272.79	272.72	272.79	318.0
2018-03-19 05:05:00	SPY	ETF	272.78	272.78	272.78	272.78	701.0

> showing 50 of 159,252 rows — these rows as CSV

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