PREVIEW / etf_30min / 2018-05-18

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-18.parquet
  size:    441 KB
  rows:    15,421

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-05-18 04:00:00	SPY	ETF	272.31	272.31	272.08	272.08	3586.0
2018-05-18 04:30:00	SPY	ETF	272.15	272.35	272.15	272.29	7059.0
2018-05-18 05:00:00	SPY	ETF	272.2	272.48	272.2	272.48	1072.0
2018-05-18 05:30:00	SPY	ETF	272.41	272.55	272.41	272.55	4200.0
2018-05-18 06:00:00	SPY	ETF	272.54	272.61	272.54	272.58	12376.0
2018-05-18 06:30:00	SPY	ETF	272.54	272.56	272.39	272.39	3972.0
2018-05-18 07:00:00	SPY	ETF	272.39	272.45	272.16	272.3	65525.0
2018-05-18 07:30:00	SPY	ETF	272.3	272.35	272.25	272.25	44026.0
2018-05-18 08:00:00	SPY	ETF	272.45	272.64	271.84	271.89	110613.0
2018-05-18 08:30:00	SPY	ETF	271.9	271.92	271.3	271.36	375606.0
2018-05-18 09:00:00	SPY	ETF	271.33	271.82	271.26	271.66	414949.0
2018-05-18 09:30:00	SPY	ETF	271.62	271.98	271.42	271.59	5623901.0
2018-05-18 10:00:00	SPY	ETF	271.59	272.01	271.26	271.737	8591852.0
2018-05-18 10:30:00	SPY	ETF	271.74	271.94	270.93	271.48	5327527.0
2018-05-18 11:00:00	SPY	ETF	271.49	271.9	271.42	271.56	3280031.0
2018-05-18 11:30:00	SPY	ETF	271.57	272.03	271.49	271.89	3686208.0
2018-05-18 12:00:00	SPY	ETF	271.9	271.9	271.46	271.53	3425265.0
2018-05-18 12:30:00	SPY	ETF	271.535	271.6593	271.32	271.6	1936798.0
2018-05-18 13:00:00	SPY	ETF	271.595	271.79	271.38	271.6308	2105267.0
2018-05-18 13:30:00	SPY	ETF	271.64	271.65	271.31	271.43	1705299.0
2018-05-18 14:00:00	SPY	ETF	271.44	271.59	271.2952	271.56	3283240.0
2018-05-18 14:30:00	SPY	ETF	271.565	271.71	271.52	271.6399	2916512.0
2018-05-18 15:00:00	SPY	ETF	271.63	271.66	271.35	271.46	4434317.0
2018-05-18 15:30:00	SPY	ETF	271.47	271.565	271.31	271.34	9164163.0
2018-05-18 16:00:00	SPY	ETF	271.35	271.43	271.3	271.35	4851357.0
2018-05-18 16:30:00	SPY	ETF	271.37	271.46	271.3	271.32	487977.0
2018-05-18 17:00:00	SPY	ETF	271.33	271.44	271.31	271.31	660142.0
2018-05-18 17:30:00	SPY	ETF	271.31	271.44	271.15	271.15	79000.0
2018-05-18 18:00:00	SPY	ETF	271.15	271.19	270.95	271.1	51364.0
2018-05-18 18:30:00	SPY	ETF	271.11	271.15	271.03	271.06	51185.0
2018-05-18 19:00:00	SPY	ETF	271.09	271.2	271.06	271.2	6752.0
2018-05-18 19:30:00	SPY	ETF	271.2	271.25	271.15	271.25	6512.0
2018-05-18 04:00:00	QQQ	ETF	168.5	168.5	168.5	168.5	100.0
2018-05-18 04:30:00	QQQ	ETF	168.59	168.66	168.59	168.66	300.0
2018-05-18 05:00:00	QQQ	ETF	168.67	168.77	168.62	168.77	6155.0
2018-05-18 05:30:00	QQQ	ETF	168.76	168.77	168.7	168.72	10497.0
2018-05-18 06:00:00	QQQ	ETF	168.75	168.75	168.73	168.75	1200.0
2018-05-18 06:30:00	QQQ	ETF	168.67	168.71	168.62	168.66	20816.0
2018-05-18 07:00:00	QQQ	ETF	168.65	168.66	168.45	168.48	41448.0
2018-05-18 07:30:00	QQQ	ETF	168.48	168.55	168.48	168.5	30204.0
2018-05-18 08:00:00	QQQ	ETF	168.5899	168.62	167.87	167.94	111902.0
2018-05-18 08:30:00	QQQ	ETF	167.92	167.92	167.38	167.4	486612.0
2018-05-18 09:00:00	QQQ	ETF	167.39	167.78	167.36	167.72	389958.0
2018-05-18 09:30:00	QQQ	ETF	167.72	168.01	167.47	167.65	2698165.0
2018-05-18 10:00:00	QQQ	ETF	167.65	168.01	167.31	167.8037	1809774.0
2018-05-18 10:30:00	QQQ	ETF	167.8	167.815	167.21	167.61	1916996.0
2018-05-18 11:00:00	QQQ	ETF	167.62	168.14	167.59	167.94	1503008.0
2018-05-18 11:30:00	QQQ	ETF	167.95	168.26	167.92	168.0942	1037545.0
2018-05-18 12:00:00	QQQ	ETF	168.1	168.1	167.76	167.805	970036.0
2018-05-18 12:30:00	QQQ	ETF	167.81	167.95	167.7	167.89	730619.0

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

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