PREVIEW / etf_30min / 2017-11-15

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-15.parquet
  size:    451 KB
  rows:    15,663

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-11-15 04:00:00	SPY	ETF	256.78	256.85	256.7	256.8	10757.0
2017-11-15 04:30:00	SPY	ETF	256.77	256.77	256.47	256.7	11251.0
2017-11-15 05:00:00	SPY	ETF	256.71	256.71	256.3	256.3	8557.0
2017-11-15 05:30:00	SPY	ETF	256.3	256.42	256.3	256.42	18452.0
2017-11-15 06:00:00	SPY	ETF	256.45	256.5	256.4	256.45	57849.0
2017-11-15 06:30:00	SPY	ETF	256.44	256.62	256.44	256.52	45264.0
2017-11-15 07:00:00	SPY	ETF	256.55	256.84	256.55	256.84	139636.0
2017-11-15 07:30:00	SPY	ETF	256.82	256.84	256.72	256.78	83011.0
2017-11-15 08:00:00	SPY	ETF	256.81	257.171	256.75	256.99	216490.0
2017-11-15 08:30:00	SPY	ETF	256.94	256.96	256.58	256.76	461415.0
2017-11-15 09:00:00	SPY	ETF	256.76	256.76	256.55	256.66	411301.0
2017-11-15 09:30:00	SPY	ETF	256.62	256.7	255.63	255.9163	11701070.0
2017-11-15 10:00:00	SPY	ETF	255.91	256.5	255.84	256.33	5908539.0
2017-11-15 10:30:00	SPY	ETF	256.32	256.92	256.255	256.91	5463550.0
2017-11-15 11:00:00	SPY	ETF	256.92	257.22	256.81	257.04	4939725.0
2017-11-15 11:30:00	SPY	ETF	257.04	257.11	256.93	257.02	2665534.0
2017-11-15 12:00:00	SPY	ETF	257.015	257.05	256.67	256.89	3245334.0
2017-11-15 12:30:00	SPY	ETF	256.895	256.98	256.8	256.94	1815979.0
2017-11-15 13:00:00	SPY	ETF	256.95	256.95	256.65	256.665	2741423.0
2017-11-15 13:30:00	SPY	ETF	256.66	256.88	256.6	256.63	4558564.0
2017-11-15 14:00:00	SPY	ETF	256.63	256.73	256.51	256.7	2164197.0
2017-11-15 14:30:00	SPY	ETF	256.7	256.865	256.65	256.79	2161899.0
2017-11-15 15:00:00	SPY	ETF	256.79	257.02	256.51	256.58	5361071.0
2017-11-15 15:30:00	SPY	ETF	256.57	256.79	256.26	256.43	12952257.0
2017-11-15 16:00:00	SPY	ETF	256.44	256.62	256.39	256.52	9879730.0
2017-11-15 16:30:00	SPY	ETF	256.52	256.57	256.45	256.47	632062.0
2017-11-15 17:00:00	SPY	ETF	256.47	256.5	256.4	256.43	419051.0
2017-11-15 17:30:00	SPY	ETF	256.43	256.48	256.41	256.48	79490.0
2017-11-15 18:00:00	SPY	ETF	256.47	256.51	256.4	256.45	184457.0
2017-11-15 18:30:00	SPY	ETF	256.43	256.55	256.3	256.45	153344.0
2017-11-15 19:00:00	SPY	ETF	256.4	256.71	256.38	256.65	75522.0
2017-11-15 19:30:00	SPY	ETF	256.65	256.87	256.65	256.78	73702.0
2017-11-15 20:00:00	SPY	ETF	256.44	256.44	256.4038	256.4038	500000.0
2017-11-15 04:00:00	QQQ	ETF	152.64	152.69	152.55	152.67	17641.0
2017-11-15 04:30:00	QQQ	ETF	152.55	152.58	152.46	152.58	22995.0
2017-11-15 05:00:00	QQQ	ETF	152.61	152.63	152.46	152.5	19398.0
2017-11-15 05:30:00	QQQ	ETF	152.49	152.49	152.46	152.48	5900.0
2017-11-15 06:00:00	QQQ	ETF	152.47	152.51	152.46	152.46	7088.0
2017-11-15 06:30:00	QQQ	ETF	152.54	152.59	152.54	152.54	1598.0
2017-11-15 07:00:00	QQQ	ETF	152.55	152.82	152.55	152.79	58609.0
2017-11-15 07:30:00	QQQ	ETF	152.86	152.86	152.76	152.8	36113.0
2017-11-15 08:00:00	QQQ	ETF	152.82	152.94	152.61	152.92	75869.0
2017-11-15 08:30:00	QQQ	ETF	152.86	152.88	152.61	152.78	132341.0
2017-11-15 09:00:00	QQQ	ETF	152.75	152.75	152.6	152.64	131098.0
2017-11-15 09:30:00	QQQ	ETF	152.65	152.68	151.78	152.0082	4870962.0
2017-11-15 10:00:00	QQQ	ETF	151.97	152.56	151.95	152.45	1810025.0
2017-11-15 10:30:00	QQQ	ETF	152.43	152.81	152.405	152.81	1691661.0
2017-11-15 11:00:00	QQQ	ETF	152.81	153.0	152.69	152.9	1368157.0
2017-11-15 11:30:00	QQQ	ETF	152.9	152.97	152.83	152.86	784399.0
2017-11-15 12:00:00	QQQ	ETF	152.87	152.88	152.62	152.73	643736.0

> showing 50 of 15,663 rows — these rows as CSV

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