PREVIEW / etf_30min / 2019-05-17

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-17.parquet
  size:    485 KB
  rows:    16,905

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
2019-05-17 04:00:00	SPY	ETF	287.01	287.01	286.35	286.35	14750.0
2019-05-17 04:30:00	SPY	ETF	286.32	286.32	285.99	286.05	10414.0
2019-05-17 05:00:00	SPY	ETF	286.25	286.44	286.0	286.44	15084.0
2019-05-17 05:30:00	SPY	ETF	286.41	286.88	286.36	286.61	24834.0
2019-05-17 06:00:00	SPY	ETF	286.61	286.61	286.35	286.44	27452.0
2019-05-17 06:30:00	SPY	ETF	286.52	286.52	286.24	286.44	61951.0
2019-05-17 07:00:00	SPY	ETF	286.47	286.53	285.99	286.0	262818.0
2019-05-17 07:30:00	SPY	ETF	286.0	286.01	285.55	285.73	327971.0
2019-05-17 08:00:00	SPY	ETF	285.71	287.7	285.2	285.21	1765291.0
2019-05-17 08:30:00	SPY	ETF	285.21	286.0	285.19	285.61	851612.0
2019-05-17 09:00:00	SPY	ETF	285.66	285.91	285.12	285.15	668653.0
2019-05-17 09:30:00	SPY	ETF	285.14	286.59	285.13	285.93	8498684.0
2019-05-17 10:00:00	SPY	ETF	285.92	287.165	285.63	286.93	8820928.0
2019-05-17 10:30:00	SPY	ETF	286.92	288.39	286.57	288.0831	7165135.0
2019-05-17 11:00:00	SPY	ETF	288.08	288.6	288.05	288.095	7084668.0
2019-05-17 11:30:00	SPY	ETF	288.1	288.16	287.12	287.53	5161209.0
2019-05-17 12:00:00	SPY	ETF	287.53	287.6	286.75	287.03	3289456.0
2019-05-17 12:30:00	SPY	ETF	287.03	287.565	286.8	287.4	2946137.0
2019-05-17 13:00:00	SPY	ETF	287.39	287.885	287.32	287.43	2071166.0
2019-05-17 13:30:00	SPY	ETF	287.435	287.79	287.21	287.64	3398455.0
2019-05-17 14:00:00	SPY	ETF	287.64	287.81	287.23	287.35	1894550.0
2019-05-17 14:30:00	SPY	ETF	287.355	287.55	287.08	287.465	5303175.0
2019-05-17 15:00:00	SPY	ETF	287.465	287.525	285.83	286.48	10590537.0
2019-05-17 15:30:00	SPY	ETF	286.48	286.4801	285.5713	285.9	15126138.0
2019-05-17 16:00:00	SPY	ETF	285.89	286.2	285.76	286.0	8262378.0
2019-05-17 16:30:00	SPY	ETF	285.98	286.11	285.84	285.97	2348975.0
2019-05-17 17:00:00	SPY	ETF	285.98	286.16	285.94	285.95	573672.0
2019-05-17 17:30:00	SPY	ETF	285.96	286.18	285.84	286.03	114123.0
2019-05-17 18:00:00	SPY	ETF	286.05	286.13	286.0	286.13	9605.0
2019-05-17 18:30:00	SPY	ETF	286.12	286.12	286.07	286.09	21127.0
2019-05-17 19:00:00	SPY	ETF	286.11	286.29	286.07	286.25	48783.0
2019-05-17 19:30:00	SPY	ETF	286.22	286.4	286.17	286.32	70147.0
2019-05-17 04:00:00	QQQ	ETF	184.81	184.81	184.03	184.03	17650.0
2019-05-17 04:30:00	QQQ	ETF	184.0	184.0	183.65	183.75	55860.0
2019-05-17 05:00:00	QQQ	ETF	183.84	184.04	183.64	183.99	16001.0
2019-05-17 05:30:00	QQQ	ETF	184.02	184.39	184.0	184.24	24930.0
2019-05-17 06:00:00	QQQ	ETF	184.24	184.25	184.06	184.12	55860.0
2019-05-17 06:30:00	QQQ	ETF	184.17	184.19	183.91	183.94	20154.0
2019-05-17 07:00:00	QQQ	ETF	184.0	184.1	183.65	183.65	135658.0
2019-05-17 07:30:00	QQQ	ETF	183.63	183.71	183.43	183.54	92092.0
2019-05-17 08:00:00	QQQ	ETF	183.9	184.5	182.93	182.96	362516.0
2019-05-17 08:30:00	QQQ	ETF	182.95	183.58	182.89	183.23	420343.0
2019-05-17 09:00:00	QQQ	ETF	183.3101	183.47	182.96	183.08	388941.0
2019-05-17 09:30:00	QQQ	ETF	183.1	184.35	183.08	183.78	4916664.0
2019-05-17 10:00:00	QQQ	ETF	183.77	184.59	183.3	184.42	3265599.0
2019-05-17 10:30:00	QQQ	ETF	184.42	185.42	184.07	185.2301	2680616.0
2019-05-17 11:00:00	QQQ	ETF	185.23	185.5813	185.02	185.07	2096002.0
2019-05-17 11:30:00	QQQ	ETF	185.07	185.11	184.0723	184.44	1981338.0
2019-05-17 12:00:00	QQQ	ETF	184.43	184.5	183.83	184.1	1590173.0
2019-05-17 12:30:00	QQQ	ETF	184.13	184.52	183.92	184.41	1239064.0

> showing 50 of 16,905 rows — these rows as CSV

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