PREVIEW / etf_30min / 2019-07-26

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-26.parquet
  size:    486 KB
  rows:    16,971

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-07-26 04:00:00	SPY	ETF	300.33	300.63	300.33	300.55	3610.0
2019-07-26 04:30:00	SPY	ETF	300.55	300.57	300.53	300.57	5728.0
2019-07-26 05:00:00	SPY	ETF	300.52	300.75	300.52	300.75	3539.0
2019-07-26 05:30:00	SPY	ETF	300.78	300.92	300.78	300.85	1526.0
2019-07-26 06:00:00	SPY	ETF	300.95	301.0	300.92	301.0	3826.0
2019-07-26 06:30:00	SPY	ETF	300.92	300.99	300.83	300.83	27611.0
2019-07-26 07:00:00	SPY	ETF	300.82	300.88	300.74	300.79	34020.0
2019-07-26 07:30:00	SPY	ETF	300.83	300.87	300.76	300.8	108199.0
2019-07-26 08:00:00	SPY	ETF	300.82	300.86	300.0	300.54	182167.0
2019-07-26 08:30:00	SPY	ETF	300.5	300.77	300.29	300.73	266249.0
2019-07-26 09:00:00	SPY	ETF	300.74	300.84	300.56	300.77	120844.0
2019-07-26 09:30:00	SPY	ETF	300.76	301.37	300.62	301.23	5090225.0
2019-07-26 10:00:00	SPY	ETF	301.23	301.33	301.04	301.09	2992191.0
2019-07-26 10:30:00	SPY	ETF	301.09	301.27	300.9023	301.1699	2537233.0
2019-07-26 11:00:00	SPY	ETF	301.16	301.51	301.0915	301.46	1850719.0
2019-07-26 11:30:00	SPY	ETF	301.45	301.75	301.435	301.73	1880104.0
2019-07-26 12:00:00	SPY	ETF	301.735	301.8	301.59	301.71	2023461.0
2019-07-26 12:30:00	SPY	ETF	301.705	301.74	301.59	301.705	1113744.0
2019-07-26 13:00:00	SPY	ETF	301.705	301.86	301.66	301.73	791288.0
2019-07-26 13:30:00	SPY	ETF	301.73	301.82	301.62	301.775	1019567.0
2019-07-26 14:00:00	SPY	ETF	301.77	301.815	301.66	301.7699	926534.0
2019-07-26 14:30:00	SPY	ETF	301.76	302.09	301.76	302.08	1695514.0
2019-07-26 15:00:00	SPY	ETF	302.0801	302.17	301.97	302.07	3012646.0
2019-07-26 15:30:00	SPY	ETF	302.065	302.23	301.97	301.99	8096620.0
2019-07-26 16:00:00	SPY	ETF	301.97	302.05	301.66	301.75	6656797.0
2019-07-26 16:30:00	SPY	ETF	301.74	302.01	301.6	301.6	556461.0
2019-07-26 17:00:00	SPY	ETF	301.6	301.74	301.53	301.57	235524.0
2019-07-26 17:30:00	SPY	ETF	301.57	302.01	301.4	301.41	65403.0
2019-07-26 18:00:00	SPY	ETF	301.41	301.45	301.24	301.32	83607.0
2019-07-26 18:30:00	SPY	ETF	301.36	301.39	301.21	301.3	39016.0
2019-07-26 19:00:00	SPY	ETF	301.33	301.4	301.2	301.4	10935.0
2019-07-26 19:30:00	SPY	ETF	301.37	301.39	301.3	301.35	22749.0
2019-07-26 04:00:00	QQQ	ETF	194.71	194.81	194.69	194.71	6150.0
2019-07-26 04:30:00	QQQ	ETF	194.7	194.75	194.63	194.75	6355.0
2019-07-26 05:00:00	QQQ	ETF	194.76	194.87	194.73	194.86	5400.0
2019-07-26 05:30:00	QQQ	ETF	194.86	195.01	194.86	194.96	7100.0
2019-07-26 06:00:00	QQQ	ETF	194.98	195.05	194.98	195.05	3450.0
2019-07-26 06:30:00	QQQ	ETF	195.04	195.08	194.95	194.95	4301.0
2019-07-26 07:00:00	QQQ	ETF	194.92	194.95	194.86	194.94	16084.0
2019-07-26 07:30:00	QQQ	ETF	194.9	194.94	194.83	194.9	42826.0
2019-07-26 08:00:00	QQQ	ETF	194.86	195.04	194.5	194.6	190273.0
2019-07-26 08:30:00	QQQ	ETF	194.53	194.74	194.33	194.64	218318.0
2019-07-26 09:00:00	QQQ	ETF	194.68	194.78	194.51	194.51	56133.0
2019-07-26 09:30:00	QQQ	ETF	194.52	195.39	194.43	195.2	2796421.0
2019-07-26 10:00:00	QQQ	ETF	195.19	195.3	194.8	194.86	1694911.0
2019-07-26 10:30:00	QQQ	ETF	194.86	194.87	194.552	194.775	1238328.0
2019-07-26 11:00:00	QQQ	ETF	194.77	195.08	194.65	195.06	1266077.0
2019-07-26 11:30:00	QQQ	ETF	195.05	195.355	195.04	195.33	1014873.0
2019-07-26 12:00:00	QQQ	ETF	195.34	195.37	195.17	195.265	770307.0
2019-07-26 12:30:00	QQQ	ETF	195.26	195.29	195.08	195.2285	707503.0

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

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