PREVIEW / etf_30min / 2019-05-28

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-28.parquet
  size:    491 KB
  rows:    17,321

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-28 04:00:00	SPY	ETF	282.99	283.12	282.46	282.65	27755.0
2019-05-28 04:30:00	SPY	ETF	282.46	282.52	282.43	282.47	2720.0
2019-05-28 05:00:00	SPY	ETF	282.49	283.07	282.49	283.07	13329.0
2019-05-28 05:30:00	SPY	ETF	283.01	283.01	282.8	282.91	2882.0
2019-05-28 06:00:00	SPY	ETF	282.97	282.97	282.28	282.43	10479.0
2019-05-28 06:30:00	SPY	ETF	282.52	282.77	282.52	282.76	32908.0
2019-05-28 07:00:00	SPY	ETF	282.74	282.84	282.5	282.61	105681.0
2019-05-28 07:30:00	SPY	ETF	282.7	283.32	282.69	283.18	175195.0
2019-05-28 08:00:00	SPY	ETF	283.18	283.83	282.5899	283.32	132525.0
2019-05-28 08:30:00	SPY	ETF	283.3	283.59	282.89	283.08	306518.0
2019-05-28 09:00:00	SPY	ETF	283.06	283.36	283.0	283.09	517399.0
2019-05-28 09:30:00	SPY	ETF	283.09	284.15	283.01	283.88	6144193.0
2019-05-28 10:00:00	SPY	ETF	283.88	284.03	283.195	283.31	3412006.0
2019-05-28 10:30:00	SPY	ETF	283.31	283.4	282.56	282.85	3640872.0
2019-05-28 11:00:00	SPY	ETF	282.84	283.3832	282.7	282.7	2744770.0
2019-05-28 11:30:00	SPY	ETF	282.71	283.1	282.48	283.01	4932903.0
2019-05-28 12:00:00	SPY	ETF	283.01	283.38	282.92	283.27	2031629.0
2019-05-28 12:30:00	SPY	ETF	283.265	283.38	282.86	282.91	1719328.0
2019-05-28 13:00:00	SPY	ETF	282.91	283.05	282.63	282.64	3236605.0
2019-05-28 13:30:00	SPY	ETF	282.63	282.88	282.59	282.6135	1882835.0
2019-05-28 14:00:00	SPY	ETF	282.61	282.615	282.03	282.03	3214975.0
2019-05-28 14:30:00	SPY	ETF	282.02	282.19	281.46	281.64	4727701.0
2019-05-28 15:00:00	SPY	ETF	281.64	281.66	281.15	281.21	4090624.0
2019-05-28 15:30:00	SPY	ETF	281.22	281.33	280.18	280.2	18255150.0
2019-05-28 16:00:00	SPY	ETF	280.2	280.74	280.13	280.5	7029730.0
2019-05-28 16:30:00	SPY	ETF	280.47	280.54	280.17	280.54	359930.0
2019-05-28 17:00:00	SPY	ETF	280.52	280.59	280.15	280.41	239102.0
2019-05-28 17:30:00	SPY	ETF	280.41	280.46	280.35	280.42	58478.0
2019-05-28 18:00:00	SPY	ETF	280.46	280.57	280.15	280.56	99357.0
2019-05-28 18:30:00	SPY	ETF	280.5	280.59	280.41	280.56	13395.0
2019-05-28 19:00:00	SPY	ETF	280.54	280.65	280.28	280.37	38884.0
2019-05-28 19:30:00	SPY	ETF	280.35	280.58	280.35	280.48	37283.0
2019-05-28 04:00:00	QQQ	ETF	178.33	178.53	177.96	178.11	36442.0
2019-05-28 04:30:00	QQQ	ETF	178.08	178.08	177.88	177.96	15312.0
2019-05-28 05:00:00	QQQ	ETF	178.02	178.35	178.02	178.35	16073.0
2019-05-28 05:30:00	QQQ	ETF	178.36	178.4	178.28	178.4	61769.0
2019-05-28 06:00:00	QQQ	ETF	178.39	178.39	177.72	177.95	40888.0
2019-05-28 06:30:00	QQQ	ETF	177.87	178.29	177.87	178.23	5342.0
2019-05-28 07:00:00	QQQ	ETF	178.28	178.28	177.99	177.99	54097.0
2019-05-28 07:30:00	QQQ	ETF	178.06	178.7	178.06	178.57	219636.0
2019-05-28 08:00:00	QQQ	ETF	178.2299	179.02	178.07	178.72	105397.0
2019-05-28 08:30:00	QQQ	ETF	178.73	178.92	178.38	178.5	122647.0
2019-05-28 09:00:00	QQQ	ETF	178.51	178.74	178.45	178.68	88796.0
2019-05-28 09:30:00	QQQ	ETF	178.67	179.66	178.545	179.325	2643599.0
2019-05-28 10:00:00	QQQ	ETF	179.35	179.44	178.56	178.8	2027969.0
2019-05-28 10:30:00	QQQ	ETF	178.79	178.84	178.44	178.7	1567607.0
2019-05-28 11:00:00	QQQ	ETF	178.68	179.15	178.58	178.58	1190007.0
2019-05-28 11:30:00	QQQ	ETF	178.58	179.11	178.46	179.04	1288205.0
2019-05-28 12:00:00	QQQ	ETF	179.0401	179.23	178.97	179.16	1043897.0
2019-05-28 12:30:00	QQQ	ETF	179.16	179.25	178.89	178.925	820976.0

> showing 50 of 17,321 rows — these rows as CSV

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