PREVIEW / etf_30min / 2020-03-19

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-19.parquet
  size:    624 KB
  rows:    22,903

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-03-19 04:00:00	SPY	ETF	240.23	241.85	236.01	241.81	120122.0
2020-03-19 04:30:00	SPY	ETF	241.89	243.17	240.37	242.39	292975.0
2020-03-19 05:00:00	SPY	ETF	242.15	242.89	239.12	239.27	116205.0
2020-03-19 05:30:00	SPY	ETF	239.28	240.66	238.56	239.35	65858.0
2020-03-19 06:00:00	SPY	ETF	239.23	239.23	236.76	237.81	202339.0
2020-03-19 06:30:00	SPY	ETF	237.98	239.0	237.55	237.6	121845.0
2020-03-19 07:00:00	SPY	ETF	238.0	239.56	237.82	237.97	426474.0
2020-03-19 07:30:00	SPY	ETF	237.82	237.97	235.03	235.6	731031.0
2020-03-19 08:00:00	SPY	ETF	239.2999	241.02	229.31	234.89	1021543.0
2020-03-19 08:30:00	SPY	ETF	234.67	238.83	234.51	238.33	1225606.0
2020-03-19 09:00:00	SPY	ETF	238.4	240.0	237.6	239.25	1420647.0
2020-03-19 09:30:00	SPY	ETF	239.25	239.43	232.22	237.98	31265774.0
2020-03-19 10:00:00	SPY	ETF	237.99	243.91	236.54	242.13	27864981.0
2020-03-19 10:30:00	SPY	ETF	242.09	243.5	237.92	239.275	18177208.0
2020-03-19 11:00:00	SPY	ETF	239.22	245.19	238.62	244.96	17545867.0
2020-03-19 11:30:00	SPY	ETF	244.97	246.37	242.32	242.73	22769410.0
2020-03-19 12:00:00	SPY	ETF	242.7	243.32	238.95	240.65	16611931.0
2020-03-19 12:30:00	SPY	ETF	240.69	243.9	238.82	242.25	12171878.0
2020-03-19 13:00:00	SPY	ETF	242.2	243.39	241.06	241.82	10609633.0
2020-03-19 13:30:00	SPY	ETF	241.81	246.24	241.18	244.47	15841369.0
2020-03-19 14:00:00	SPY	ETF	244.48	245.63	242.37	244.17	11708665.0
2020-03-19 14:30:00	SPY	ETF	244.2	247.38	243.86	244.43	14644458.0
2020-03-19 15:00:00	SPY	ETF	244.44	245.25	240.66	244.0999	18457117.0
2020-03-19 15:30:00	SPY	ETF	244.1	245.62	240.33	241.16	43565504.0
2020-03-19 16:00:00	SPY	ETF	241.16	241.4789	238.69	239.89	11252285.0
2020-03-19 16:30:00	SPY	ETF	239.89	241.4577	236.5	237.13	2551969.0
2020-03-19 17:00:00	SPY	ETF	237.02	240.51	236.91	237.05	3613599.0
2020-03-19 17:30:00	SPY	ETF	237.05	241.4576	236.4	237.05	931554.0
2020-03-19 18:00:00	SPY	ETF	236.86	238.33	235.85	237.66	497149.0
2020-03-19 18:30:00	SPY	ETF	237.38	237.49	235.11	235.4	293610.0
2020-03-19 19:00:00	SPY	ETF	235.53	237.08	234.95	235.73	205933.0
2020-03-19 19:30:00	SPY	ETF	235.9	237.5	235.6	237.18	192557.0
2020-03-19 04:00:00	QQQ	ETF	174.5	178.17	174.36	178.17	91771.0
2020-03-19 04:30:00	QQQ	ETF	178.1	179.37	177.02	178.78	76532.0
2020-03-19 05:00:00	QQQ	ETF	178.63	179.11	176.14	176.2	114392.0
2020-03-19 05:30:00	QQQ	ETF	176.07	177.34	175.92	175.97	72552.0
2020-03-19 06:00:00	QQQ	ETF	175.88	175.88	174.36	174.99	66896.0
2020-03-19 06:30:00	QQQ	ETF	175.27	175.95	174.9	174.92	81277.0
2020-03-19 07:00:00	QQQ	ETF	175.25	176.44	174.96	174.96	186696.0
2020-03-19 07:30:00	QQQ	ETF	174.91	174.92	173.1	173.61	168765.0
2020-03-19 08:00:00	QQQ	ETF	176.2098	177.38	168.92	172.55	359025.0
2020-03-19 08:30:00	QQQ	ETF	172.56	175.46	172.56	175.29	368579.0
2020-03-19 09:00:00	QQQ	ETF	175.27	176.2	174.69	175.6	271055.0
2020-03-19 09:30:00	QQQ	ETF	175.73	177.0599	171.63	176.88	9699488.0
2020-03-19 10:00:00	QQQ	ETF	176.89	180.84	175.84	179.6383	11214948.0
2020-03-19 10:30:00	QQQ	ETF	179.61	180.55	175.95	177.09	9144479.0
2020-03-19 11:00:00	QQQ	ETF	177.09	181.92	176.66	181.7	8424874.0
2020-03-19 11:30:00	QQQ	ETF	181.715	182.29	178.93	179.1698	7781974.0
2020-03-19 12:00:00	QQQ	ETF	179.15	179.72	177.07	178.58	6139417.0
2020-03-19 12:30:00	QQQ	ETF	178.59	180.96	177.2	179.67	5267729.0

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

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