PREVIEW / etf_30min / 2018-10-16

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-16.parquet
  size:    502 KB
  rows:    17,116

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-10-16 04:00:00	SPY	ETF	275.01	275.45	274.95	275.45	27215.0
2018-10-16 04:30:00	SPY	ETF	275.26	275.26	275.0	275.02	14705.0
2018-10-16 05:00:00	SPY	ETF	274.98	275.01	274.84	274.84	10276.0
2018-10-16 05:30:00	SPY	ETF	274.78	275.13	274.78	275.13	6100.0
2018-10-16 06:00:00	SPY	ETF	275.17	275.42	274.99	275.4	14570.0
2018-10-16 06:30:00	SPY	ETF	275.38	275.5	275.26	275.26	39546.0
2018-10-16 07:00:00	SPY	ETF	275.28	275.58	275.18	275.48	193709.0
2018-10-16 07:30:00	SPY	ETF	275.48	275.67	275.43	275.64	144911.0
2018-10-16 08:00:00	SPY	ETF	275.6	276.04	274.71	275.95	303995.0
2018-10-16 08:30:00	SPY	ETF	275.88	276.34	275.84	276.2	214779.0
2018-10-16 09:00:00	SPY	ETF	276.2	276.64	276.13	276.57	523444.0
2018-10-16 09:30:00	SPY	ETF	276.6	277.0	276.07	277.0	10566643.0
2018-10-16 10:00:00	SPY	ETF	276.99	277.54	276.87	276.875	8334239.0
2018-10-16 10:30:00	SPY	ETF	276.88	278.1	276.67	278.08	7845293.0
2018-10-16 11:00:00	SPY	ETF	278.07	278.59	277.78	278.57	6980495.0
2018-10-16 11:30:00	SPY	ETF	278.58	278.69	278.23	278.66	5057475.0
2018-10-16 12:00:00	SPY	ETF	278.66	278.83	278.355	278.57	3593157.0
2018-10-16 12:30:00	SPY	ETF	278.58	279.02	278.45	278.9764	3735978.0
2018-10-16 13:00:00	SPY	ETF	278.97	279.14	278.78	279.13	3762655.0
2018-10-16 13:30:00	SPY	ETF	279.14	279.75	279.1	279.36	5030969.0
2018-10-16 14:00:00	SPY	ETF	279.36	279.9	279.36	279.85	5077643.0
2018-10-16 14:30:00	SPY	ETF	279.86	280.03	279.44	279.53	6536014.0
2018-10-16 15:00:00	SPY	ETF	279.53	279.95	279.26	279.5651	6208212.0
2018-10-16 15:30:00	SPY	ETF	279.56	280.82	279.44	280.3	22860788.0
2018-10-16 16:00:00	SPY	ETF	280.3	281.08	279.93	280.93	15884268.0
2018-10-16 16:30:00	SPY	ETF	280.93	280.93	280.4	280.79	1511402.0
2018-10-16 17:00:00	SPY	ETF	280.79	280.91	280.71	280.85	89525.0
2018-10-16 17:30:00	SPY	ETF	280.86	280.91	280.85	280.85	34823.0
2018-10-16 18:00:00	SPY	ETF	280.84	280.89	280.4	280.69	93915.0
2018-10-16 18:30:00	SPY	ETF	280.65	280.65	280.51	280.61	38513.0
2018-10-16 19:00:00	SPY	ETF	280.68	280.75	280.59	280.63	6655.0
2018-10-16 19:30:00	SPY	ETF	280.68	280.9	280.68	280.9	18302.0
2018-10-16 04:00:00	QQQ	ETF	172.74	173.15	172.74	173.14	36198.0
2018-10-16 04:30:00	QQQ	ETF	173.03	173.03	172.85	172.88	29097.0
2018-10-16 05:00:00	QQQ	ETF	172.94	172.94	172.74	172.74	6422.0
2018-10-16 05:30:00	QQQ	ETF	172.75	172.99	172.73	172.97	16008.0
2018-10-16 06:00:00	QQQ	ETF	173.02	173.12	172.83	173.12	10100.0
2018-10-16 06:30:00	QQQ	ETF	173.09	173.2	173.01	173.04	32750.0
2018-10-16 07:00:00	QQQ	ETF	173.07	173.35	173.01	173.25	70560.0
2018-10-16 07:30:00	QQQ	ETF	173.21	173.41	173.21	173.39	159434.0
2018-10-16 08:00:00	QQQ	ETF	173.05	173.75	172.74	173.59	396047.0
2018-10-16 08:30:00	QQQ	ETF	173.63	173.86	173.59	173.79	432886.0
2018-10-16 09:00:00	QQQ	ETF	173.79	174.02	173.7	174.0	553310.0
2018-10-16 09:30:00	QQQ	ETF	174.02	174.73	173.82	174.73	10453547.0
2018-10-16 10:00:00	QQQ	ETF	174.73	174.94	173.92	173.95	4150055.0
2018-10-16 10:30:00	QQQ	ETF	173.94	174.94	173.7	174.91	4394643.0
2018-10-16 11:00:00	QQQ	ETF	174.9	175.57	174.65	175.53	4954855.0
2018-10-16 11:30:00	QQQ	ETF	175.53	175.79	175.38	175.76	2376597.0
2018-10-16 12:00:00	QQQ	ETF	175.76	175.85	175.44	175.67	2126912.0
2018-10-16 12:30:00	QQQ	ETF	175.67	176.04	175.55	176.01	1587538.0

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

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