PREVIEW / etf_30min / 2020-08-11

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-11.parquet
  size:    590 KB
  rows:    21,922

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-08-11 04:00:00	SPY	ETF	336.91	337.2	336.6	337.17	50567.0
2020-08-11 04:30:00	SPY	ETF	337.18	337.84	337.18	337.84	31718.0
2020-08-11 05:00:00	SPY	ETF	337.84	337.87	337.55	337.8	9958.0
2020-08-11 05:30:00	SPY	ETF	337.8	337.93	337.65	337.69	16015.0
2020-08-11 06:00:00	SPY	ETF	337.68	337.73	337.57	337.73	18182.0
2020-08-11 06:30:00	SPY	ETF	337.75	337.75	337.32	337.44	33936.0
2020-08-11 07:00:00	SPY	ETF	337.36	337.7	337.06	337.21	121063.0
2020-08-11 07:30:00	SPY	ETF	337.2	337.3	336.88	336.98	97729.0
2020-08-11 08:00:00	SPY	ETF	337.17	337.85	335.98	337.19	156195.0
2020-08-11 08:30:00	SPY	ETF	337.19	337.44	336.87	337.12	175164.0
2020-08-11 09:00:00	SPY	ETF	337.137	337.22	336.75	336.87	197937.0
2020-08-11 09:30:00	SPY	ETF	336.85	337.27	336.27	336.4	5985340.0
2020-08-11 10:00:00	SPY	ETF	336.39	336.5423	335.54	336.52	4194248.0
2020-08-11 10:30:00	SPY	ETF	336.52	336.83	336.1	336.6499	3041065.0
2020-08-11 11:00:00	SPY	ETF	336.66	337.21	336.61	337.12	3069298.0
2020-08-11 11:30:00	SPY	ETF	337.13	337.2	336.41	336.62	2100027.0
2020-08-11 12:00:00	SPY	ETF	336.63	337.15	336.25	337.06	3365394.0
2020-08-11 12:30:00	SPY	ETF	337.055	337.21	336.8	337.0	2006855.0
2020-08-11 13:00:00	SPY	ETF	337.0	337.54	336.8	337.44	2135203.0
2020-08-11 13:30:00	SPY	ETF	337.45	337.4701	336.88	337.22	2575745.0
2020-08-11 14:00:00	SPY	ETF	337.235	337.385	336.22	336.275	2401947.0
2020-08-11 14:30:00	SPY	ETF	336.26	336.41	335.75	336.3199	3771720.0
2020-08-11 15:00:00	SPY	ETF	336.32	336.38	333.56	334.81	8192647.0
2020-08-11 15:30:00	SPY	ETF	334.82	335.4568	332.01	332.82	17031778.0
2020-08-11 16:00:00	SPY	ETF	332.84	333.75	332.19	333.36	6930049.0
2020-08-11 16:30:00	SPY	ETF	333.37	333.87	332.8	333.72	287431.0
2020-08-11 17:00:00	SPY	ETF	333.65	333.92	333.65	333.87	50064.0
2020-08-11 17:30:00	SPY	ETF	333.8	334.13	333.65	334.13	51531.0
2020-08-11 18:00:00	SPY	ETF	334.0	334.13	333.45	333.5	133630.0
2020-08-11 18:30:00	SPY	ETF	333.62	333.8	333.35	333.66	48758.0
2020-08-11 19:00:00	SPY	ETF	333.6	333.6	333.25	333.4	148538.0
2020-08-11 19:30:00	SPY	ETF	333.45	333.74	333.35	333.37	190003.0
2020-08-11 04:00:00	QQQ	ETF	271.51	271.63	271.32	271.52	20294.0
2020-08-11 04:30:00	QQQ	ETF	271.59	272.03	271.56	271.97	14558.0
2020-08-11 05:00:00	QQQ	ETF	272.04	272.16	271.79	271.94	29102.0
2020-08-11 05:30:00	QQQ	ETF	271.89	271.95	271.69	271.7	28988.0
2020-08-11 06:00:00	QQQ	ETF	271.69	271.76	271.43	271.63	10026.0
2020-08-11 06:30:00	QQQ	ETF	271.6	271.74	271.39	271.4	21194.0
2020-08-11 07:00:00	QQQ	ETF	271.39	271.51	270.75	270.77	131123.0
2020-08-11 07:30:00	QQQ	ETF	270.78	270.88	269.79	269.98	269481.0
2020-08-11 08:00:00	QQQ	ETF	270.6	271.6796	269.68	269.71	180434.0
2020-08-11 08:30:00	QQQ	ETF	269.77	270.31	268.13	268.89	598556.0
2020-08-11 09:00:00	QQQ	ETF	268.9	269.23	268.57	269.09	134904.0
2020-08-11 09:30:00	QQQ	ETF	269.08	269.44	267.35	268.57	5782227.0
2020-08-11 10:00:00	QQQ	ETF	268.57	268.71	267.0	268.38	3128587.0
2020-08-11 10:30:00	QQQ	ETF	268.4	268.9582	267.71	268.58	1916181.0
2020-08-11 11:00:00	QQQ	ETF	268.58	270.1486	268.57	269.91	1745449.0
2020-08-11 11:30:00	QQQ	ETF	269.96	269.98	268.8	269.02	1485704.0
2020-08-11 12:00:00	QQQ	ETF	269.03	270.18	268.71	269.98	1344101.0
2020-08-11 12:30:00	QQQ	ETF	269.97	270.44	269.7	269.89	1265187.0

> showing 50 of 21,922 rows — these rows as CSV

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