PREVIEW / etf_30min / 2018-06-11

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-11.parquet
  size:    457 KB
  rows:    15,860

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-06-11 04:00:00	SPY	ETF	278.45	278.54	278.44	278.44	5409.0
2018-06-11 04:30:00	SPY	ETF	278.44	278.44	278.34	278.34	12996.0
2018-06-11 05:00:00	SPY	ETF	278.44	278.44	278.35	278.35	1200.0
2018-06-11 05:30:00	SPY	ETF	278.51	278.51	278.38	278.42	5333.0
2018-06-11 06:00:00	SPY	ETF	278.32	278.39	278.29	278.32	2358.0
2018-06-11 06:30:00	SPY	ETF	278.27	278.35	278.11	278.19	42802.0
2018-06-11 07:00:00	SPY	ETF	278.2	278.25	278.11	278.16	42221.0
2018-06-11 07:30:00	SPY	ETF	278.12	278.16	278.02	278.08	76523.0
2018-06-11 08:00:00	SPY	ETF	278.05	278.19	277.93	278.16	133313.0
2018-06-11 08:30:00	SPY	ETF	278.14	278.24	278.1	278.22	121897.0
2018-06-11 09:00:00	SPY	ETF	278.23	278.44	278.15	278.43	216628.0
2018-06-11 09:30:00	SPY	ETF	278.44	278.8	278.31	278.475	4315078.0
2018-06-11 10:00:00	SPY	ETF	278.475	278.86	278.39	278.64	4962548.0
2018-06-11 10:30:00	SPY	ETF	278.64	278.81	278.44	278.55	2753732.0
2018-06-11 11:00:00	SPY	ETF	278.56	278.75	278.37	278.65	3393599.0
2018-06-11 11:30:00	SPY	ETF	278.66	279.13	278.6	279.08	3089209.0
2018-06-11 12:00:00	SPY	ETF	279.09	279.27	279.01	279.26	2715323.0
2018-06-11 12:30:00	SPY	ETF	279.27	279.34	279.13	279.25	2070154.0
2018-06-11 13:00:00	SPY	ETF	279.25	279.37	279.1	279.24	1782299.0
2018-06-11 13:30:00	SPY	ETF	279.25	279.31	279.03	279.16	1600642.0
2018-06-11 14:00:00	SPY	ETF	279.15	279.17	278.92	279.02	2007045.0
2018-06-11 14:30:00	SPY	ETF	279.02	279.1	278.9	279.06	2923257.0
2018-06-11 15:00:00	SPY	ETF	279.06	279.23	279.055	279.2	2759000.0
2018-06-11 15:30:00	SPY	ETF	279.2	279.22	278.44	278.565	9586371.0
2018-06-11 16:00:00	SPY	ETF	278.58	278.67	278.36	278.56	6534442.0
2018-06-11 16:30:00	SPY	ETF	278.56	279.0	278.48	278.58	6322215.0
2018-06-11 17:00:00	SPY	ETF	278.59	278.65	278.56	278.57	604607.0
2018-06-11 17:30:00	SPY	ETF	278.57	278.6	278.52	278.52	65974.0
2018-06-11 18:00:00	SPY	ETF	278.5	278.84	278.48	278.84	35182.0
2018-06-11 18:30:00	SPY	ETF	278.82	278.88	278.8	278.87	17878.0
2018-06-11 19:00:00	SPY	ETF	278.82	278.99	278.82	278.95	23614.0
2018-06-11 19:30:00	SPY	ETF	278.93	278.96	278.87	278.87	8985.0
2018-06-11 04:00:00	QQQ	ETF	174.58	174.58	174.55	174.55	500.0
2018-06-11 04:30:00	QQQ	ETF	174.49	174.51	174.49	174.5	20200.0
2018-06-11 05:00:00	QQQ	ETF	174.49	174.5	174.38	174.38	3400.0
2018-06-11 05:30:00	QQQ	ETF	174.55	174.55	174.45	174.47	3300.0
2018-06-11 06:00:00	QQQ	ETF	174.41	174.5	174.37	174.37	14765.0
2018-06-11 06:30:00	QQQ	ETF	174.48	174.48	174.35	174.35	4000.0
2018-06-11 07:00:00	QQQ	ETF	174.41	174.44	174.36	174.41	79567.0
2018-06-11 07:30:00	QQQ	ETF	174.43	174.45	174.34	174.36	10700.0
2018-06-11 08:00:00	QQQ	ETF	174.37	174.39	174.07	174.15	125064.0
2018-06-11 08:30:00	QQQ	ETF	174.16	174.23	174.09	174.22	37037.0
2018-06-11 09:00:00	QQQ	ETF	174.2	174.32	174.17	174.32	109013.0
2018-06-11 09:30:00	QQQ	ETF	174.3	174.89	174.28	174.74	1893250.0
2018-06-11 10:00:00	QQQ	ETF	174.75	174.79	174.41	174.42	1771597.0
2018-06-11 10:30:00	QQQ	ETF	174.41	174.66	174.28	174.6552	1216349.0
2018-06-11 11:00:00	QQQ	ETF	174.66	174.82	174.51	174.7801	886604.0
2018-06-11 11:30:00	QQQ	ETF	174.78	175.08	174.68	175.005	1104339.0
2018-06-11 12:00:00	QQQ	ETF	175.02	175.34	174.98	175.29	919767.0
2018-06-11 12:30:00	QQQ	ETF	175.29	175.34	175.131	175.18	685044.0

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

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