PREVIEW / etf_30min / 2018-11-01

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-01.parquet
  size:    504 KB
  rows:    17,387

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-11-01 04:00:00	SPY	ETF	270.6	271.32	270.6	271.32	19517.0
2018-11-01 04:30:00	SPY	ETF	271.32	271.56	271.11	271.46	19123.0
2018-11-01 05:00:00	SPY	ETF	271.5	271.67	271.33	271.5	31725.0
2018-11-01 05:30:00	SPY	ETF	271.5	271.8	271.3	271.8	13451.0
2018-11-01 06:00:00	SPY	ETF	271.87	271.9	271.68	271.78	6083.0
2018-11-01 06:30:00	SPY	ETF	271.78	272.26	271.78	272.0	116523.0
2018-11-01 07:00:00	SPY	ETF	272.0	272.12	271.85	272.05	99621.0
2018-11-01 07:30:00	SPY	ETF	272.1	272.2	271.78	271.82	125466.0
2018-11-01 08:00:00	SPY	ETF	270.63	272.1	270.4	271.69	301642.0
2018-11-01 08:30:00	SPY	ETF	271.67	271.67	271.11	271.24	287423.0
2018-11-01 09:00:00	SPY	ETF	271.24	271.65	271.06	271.65	407604.0
2018-11-01 09:30:00	SPY	ETF	271.6	272.18	270.78	271.29	12567217.0
2018-11-01 10:00:00	SPY	ETF	271.27	272.13	270.38	271.83	11424490.0
2018-11-01 10:30:00	SPY	ETF	271.845	272.81	271.73	272.62	7906874.0
2018-11-01 11:00:00	SPY	ETF	272.62	273.04	272.04	272.89	6690004.0
2018-11-01 11:30:00	SPY	ETF	272.89	273.07	272.41	272.52	4338605.0
2018-11-01 12:00:00	SPY	ETF	272.525	272.9057	272.15	272.45	4796616.0
2018-11-01 12:30:00	SPY	ETF	272.44	273.09	272.32	273.04	3870431.0
2018-11-01 13:00:00	SPY	ETF	273.03	273.2	272.5001	273.16	4137423.0
2018-11-01 13:30:00	SPY	ETF	273.18	273.26	272.64	272.82	4244282.0
2018-11-01 14:00:00	SPY	ETF	272.82	273.16	272.43	272.97	5042379.0
2018-11-01 14:30:00	SPY	ETF	272.97	273.21	272.58	273.13	4986255.0
2018-11-01 15:00:00	SPY	ETF	273.13	273.32	272.7675	273.25	4986331.0
2018-11-01 15:30:00	SPY	ETF	273.25	273.73	272.94	273.51	13680900.0
2018-11-01 16:00:00	SPY	ETF	273.45	273.5845	273.16	273.3	5203851.0
2018-11-01 16:30:00	SPY	ETF	273.3	273.4	272.18	272.9	1629074.0
2018-11-01 17:00:00	SPY	ETF	272.9	273.51	272.35	272.4	661015.0
2018-11-01 17:30:00	SPY	ETF	272.43	273.51	271.6899	272.01	328159.0
2018-11-01 18:00:00	SPY	ETF	272.05	272.48	271.94	272.33	329021.0
2018-11-01 18:30:00	SPY	ETF	272.32	272.53	272.32	272.53	107865.0
2018-11-01 19:00:00	SPY	ETF	272.5	272.72	272.45	272.63	46992.0
2018-11-01 19:30:00	SPY	ETF	272.62	272.9	272.61	272.9	38720.0
2018-11-01 04:00:00	QQQ	ETF	169.42	170.01	169.4	170.01	4123.0
2018-11-01 04:30:00	QQQ	ETF	169.92	170.16	169.84	170.05	3588.0
2018-11-01 05:00:00	QQQ	ETF	170.07	170.21	169.99	170.03	16224.0
2018-11-01 05:30:00	QQQ	ETF	170.12	170.33	170.12	170.33	10765.0
2018-11-01 06:00:00	QQQ	ETF	170.37	170.4	170.25	170.31	9921.0
2018-11-01 06:30:00	QQQ	ETF	170.31	170.7	170.31	170.55	26935.0
2018-11-01 07:00:00	QQQ	ETF	170.47	170.66	170.43	170.56	83775.0
2018-11-01 07:30:00	QQQ	ETF	170.6	170.6	170.27	170.31	94527.0
2018-11-01 08:00:00	QQQ	ETF	170.46	170.64	169.52	170.27	172669.0
2018-11-01 08:30:00	QQQ	ETF	170.28	170.28	169.68	169.79	230505.0
2018-11-01 09:00:00	QQQ	ETF	169.79	170.16	169.67	170.11	351669.0
2018-11-01 09:30:00	QQQ	ETF	170.11	170.655	168.98	169.56	7689183.0
2018-11-01 10:00:00	QQQ	ETF	169.53	170.23	168.78	169.96	5692435.0
2018-11-01 10:30:00	QQQ	ETF	169.96	170.87	169.84	170.63	3871953.0
2018-11-01 11:00:00	QQQ	ETF	170.64	171.25	170.2494	171.18	3003319.0
2018-11-01 11:30:00	QQQ	ETF	171.18	171.43	170.94	171.01	2374668.0
2018-11-01 12:00:00	QQQ	ETF	171.01	171.41	170.7	170.99	1779888.0
2018-11-01 12:30:00	QQQ	ETF	170.99	171.6	170.86	171.57	1489043.0

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

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