PREVIEW / etf_30min / 2019-07-22

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-22.parquet
  size:    489 KB
  rows:    17,264

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-22 04:00:00	SPY	ETF	297.12	297.69	297.06	297.59	18915.0
2019-07-22 04:30:00	SPY	ETF	297.64	297.78	297.58	297.71	19220.0
2019-07-22 05:00:00	SPY	ETF	297.69	297.73	297.51	297.63	7415.0
2019-07-22 05:30:00	SPY	ETF	297.54	297.68	297.49	297.56	14612.0
2019-07-22 06:00:00	SPY	ETF	297.54	297.58	297.48	297.58	3937.0
2019-07-22 06:30:00	SPY	ETF	297.62	297.83	297.62	297.76	21012.0
2019-07-22 07:00:00	SPY	ETF	297.74	297.81	297.64	297.66	50630.0
2019-07-22 07:30:00	SPY	ETF	297.67	297.71	297.6	297.67	147692.0
2019-07-22 08:00:00	SPY	ETF	297.7601	298.0	297.25	297.69	434571.0
2019-07-22 08:30:00	SPY	ETF	297.77	297.88	297.69	297.69	101953.0
2019-07-22 09:00:00	SPY	ETF	297.7	297.78	297.46	297.62	157342.0
2019-07-22 09:30:00	SPY	ETF	297.61	298.11	297.33	298.08	4060629.0
2019-07-22 10:00:00	SPY	ETF	298.08	298.12	297.38	297.64	2494836.0
2019-07-22 10:30:00	SPY	ETF	297.65	297.95	297.04	297.295	3139295.0
2019-07-22 11:00:00	SPY	ETF	297.29	297.47	297.0415	297.255	2163116.0
2019-07-22 11:30:00	SPY	ETF	297.265	297.74	297.13	297.64	1745826.0
2019-07-22 12:00:00	SPY	ETF	297.64	297.85	297.31	297.77	1107501.0
2019-07-22 12:30:00	SPY	ETF	297.78	298.09	297.655	298.0	2284045.0
2019-07-22 13:00:00	SPY	ETF	298.0	298.058	297.77	297.84	2351287.0
2019-07-22 13:30:00	SPY	ETF	297.84	298.105	297.82	298.05	879443.0
2019-07-22 14:00:00	SPY	ETF	298.05	298.12	297.89	297.9	1290809.0
2019-07-22 14:30:00	SPY	ETF	297.895	298.01	297.75	297.99	1854423.0
2019-07-22 15:00:00	SPY	ETF	298.0	298.5	297.82	297.995	3842827.0
2019-07-22 15:30:00	SPY	ETF	298.0	298.015	297.65	297.92	6437996.0
2019-07-22 16:00:00	SPY	ETF	297.9	298.16	297.72	298.12	6715493.0
2019-07-22 16:30:00	SPY	ETF	298.15	298.2	297.9	298.09	259351.0
2019-07-22 17:00:00	SPY	ETF	298.08	298.11	298.01	298.03	40852.0
2019-07-22 17:30:00	SPY	ETF	298.03	298.08	297.9	298.03	91086.0
2019-07-22 18:00:00	SPY	ETF	298.1	298.22	298.08	298.16	36720.0
2019-07-22 18:30:00	SPY	ETF	298.13	298.13	297.97	297.97	15080.0
2019-07-22 19:00:00	SPY	ETF	298.0	298.08	297.96	298.07	3301.0
2019-07-22 19:30:00	SPY	ETF	298.09	298.18	298.08	298.08	18707.0
2019-07-22 04:00:00	QQQ	ETF	190.94	191.36	190.94	191.32	43502.0
2019-07-22 04:30:00	QQQ	ETF	191.32	191.4	191.29	191.4	21183.0
2019-07-22 05:00:00	QQQ	ETF	191.38	191.43	191.31	191.34	15974.0
2019-07-22 05:30:00	QQQ	ETF	191.33	191.45	191.29	191.36	6700.0
2019-07-22 06:00:00	QQQ	ETF	191.28	191.43	191.25	191.35	6182.0
2019-07-22 06:30:00	QQQ	ETF	191.43	191.65	191.43	191.58	21974.0
2019-07-22 07:00:00	QQQ	ETF	191.58	191.62	191.45	191.47	56838.0
2019-07-22 07:30:00	QQQ	ETF	191.48	191.54	191.4	191.42	77553.0
2019-07-22 08:00:00	QQQ	ETF	191.58	191.75	190.69	191.55	227434.0
2019-07-22 08:30:00	QQQ	ETF	191.58	191.68	191.49	191.5	57174.0
2019-07-22 09:00:00	QQQ	ETF	191.48	191.57	191.31	191.53	78239.0
2019-07-22 09:30:00	QQQ	ETF	191.52	192.46	191.44	192.42	2968498.0
2019-07-22 10:00:00	QQQ	ETF	192.42	192.5399	191.89	192.12	1562256.0
2019-07-22 10:30:00	QQQ	ETF	192.12	192.345	191.791	191.97	1333714.0
2019-07-22 11:00:00	QQQ	ETF	191.97	192.14	191.77	192.0	1261393.0
2019-07-22 11:30:00	QQQ	ETF	191.99	192.31	191.93	192.21	777036.0
2019-07-22 12:00:00	QQQ	ETF	192.21	192.31	191.92	192.2101	519619.0
2019-07-22 12:30:00	QQQ	ETF	192.23	192.4499	192.13	192.42	583714.0

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

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