PREVIEW / etf_30min / 2019-07-05

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-05.parquet
  size:    481 KB
  rows:    16,970

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-05 04:00:00	SPY	ETF	298.74	298.74	298.53	298.57	11530.0
2019-07-05 04:30:00	SPY	ETF	298.57	298.65	298.21	298.21	7657.0
2019-07-05 05:00:00	SPY	ETF	298.33	298.43	298.33	298.37	5894.0
2019-07-05 05:30:00	SPY	ETF	298.4	298.4	298.23	298.28	4457.0
2019-07-05 06:00:00	SPY	ETF	298.23	298.46	298.23	298.46	15170.0
2019-07-05 06:30:00	SPY	ETF	298.46	298.46	298.37	298.44	22710.0
2019-07-05 07:00:00	SPY	ETF	298.44	298.57	298.35	298.35	68321.0
2019-07-05 07:30:00	SPY	ETF	298.35	298.39	298.3	298.33	63308.0
2019-07-05 08:00:00	SPY	ETF	298.44	299.19	298.05	298.05	367689.0
2019-07-05 08:30:00	SPY	ETF	298.07	298.59	297.25	297.65	1108974.0
2019-07-05 09:00:00	SPY	ETF	297.59	297.63	297.2	297.41	276895.0
2019-07-05 09:30:00	SPY	ETF	297.44	297.63	296.66	296.69	5890320.0
2019-07-05 10:00:00	SPY	ETF	296.7	297.09	296.465	296.48	4634225.0
2019-07-05 10:30:00	SPY	ETF	296.48	296.635	296.01	296.58	4208037.0
2019-07-05 11:00:00	SPY	ETF	296.6	297.0694	296.39	297.03	2747834.0
2019-07-05 11:30:00	SPY	ETF	297.01	297.16	296.625	297.16	1794262.0
2019-07-05 12:00:00	SPY	ETF	297.15	297.5799	296.89	297.48	2289140.0
2019-07-05 12:30:00	SPY	ETF	297.48	297.83	297.46	297.69	1944893.0
2019-07-05 13:00:00	SPY	ETF	297.69	297.965	297.49	297.965	1678398.0
2019-07-05 13:30:00	SPY	ETF	297.97	298.19	297.91	298.025	1804483.0
2019-07-05 14:00:00	SPY	ETF	298.0284	298.18	297.9	298.065	1107236.0
2019-07-05 14:30:00	SPY	ETF	298.06	298.6327	298.055	298.63	1521355.0
2019-07-05 15:00:00	SPY	ETF	298.62	298.64	298.06	298.35	3732305.0
2019-07-05 15:30:00	SPY	ETF	298.35	298.46	297.7	298.36	7315206.0
2019-07-05 16:00:00	SPY	ETF	298.38	298.46	297.87	297.99	6980652.0
2019-07-05 16:30:00	SPY	ETF	297.96	298.46	297.9	298.06	429195.0
2019-07-05 17:00:00	SPY	ETF	298.01	298.46	297.98	298.02	493707.0
2019-07-05 17:30:00	SPY	ETF	298.03	298.09	297.91	298.09	203924.0
2019-07-05 18:00:00	SPY	ETF	298.46	298.46	298.07	298.07	8609.0
2019-07-05 18:30:00	SPY	ETF	298.09	298.12	298.07	298.12	2327.0
2019-07-05 19:00:00	SPY	ETF	298.1	298.12	298.07	298.09	3980.0
2019-07-05 19:30:00	SPY	ETF	298.09	298.15	298.05	298.14	13990.0
2019-07-05 04:00:00	QQQ	ETF	191.59	191.6	191.36	191.36	3900.0
2019-07-05 04:30:00	QQQ	ETF	191.46	191.46	191.25	191.27	4800.0
2019-07-05 05:00:00	QQQ	ETF	191.21	191.33	191.21	191.33	4900.0
2019-07-05 05:30:00	QQQ	ETF	191.32	191.32	191.09	191.09	5212.0
2019-07-05 06:00:00	QQQ	ETF	191.13	191.29	191.13	191.26	2997.0
2019-07-05 06:30:00	QQQ	ETF	191.23	191.26	191.16	191.26	9190.0
2019-07-05 07:00:00	QQQ	ETF	191.26	191.33	191.18	191.18	27683.0
2019-07-05 07:30:00	QQQ	ETF	191.19	191.2	191.15	191.17	50300.0
2019-07-05 08:00:00	QQQ	ETF	191.17	191.34	190.99	191.3	149773.0
2019-07-05 08:30:00	QQQ	ETF	190.97	191.3	190.13	190.45	567834.0
2019-07-05 09:00:00	QQQ	ETF	190.42	190.42	189.98	190.15	232020.0
2019-07-05 09:30:00	QQQ	ETF	190.15	190.45	189.6299	189.65	2233463.0
2019-07-05 10:00:00	QQQ	ETF	189.66	190.08	189.5599	189.64	1912573.0
2019-07-05 10:30:00	QQQ	ETF	189.62	189.7785	189.39	189.7	1861672.0
2019-07-05 11:00:00	QQQ	ETF	189.7	190.16	189.54	190.08	1005245.0
2019-07-05 11:30:00	QQQ	ETF	190.09	190.21	189.8201	190.13	708036.0
2019-07-05 12:00:00	QQQ	ETF	190.15	190.48	189.93	190.3808	709936.0
2019-07-05 12:30:00	QQQ	ETF	190.3992	190.665	190.375	190.545	561321.0

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

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