PREVIEW / etf_30min / 2018-11-05

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-05.parquet
  size:    484 KB
  rows:    16,757

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-11-05 04:00:00	SPY	ETF	271.35	271.39	271.08	271.34	21396.0
2018-11-05 04:30:00	SPY	ETF	271.41	271.7	271.36	271.7	12333.0
2018-11-05 05:00:00	SPY	ETF	271.8	271.94	271.57	271.63	17763.0
2018-11-05 05:30:00	SPY	ETF	271.68	271.95	271.57	271.92	10046.0
2018-11-05 06:00:00	SPY	ETF	271.93	272.23	271.93	272.23	16112.0
2018-11-05 06:30:00	SPY	ETF	272.19	272.4	272.02	272.38	35969.0
2018-11-05 07:00:00	SPY	ETF	272.38	272.6	272.31	272.31	110631.0
2018-11-05 07:30:00	SPY	ETF	272.31	272.36	271.93	272.19	88614.0
2018-11-05 08:00:00	SPY	ETF	271.89	272.58	271.45	271.91	158168.0
2018-11-05 08:30:00	SPY	ETF	271.89	272.3	271.71	272.2	161698.0
2018-11-05 09:00:00	SPY	ETF	272.2	272.47	272.07	272.41	335474.0
2018-11-05 09:30:00	SPY	ETF	272.44	272.97	272.07	272.14	7284581.0
2018-11-05 10:00:00	SPY	ETF	272.16	272.24	271.35	271.78	5371243.0
2018-11-05 10:30:00	SPY	ETF	271.78	272.95	271.77	272.87	4762125.0
2018-11-05 11:00:00	SPY	ETF	272.86	273.08	272.34	272.35	3187584.0
2018-11-05 11:30:00	SPY	ETF	272.37	272.86	272.06	272.76	2419617.0
2018-11-05 12:00:00	SPY	ETF	272.7598	272.86	272.31	272.53	1815198.0
2018-11-05 12:30:00	SPY	ETF	272.52	272.61	272.07	272.285	2880111.0
2018-11-05 13:00:00	SPY	ETF	272.28	272.58	272.16	272.4783	2809386.0
2018-11-05 13:30:00	SPY	ETF	272.48	273.0	272.38	272.86	2981090.0
2018-11-05 14:00:00	SPY	ETF	272.8715	273.67	272.64	273.635	5242569.0
2018-11-05 14:30:00	SPY	ETF	273.63	274.01	273.37	273.75	3273782.0
2018-11-05 15:00:00	SPY	ETF	273.74	273.94	272.88	273.3101	5215248.0
2018-11-05 15:30:00	SPY	ETF	273.32	273.65	273.03	273.43	7129432.0
2018-11-05 16:00:00	SPY	ETF	273.45	273.81	271.18	273.53	5483819.0
2018-11-05 16:30:00	SPY	ETF	273.53	273.67	273.39	273.64	797152.0
2018-11-05 17:00:00	SPY	ETF	273.59	273.64	273.5	273.5	109696.0
2018-11-05 17:30:00	SPY	ETF	273.51	273.55	271.89	273.5	24018.0
2018-11-05 18:00:00	SPY	ETF	273.53	273.79	273.42	273.64	97855.0
2018-11-05 18:30:00	SPY	ETF	273.64	273.8	273.6	273.65	31490.0
2018-11-05 19:00:00	SPY	ETF	273.69	273.86	273.56	273.84	15689.0
2018-11-05 19:30:00	SPY	ETF	273.87	274.19	273.87	274.08	21668.0
2018-11-05 04:00:00	QQQ	ETF	169.41	169.41	169.33	169.38	1506.0
2018-11-05 04:30:00	QQQ	ETF	169.48	169.77	169.48	169.77	3115.0
2018-11-05 05:00:00	QQQ	ETF	169.94	170.03	169.78	169.78	5989.0
2018-11-05 05:30:00	QQQ	ETF	169.92	170.01	169.91	169.95	1200.0
2018-11-05 06:00:00	QQQ	ETF	169.97	170.19	169.94	170.12	4103.0
2018-11-05 06:30:00	QQQ	ETF	170.12	170.21	169.94	170.18	9925.0
2018-11-05 07:00:00	QQQ	ETF	170.17	170.31	169.93	169.93	48594.0
2018-11-05 07:30:00	QQQ	ETF	169.91	169.93	169.46	169.7	72729.0
2018-11-05 08:00:00	QQQ	ETF	170.31	170.31	169.31	169.41	184302.0
2018-11-05 08:30:00	QQQ	ETF	169.46	169.66	169.32	169.6	120721.0
2018-11-05 09:00:00	QQQ	ETF	169.57	169.65	169.46	169.6	177885.0
2018-11-05 09:30:00	QQQ	ETF	169.61	169.66	167.88	168.04	6272274.0
2018-11-05 10:00:00	QQQ	ETF	168.05	168.18	167.08	167.27	3855744.0
2018-11-05 10:30:00	QQQ	ETF	167.26	168.33	167.13	168.23	3618724.0
2018-11-05 11:00:00	QQQ	ETF	168.23	168.48	167.62	167.69	2120154.0
2018-11-05 11:30:00	QQQ	ETF	167.69	168.1	167.43	167.995	1845167.0
2018-11-05 12:00:00	QQQ	ETF	168.01	168.14	167.53	167.89	1400682.0
2018-11-05 12:30:00	QQQ	ETF	167.89	167.96	167.53	167.81	1049618.0

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

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