PREVIEW / etf_30min / 2020-06-04

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-04.parquet
  size:    561 KB
  rows:    20,921

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-04 04:00:00	SPY	ETF	311.5	311.57	311.05	311.17	36272.0
2020-06-04 04:30:00	SPY	ETF	311.22	311.22	310.95	310.95	8055.0
2020-06-04 05:00:00	SPY	ETF	310.95	311.05	310.46	310.48	27782.0
2020-06-04 05:30:00	SPY	ETF	310.48	310.6	310.31	310.36	35285.0
2020-06-04 06:00:00	SPY	ETF	310.31	310.62	310.3	310.62	46368.0
2020-06-04 06:30:00	SPY	ETF	310.63	310.7	310.26	310.7	94673.0
2020-06-04 07:00:00	SPY	ETF	310.66	310.84	310.55	310.81	267988.0
2020-06-04 07:30:00	SPY	ETF	310.8	311.63	310.42	311.33	912917.0
2020-06-04 08:00:00	SPY	ETF	310.66	311.75	310.3396	311.0799	413609.0
2020-06-04 08:30:00	SPY	ETF	311.0	311.21	309.79	310.44	968922.0
2020-06-04 09:00:00	SPY	ETF	310.44	311.28	310.35	311.11	483909.0
2020-06-04 09:30:00	SPY	ETF	311.11	312.25	310.96	312.09	7235338.0
2020-06-04 10:00:00	SPY	ETF	312.08	312.66	311.89	312.56	6493686.0
2020-06-04 10:30:00	SPY	ETF	312.55	313.0	312.39	312.77	4140826.0
2020-06-04 11:00:00	SPY	ETF	312.775	312.89	311.08	311.38	7350216.0
2020-06-04 11:30:00	SPY	ETF	311.38	311.84	311.2	311.531	4561546.0
2020-06-04 12:00:00	SPY	ETF	311.53	311.75	311.1	311.36	2963134.0
2020-06-04 12:30:00	SPY	ETF	311.36	311.36	310.48	310.5	3994280.0
2020-06-04 13:00:00	SPY	ETF	310.5	310.92	310.39	310.53	2947902.0
2020-06-04 13:30:00	SPY	ETF	310.54	311.68	310.54	311.51	3508784.0
2020-06-04 14:00:00	SPY	ETF	311.5	311.6899	311.25	311.52	3570596.0
2020-06-04 14:30:00	SPY	ETF	311.53	311.62	310.14	310.15	4434860.0
2020-06-04 15:00:00	SPY	ETF	310.14	310.59	309.08	310.09	6354837.0
2020-06-04 15:30:00	SPY	ETF	310.1	311.34	309.94	311.31	10748787.0
2020-06-04 16:00:00	SPY	ETF	311.3	311.45	311.15	311.35	2504536.0
2020-06-04 16:30:00	SPY	ETF	311.39	311.95	311.39	311.7	303258.0
2020-06-04 17:00:00	SPY	ETF	311.73	311.77	311.6	311.6	74501.0
2020-06-04 17:30:00	SPY	ETF	311.62	311.66	311.36	311.6	95617.0
2020-06-04 18:00:00	SPY	ETF	311.63	311.89	311.48	311.89	56722.0
2020-06-04 18:30:00	SPY	ETF	311.81	312.03	311.55	311.7	62531.0
2020-06-04 19:00:00	SPY	ETF	311.75	311.86	311.47	311.86	39036.0
2020-06-04 19:30:00	SPY	ETF	311.83	311.83	311.15	311.2	162100.0
2020-06-04 04:00:00	QQQ	ETF	236.36	236.58	236.12	236.18	8409.0
2020-06-04 04:30:00	QQQ	ETF	236.08	236.1	235.96	235.96	2700.0
2020-06-04 05:00:00	QQQ	ETF	235.95	236.11	235.7	235.72	4650.0
2020-06-04 05:30:00	QQQ	ETF	235.78	235.84	235.58	235.64	8186.0
2020-06-04 06:00:00	QQQ	ETF	235.59	236.0	235.59	236.0	27875.0
2020-06-04 06:30:00	QQQ	ETF	236.0	236.12	235.53	235.93	34002.0
2020-06-04 07:00:00	QQQ	ETF	236.03	236.13	235.83	235.95	54762.0
2020-06-04 07:30:00	QQQ	ETF	235.95	236.33	235.76	236.15	121351.0
2020-06-04 08:00:00	QQQ	ETF	235.92	236.38	235.5704	236.23	153203.0
2020-06-04 08:30:00	QQQ	ETF	236.2	236.25	235.45	235.84	197082.0
2020-06-04 09:00:00	QQQ	ETF	235.8	236.46	235.75	236.31	160753.0
2020-06-04 09:30:00	QQQ	ETF	236.31	237.79	236.03	237.36	3405784.0
2020-06-04 10:00:00	QQQ	ETF	237.36	237.545	236.9	237.3914	2673625.0
2020-06-04 10:30:00	QQQ	ETF	237.4	237.77	236.83	237.0	1964304.0
2020-06-04 11:00:00	QQQ	ETF	236.98	237.12	235.26	235.55	3956402.0
2020-06-04 11:30:00	QQQ	ETF	235.555	236.22	235.38	235.952	2363829.0
2020-06-04 12:00:00	QQQ	ETF	235.97	236.27	235.55	235.86	1542652.0
2020-06-04 12:30:00	QQQ	ETF	235.86	235.8695	234.91	234.96	2332650.0

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

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