PREVIEW / etf_30min / 2018-07-06

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-07-06.parquet
  size:    462 KB
  rows:    16,053

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-07-06 04:00:00	SPY	ETF	272.8	273.14	272.74	273.11	10682.0
2018-07-06 04:30:00	SPY	ETF	273.2	273.28	273.12	273.25	13030.0
2018-07-06 05:00:00	SPY	ETF	273.25	273.35	272.87	272.96	10676.0
2018-07-06 05:30:00	SPY	ETF	273.04	273.04	272.74	272.85	8696.0
2018-07-06 06:00:00	SPY	ETF	272.84	272.85	272.75	272.75	13400.0
2018-07-06 06:30:00	SPY	ETF	272.72	272.74	272.62	272.65	11305.0
2018-07-06 07:00:00	SPY	ETF	272.66	272.69	272.53	272.59	67014.0
2018-07-06 07:30:00	SPY	ETF	272.54	272.56	272.36	272.41	42508.0
2018-07-06 08:00:00	SPY	ETF	272.6101	273.7	272.44	272.54	223188.0
2018-07-06 08:30:00	SPY	ETF	272.63	273.72	272.63	273.03	1139914.0
2018-07-06 09:00:00	SPY	ETF	273.03	273.45	272.89	273.15	254186.0
2018-07-06 09:30:00	SPY	ETF	273.14	273.74	272.715	273.71	4683949.0
2018-07-06 10:00:00	SPY	ETF	273.72	274.02	273.561	273.99	3354764.0
2018-07-06 10:30:00	SPY	ETF	273.99	274.49	273.74	274.365	3273056.0
2018-07-06 11:00:00	SPY	ETF	274.36	275.1	274.31	275.015	4093114.0
2018-07-06 11:30:00	SPY	ETF	275.015	275.6	275.0	275.33	5536555.0
2018-07-06 12:00:00	SPY	ETF	275.33	275.67	275.32	275.61	3885925.0
2018-07-06 12:30:00	SPY	ETF	275.6	275.6	275.2116	275.36	2609635.0
2018-07-06 13:00:00	SPY	ETF	275.36	275.64	275.35	275.56	2149935.0
2018-07-06 13:30:00	SPY	ETF	275.56	275.72	275.43	275.5	1307427.0
2018-07-06 14:00:00	SPY	ETF	275.5008	275.54	275.39	275.48	2929452.0
2018-07-06 14:30:00	SPY	ETF	275.47	275.62	275.21	275.53	2437396.0
2018-07-06 15:00:00	SPY	ETF	275.54	275.84	275.4701	275.755	2940796.0
2018-07-06 15:30:00	SPY	ETF	275.75	275.78	274.89	275.37	13531531.0
2018-07-06 16:00:00	SPY	ETF	275.36	275.57	275.25	275.43	8520329.0
2018-07-06 16:30:00	SPY	ETF	275.44	275.47	275.37	275.47	107340.0
2018-07-06 17:00:00	SPY	ETF	275.47	275.53	275.42	275.44	929384.0
2018-07-06 17:30:00	SPY	ETF	275.44	275.48	275.43	275.44	29468.0
2018-07-06 18:00:00	SPY	ETF	275.47	275.52	275.4	275.42	39270.0
2018-07-06 18:30:00	SPY	ETF	275.42	275.49	275.38	275.38	8389.0
2018-07-06 19:00:00	SPY	ETF	275.38	275.43	275.38	275.4	3177.0
2018-07-06 19:30:00	SPY	ETF	275.43	275.43	275.38	275.43	9975.0
2018-07-06 04:00:00	QQQ	ETF	172.91	172.95	172.65	172.91	2999.0
2018-07-06 04:30:00	QQQ	ETF	173.07	173.09	172.93	173.03	2490.0
2018-07-06 05:00:00	QQQ	ETF	173.1	173.11	172.83	172.87	3890.0
2018-07-06 05:30:00	QQQ	ETF	172.97	172.97	172.71	172.82	16443.0
2018-07-06 06:00:00	QQQ	ETF	172.83	172.83	172.72	172.75	2223.0
2018-07-06 06:30:00	QQQ	ETF	172.68	172.78	172.68	172.78	22890.0
2018-07-06 07:00:00	QQQ	ETF	172.71	172.79	172.61	172.62	22435.0
2018-07-06 07:30:00	QQQ	ETF	172.7	172.7	172.57	172.63	35215.0
2018-07-06 08:00:00	QQQ	ETF	172.92	172.92	172.5801	172.73	139097.0
2018-07-06 08:30:00	QQQ	ETF	172.93	173.64	172.93	173.15	487587.0
2018-07-06 09:00:00	QQQ	ETF	173.12	173.45	173.03	173.28	227165.0
2018-07-06 09:30:00	QQQ	ETF	173.29	173.95	173.0	173.92	3407411.0
2018-07-06 10:00:00	QQQ	ETF	173.92	174.15	173.69	173.94	2073725.0
2018-07-06 10:30:00	QQQ	ETF	173.95	174.3385	173.711	174.25	1765562.0
2018-07-06 11:00:00	QQQ	ETF	174.25	174.82	174.23	174.79	1986648.0
2018-07-06 11:30:00	QQQ	ETF	174.79	175.21	174.78	175.0775	2094416.0
2018-07-06 12:00:00	QQQ	ETF	175.08	175.35	175.05	175.31	2469596.0
2018-07-06 12:30:00	QQQ	ETF	175.3	175.4	175.14	175.24	1347190.0

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

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