PREVIEW / etf_30min / 2020-09-11

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-11.parquet
  size:    541 KB
  rows:    20,030

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-09-11 04:00:00	SPY	ETF	336.17	337.37	336.17	336.98	26594.0
2020-09-11 04:30:00	SPY	ETF	336.99	337.42	336.73	336.85	5916.0
2020-09-11 05:00:00	SPY	ETF	336.66	337.43	336.66	337.41	6429.0
2020-09-11 05:30:00	SPY	ETF	337.46	337.61	337.2	337.5	8165.0
2020-09-11 06:00:00	SPY	ETF	337.56	337.56	336.53	336.75	21764.0
2020-09-11 06:30:00	SPY	ETF	336.91	337.4	336.82	336.85	91852.0
2020-09-11 07:00:00	SPY	ETF	336.89	337.25	336.28	336.28	145473.0
2020-09-11 07:30:00	SPY	ETF	336.47	336.88	336.18	336.7	74369.0
2020-09-11 08:00:00	SPY	ETF	336.65	337.24	335.66	336.18	144621.0
2020-09-11 08:30:00	SPY	ETF	336.25	336.3475	335.34	335.65	281413.0
2020-09-11 09:00:00	SPY	ETF	335.63	336.2	335.61	335.8	184684.0
2020-09-11 09:30:00	SPY	ETF	335.82	336.53	333.94	334.18	6726943.0
2020-09-11 10:00:00	SPY	ETF	334.17	336.05	333.71	335.46	6656045.0
2020-09-11 10:30:00	SPY	ETF	335.46	336.59	334.54	335.62	4508885.0
2020-09-11 11:00:00	SPY	ETF	335.65	336.97	335.2623	335.56	5042856.0
2020-09-11 11:30:00	SPY	ETF	335.55	335.57	334.7	334.8	3443543.0
2020-09-11 12:00:00	SPY	ETF	334.785	335.86	334.38	335.24	3554644.0
2020-09-11 12:30:00	SPY	ETF	335.23	335.23	333.06	333.14	5094722.0
2020-09-11 13:00:00	SPY	ETF	333.14	333.53	331.59	331.7	6005735.0
2020-09-11 13:30:00	SPY	ETF	331.7	332.73	331.0	331.475	5137784.0
2020-09-11 14:00:00	SPY	ETF	331.48	333.13	331.125	332.41	3797340.0
2020-09-11 14:30:00	SPY	ETF	332.41	334.32	332.4	333.62	4827477.0
2020-09-11 15:00:00	SPY	ETF	333.6	334.92	332.36	334.71	6801970.0
2020-09-11 15:30:00	SPY	ETF	334.73	335.36	333.82	334.08	11490827.0
2020-09-11 16:00:00	SPY	ETF	334.09	334.8	333.23	333.67	8318489.0
2020-09-11 16:30:00	SPY	ETF	333.65	333.89	333.6	333.88	450273.0
2020-09-11 17:00:00	SPY	ETF	333.89	334.06	333.67	333.95	61719.0
2020-09-11 17:30:00	SPY	ETF	333.95	334.06	333.71	333.95	649428.0
2020-09-11 18:00:00	SPY	ETF	333.92	333.96	333.76	333.9	9048.0
2020-09-11 18:30:00	SPY	ETF	333.87	333.88	333.7101	333.75	10976.0
2020-09-11 19:00:00	SPY	ETF	333.81	333.81	333.74	333.74	11757.0
2020-09-11 19:30:00	SPY	ETF	333.72	333.97	333.61	333.91	19344.0
2020-09-11 04:00:00	QQQ	ETF	275.42	276.83	275.42	276.42	52324.0
2020-09-11 04:30:00	QQQ	ETF	276.44	277.0	276.03	276.03	20501.0
2020-09-11 05:00:00	QQQ	ETF	276.15	276.53	275.94	276.5	14200.0
2020-09-11 05:30:00	QQQ	ETF	276.5	276.55	276.16	276.22	11451.0
2020-09-11 06:00:00	QQQ	ETF	276.33	276.33	274.88	275.09	77481.0
2020-09-11 06:30:00	QQQ	ETF	275.18	275.54	274.55	274.83	109398.0
2020-09-11 07:00:00	QQQ	ETF	274.85	275.27	274.35	274.49	117689.0
2020-09-11 07:30:00	QQQ	ETF	274.62	275.56	274.26	275.3	163027.0
2020-09-11 08:00:00	QQQ	ETF	274.77	276.56	274.15	274.42	218156.0
2020-09-11 08:30:00	QQQ	ETF	274.42	274.42	273.4	273.57	323811.0
2020-09-11 09:00:00	QQQ	ETF	273.54	274.4	273.54	274.33	222320.0
2020-09-11 09:30:00	QQQ	ETF	274.36	275.22	271.46	271.78	5623715.0
2020-09-11 10:00:00	QQQ	ETF	271.77	273.76	270.78	273.2776	5907910.0
2020-09-11 10:30:00	QQQ	ETF	273.28	274.67	271.85	273.4	4259488.0
2020-09-11 11:00:00	QQQ	ETF	273.4	274.79	272.3001	272.66	3169829.0
2020-09-11 11:30:00	QQQ	ETF	272.64	272.65	271.22	271.25	3391773.0
2020-09-11 12:00:00	QQQ	ETF	271.24	272.28	270.9	271.45	2695020.0
2020-09-11 12:30:00	QQQ	ETF	271.45	271.47	268.81	268.9	4344999.0

> showing 50 of 20,030 rows — these rows as CSV

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