PREVIEW / etf_30min / 2020-10-28

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-28.parquet
  size:    597 KB
  rows:    22,391

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
2020-10-28 04:00:00	SPY	ETF	335.27	335.57	333.35	333.6	115627.0
2020-10-28 04:30:00	SPY	ETF	333.6	334.2	333.17	334.2	74395.0
2020-10-28 05:00:00	SPY	ETF	334.07	334.57	333.88	334.05	76616.0
2020-10-28 05:30:00	SPY	ETF	334.03	334.03	333.31	333.84	58356.0
2020-10-28 06:00:00	SPY	ETF	333.89	334.3	333.69	333.69	24963.0
2020-10-28 06:30:00	SPY	ETF	333.73	334.03	333.3	333.3	44917.0
2020-10-28 07:00:00	SPY	ETF	333.39	333.7	332.86	333.52	218452.0
2020-10-28 07:30:00	SPY	ETF	333.53	333.82	333.28	333.4	128535.0
2020-10-28 08:00:00	SPY	ETF	333.37	337.05	332.9	333.15	523141.0
2020-10-28 08:30:00	SPY	ETF	333.16	334.76	331.38	331.76	704653.0
2020-10-28 09:00:00	SPY	ETF	331.75	332.25	331.38	332.11	806479.0
2020-10-28 09:30:00	SPY	ETF	332.1	332.84	330.91	331.299	11259794.0
2020-10-28 10:00:00	SPY	ETF	331.29	331.44	328.22	328.79	10234021.0
2020-10-28 10:30:00	SPY	ETF	328.77	329.56	327.7212	328.57	10210910.0
2020-10-28 11:00:00	SPY	ETF	328.55	338.2483	327.6	328.3419	7213103.0
2020-10-28 11:30:00	SPY	ETF	328.35	330.07	327.58	329.6901	7299377.0
2020-10-28 12:00:00	SPY	ETF	329.67	330.34	329.23	329.35	5439312.0
2020-10-28 12:30:00	SPY	ETF	329.34	329.58	327.85	328.41	5047723.0
2020-10-28 13:00:00	SPY	ETF	328.38	328.45	327.14	328.282	5539254.0
2020-10-28 13:30:00	SPY	ETF	328.28	328.87	327.89	328.75	4584639.0
2020-10-28 14:00:00	SPY	ETF	328.75	329.04	327.37	328.9499	5659204.0
2020-10-28 14:30:00	SPY	ETF	328.9299	329.18	327.65	328.78	6494885.0
2020-10-28 15:00:00	SPY	ETF	328.79	329.37	327.84	328.95	8450248.0
2020-10-28 15:30:00	SPY	ETF	328.94	329.85	326.13	326.68	23010104.0
2020-10-28 16:00:00	SPY	ETF	326.68	328.3918	326.24	327.1	9627756.0
2020-10-28 16:30:00	SPY	ETF	327.06	327.9	326.66	327.51	692033.0
2020-10-28 17:00:00	SPY	ETF	327.54	327.58	327.17	327.39	156126.0
2020-10-28 17:30:00	SPY	ETF	327.39	327.65	326.66	327.53	156414.0
2020-10-28 18:00:00	SPY	ETF	327.53	328.16	327.53	327.95	200880.0
2020-10-28 18:30:00	SPY	ETF	328.0	328.22	327.81	328.17	86982.0
2020-10-28 19:00:00	SPY	ETF	328.17	328.24	327.32	327.48	126643.0
2020-10-28 19:30:00	SPY	ETF	327.56	328.27	327.5	328.22	91262.0
2020-10-28 04:00:00	QQQ	ETF	280.92	281.12	279.14	279.68	49615.0
2020-10-28 04:30:00	QQQ	ETF	279.67	280.39	279.41	280.17	50622.0
2020-10-28 05:00:00	QQQ	ETF	280.07	280.27	279.84	279.99	43070.0
2020-10-28 05:30:00	QQQ	ETF	279.97	279.97	279.56	279.83	33751.0
2020-10-28 06:00:00	QQQ	ETF	279.83	280.07	279.67	279.72	17080.0
2020-10-28 06:30:00	QQQ	ETF	279.74	279.89	278.95	278.98	34219.0
2020-10-28 07:00:00	QQQ	ETF	279.05	279.9	279.05	279.71	91999.0
2020-10-28 07:30:00	QQQ	ETF	279.71	279.77	279.11	279.13	81516.0
2020-10-28 08:00:00	QQQ	ETF	279.4301	282.0	278.79	278.9	123467.0
2020-10-28 08:30:00	QQQ	ETF	278.9	278.93	277.69	278.06	225570.0
2020-10-28 09:00:00	QQQ	ETF	278.0	278.38	277.87	278.13	216537.0
2020-10-28 09:30:00	QQQ	ETF	278.11	278.6401	274.88	275.78	5389379.0
2020-10-28 10:00:00	QQQ	ETF	275.78	275.89	273.47	273.976	4189867.0
2020-10-28 10:30:00	QQQ	ETF	273.99	274.9	273.33	274.22	3520050.0
2020-10-28 11:00:00	QQQ	ETF	274.2	274.725	273.37	273.73	2664784.0
2020-10-28 11:30:00	QQQ	ETF	273.71	274.76	273.16	274.3082	2949420.0
2020-10-28 12:00:00	QQQ	ETF	274.29	274.87	273.84	274.02	1846005.0
2020-10-28 12:30:00	QQQ	ETF	274.03	274.3194	273.03	273.33	1889781.0

> showing 50 of 22,391 rows — these rows as CSV

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