PREVIEW / etf_1min / 2017-04-13

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-04-13.parquet
  size:    2.8 MB
  rows:    146,188

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
2017-04-13 04:00:00	SPY	ETF	233.9	233.9	233.73	233.73	870.0
2017-04-13 04:04:00	SPY	ETF	233.79	233.79	233.75	233.75	600.0
2017-04-13 04:05:00	SPY	ETF	233.7	233.7	233.68	233.7	900.0
2017-04-13 04:08:00	SPY	ETF	233.72	233.72	233.72	233.72	200.0
2017-04-13 04:09:00	SPY	ETF	233.69	233.69	233.69	233.69	200.0
2017-04-13 04:15:00	SPY	ETF	233.66	233.66	233.66	233.66	590.0
2017-04-13 04:16:00	SPY	ETF	233.6	233.6	233.6	233.6	2902.0
2017-04-13 04:17:00	SPY	ETF	233.6	233.6	233.54	233.58	2383.0
2017-04-13 04:23:00	SPY	ETF	233.64	233.64	233.64	233.64	102.0
2017-04-13 04:26:00	SPY	ETF	233.74	233.74	233.74	233.74	206.0
2017-04-13 04:30:00	SPY	ETF	233.7	233.7	233.7	233.7	100.0
2017-04-13 04:31:00	SPY	ETF	233.68	233.68	233.68	233.68	301.0
2017-04-13 04:32:00	SPY	ETF	233.71	233.71	233.71	233.71	2300.0
2017-04-13 04:38:00	SPY	ETF	233.71	233.71	233.71	233.71	300.0
2017-04-13 04:43:00	SPY	ETF	233.74	233.74	233.74	233.74	306.0
2017-04-13 04:46:00	SPY	ETF	233.72	233.72	233.72	233.72	3000.0
2017-04-13 04:47:00	SPY	ETF	233.78	233.78	233.78	233.78	1401.0
2017-04-13 04:55:00	SPY	ETF	233.78	233.78	233.78	233.78	1000.0
2017-04-13 05:00:00	SPY	ETF	233.76	233.76	233.76	233.76	502.0
2017-04-13 05:15:00	SPY	ETF	233.69	233.69	233.69	233.69	300.0
2017-04-13 05:23:00	SPY	ETF	233.6	233.6	233.59	233.59	1651.0
2017-04-13 05:27:00	SPY	ETF	233.57	233.59	233.57	233.59	900.0
2017-04-13 05:30:00	SPY	ETF	233.51	233.51	233.51	233.51	303.0
2017-04-13 05:32:00	SPY	ETF	233.51	233.51	233.49	233.49	450.0
2017-04-13 05:33:00	SPY	ETF	233.51	233.51	233.51	233.51	800.0
2017-04-13 05:37:00	SPY	ETF	233.59	233.59	233.59	233.59	303.0
2017-04-13 05:38:00	SPY	ETF	233.56	233.56	233.56	233.56	104.0
2017-04-13 05:40:00	SPY	ETF	233.52	233.52	233.52	233.52	100.0
2017-04-13 05:47:00	SPY	ETF	233.51	233.51	233.51	233.51	1000.0
2017-04-13 05:48:00	SPY	ETF	233.51	233.51	233.51	233.51	302.0
2017-04-13 05:49:00	SPY	ETF	233.49	233.49	233.49	233.49	5000.0
2017-04-13 05:52:00	SPY	ETF	233.54	233.54	233.54	233.54	299.0
2017-04-13 05:54:00	SPY	ETF	233.49	233.49	233.49	233.49	700.0
2017-04-13 06:06:00	SPY	ETF	233.45	233.45	233.45	233.45	304.0
2017-04-13 06:07:00	SPY	ETF	233.45	233.45	233.45	233.45	100.0
2017-04-13 06:09:00	SPY	ETF	233.44	233.44	233.44	233.44	120.0
2017-04-13 06:10:00	SPY	ETF	233.4	233.4	233.4	233.4	24000.0
2017-04-13 06:11:00	SPY	ETF	233.4	233.4	233.4	233.4	25300.0
2017-04-13 06:14:00	SPY	ETF	233.43	233.43	233.41	233.41	2404.0
2017-04-13 06:16:00	SPY	ETF	233.4	233.4	233.4	233.4	396.0
2017-04-13 06:17:00	SPY	ETF	233.4	233.4	233.39	233.39	3000.0
2017-04-13 06:19:00	SPY	ETF	233.43	233.43	233.43	233.43	400.0
2017-04-13 06:21:00	SPY	ETF	233.4	233.4	233.4	233.4	1300.0
2017-04-13 06:26:00	SPY	ETF	233.34	233.34	233.34	233.34	106.0
2017-04-13 06:27:00	SPY	ETF	233.32	233.32	233.32	233.32	2000.0
2017-04-13 06:34:00	SPY	ETF	233.37	233.37	233.37	233.37	110.0
2017-04-13 06:37:00	SPY	ETF	233.35	233.35	233.35	233.35	314.0
2017-04-13 06:39:00	SPY	ETF	233.32	233.32	233.32	233.32	326.0
2017-04-13 06:40:00	SPY	ETF	233.28	233.28	233.28	233.28	5301.0
2017-04-13 06:41:00	SPY	ETF	233.3	233.31	233.3	233.31	5008.0

> showing 50 of 146,188 rows — these rows as CSV

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