PREVIEW / etf_30min / 2020-06-26

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-26.parquet
  size:    542 KB
  rows:    20,294

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-06-26 04:00:00	SPY	ETF	306.48	306.48	304.99	305.45	46497.0
2020-06-26 04:30:00	SPY	ETF	305.35	306.18	305.35	306.09	57298.0
2020-06-26 05:00:00	SPY	ETF	305.97	306.5	305.97	306.29	35098.0
2020-06-26 05:30:00	SPY	ETF	306.29	307.02	306.29	306.81	36325.0
2020-06-26 06:00:00	SPY	ETF	307.0	307.75	306.99	307.47	72086.0
2020-06-26 06:30:00	SPY	ETF	307.45	307.6	307.35	307.54	38692.0
2020-06-26 07:00:00	SPY	ETF	307.58	308.11	307.3	307.3	182348.0
2020-06-26 07:30:00	SPY	ETF	307.34	307.43	306.94	307.0	154162.0
2020-06-26 08:00:00	SPY	ETF	306.2	308.2	305.4	306.78	344523.0
2020-06-26 08:30:00	SPY	ETF	306.7	306.96	305.84	306.05	398391.0
2020-06-26 09:00:00	SPY	ETF	306.1	306.35	305.97	306.19	309024.0
2020-06-26 09:30:00	SPY	ETF	306.16	306.39	304.5201	305.2301	7630445.0
2020-06-26 10:00:00	SPY	ETF	305.23	305.25	302.07	302.86	9275605.0
2020-06-26 10:30:00	SPY	ETF	302.87	303.1	300.69	301.51	11348553.0
2020-06-26 11:00:00	SPY	ETF	301.54	302.84	301.45	301.99	7459701.0
2020-06-26 11:30:00	SPY	ETF	302.02	302.91	301.39	302.603	4413032.0
2020-06-26 12:00:00	SPY	ETF	302.61	302.67	300.5	301.638	5031679.0
2020-06-26 12:30:00	SPY	ETF	301.63	301.92	300.74	301.83	4438766.0
2020-06-26 13:00:00	SPY	ETF	301.8	302.5	301.54	302.135	4956413.0
2020-06-26 13:30:00	SPY	ETF	302.13	302.58	301.71	301.79	3853284.0
2020-06-26 14:00:00	SPY	ETF	301.79	302.09	300.63	300.89	6715507.0
2020-06-26 14:30:00	SPY	ETF	300.89	301.09	299.85	300.47	9615898.0
2020-06-26 15:00:00	SPY	ETF	300.46	301.035	299.66	300.345	10335709.0
2020-06-26 15:30:00	SPY	ETF	300.34	301.46	299.42	300.01	23067163.0
2020-06-26 16:00:00	SPY	ETF	300.01	301.45	299.8916	300.77	15518999.0
2020-06-26 16:30:00	SPY	ETF	300.77	300.91	300.26	300.39	496173.0
2020-06-26 17:00:00	SPY	ETF	300.33	300.61	300.05	300.61	127959.0
2020-06-26 17:30:00	SPY	ETF	300.59	300.7	300.25	300.47	84287.0
2020-06-26 18:00:00	SPY	ETF	300.45	300.47	300.27	300.3	20218.0
2020-06-26 18:30:00	SPY	ETF	300.3	300.33	300.19	300.25	33624.0
2020-06-26 19:00:00	SPY	ETF	300.27	300.3	300.0	300.08	52317.0
2020-06-26 19:30:00	SPY	ETF	300.06	300.16	299.95	300.15	42007.0
2020-06-26 04:00:00	QQQ	ETF	245.56	245.56	244.8	245.05	41944.0
2020-06-26 04:30:00	QQQ	ETF	245.14	245.72	245.14	245.72	23200.0
2020-06-26 05:00:00	QQQ	ETF	245.72	245.98	245.68	245.86	2889.0
2020-06-26 05:30:00	QQQ	ETF	245.93	246.2	245.93	246.17	4700.0
2020-06-26 06:00:00	QQQ	ETF	246.25	246.64	246.25	246.56	16786.0
2020-06-26 06:30:00	QQQ	ETF	246.55	246.68	246.48	246.55	33967.0
2020-06-26 07:00:00	QQQ	ETF	246.53	246.86	246.35	246.35	52824.0
2020-06-26 07:30:00	QQQ	ETF	246.43	246.5	246.15	246.18	38258.0
2020-06-26 08:00:00	QQQ	ETF	246.56	246.84	245.15	246.1499	60711.0
2020-06-26 08:30:00	QQQ	ETF	246.2	246.31	245.56	245.72	106776.0
2020-06-26 09:00:00	QQQ	ETF	245.78	245.84	245.57	245.75	180826.0
2020-06-26 09:30:00	QQQ	ETF	245.75	245.96	243.86	244.47	3737099.0
2020-06-26 10:00:00	QQQ	ETF	244.43	244.43	241.43	242.28	4209403.0
2020-06-26 10:30:00	QQQ	ETF	242.24	242.46	240.37	241.22	5473040.0
2020-06-26 11:00:00	QQQ	ETF	241.24	242.65	241.18	242.29	5212200.0
2020-06-26 11:30:00	QQQ	ETF	242.35	243.51	241.75	243.235	3273802.0
2020-06-26 12:00:00	QQQ	ETF	243.235	243.28	241.06	241.84	2434899.0
2020-06-26 12:30:00	QQQ	ETF	241.86	242.14	240.98	242.05	2125845.0

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

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