PREVIEW / etf_30min / 2020-03-09

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-09.parquet
  size:    655 KB
  rows:    24,521

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-09 04:00:00	SPY	ETF	280.2	289.4	277.01	277.78	219002.0
2020-03-09 04:30:00	SPY	ETF	277.48	279.7	276.54	278.91	105009.0
2020-03-09 05:00:00	SPY	ETF	278.75	283.13	278.16	281.7	158136.0
2020-03-09 05:30:00	SPY	ETF	281.8	281.8	279.12	279.31	150499.0
2020-03-09 06:00:00	SPY	ETF	279.85	281.51	278.5	280.6	105447.0
2020-03-09 06:30:00	SPY	ETF	280.52	281.49	279.0	279.25	121554.0
2020-03-09 07:00:00	SPY	ETF	279.5	281.0	278.05	278.3	496131.0
2020-03-09 07:30:00	SPY	ETF	278.16	278.8	277.18	278.5	760181.0
2020-03-09 08:00:00	SPY	ETF	277.35	282.82	275.67	276.04	1359139.0
2020-03-09 08:30:00	SPY	ETF	276.18	278.35	275.74	277.38	1231697.0
2020-03-09 09:00:00	SPY	ETF	277.38	277.66	273.92	275.15	2611709.0
2020-03-09 09:30:00	SPY	ETF	275.3	281.66	273.5	279.93	18706586.0
2020-03-09 10:00:00	SPY	ETF	279.77	282.63	278.33	280.72	23412058.0
2020-03-09 10:30:00	SPY	ETF	280.69	281.94	278.42	278.61	19090637.0
2020-03-09 11:00:00	SPY	ETF	278.61	281.8	278.02	281.03	17195034.0
2020-03-09 11:30:00	SPY	ETF	281.04	284.08	280.06	282.69	19055084.0
2020-03-09 12:00:00	SPY	ETF	282.69	284.19	280.95	281.01	17183496.0
2020-03-09 12:30:00	SPY	ETF	281.01	281.63	279.01	279.71	13375276.0
2020-03-09 13:00:00	SPY	ETF	279.71	280.71	278.24	278.59	11457345.0
2020-03-09 13:30:00	SPY	ETF	278.59	278.63	275.34	275.84	19447863.0
2020-03-09 14:00:00	SPY	ETF	275.84	277.53	274.06	274.95	21202126.0
2020-03-09 14:30:00	SPY	ETF	274.95	277.64	273.45	276.59	25909392.0
2020-03-09 15:00:00	SPY	ETF	276.63	279.06	275.55	277.9	24543334.0
2020-03-09 15:30:00	SPY	ETF	277.89	279.33	274.37	274.4	46722494.0
2020-03-09 16:00:00	SPY	ETF	274.41	275.74	272.83	274.9	14739647.0
2020-03-09 16:30:00	SPY	ETF	274.9	275.95	273.81	274.0	3332929.0
2020-03-09 17:00:00	SPY	ETF	274.0	276.25	273.75	273.95	372824.0
2020-03-09 17:30:00	SPY	ETF	273.95	274.16	273.37	274.1	359559.0
2020-03-09 18:00:00	SPY	ETF	274.04	274.04	270.27	272.69	897206.0
2020-03-09 18:30:00	SPY	ETF	273.01	277.37	272.31	277.05	824276.0
2020-03-09 19:00:00	SPY	ETF	277.15	297.3813	277.06	279.7	1190588.0
2020-03-09 19:30:00	SPY	ETF	279.7	281.58	279.05	280.25	506269.0
2020-03-09 04:00:00	QQQ	ETF	197.53	199.0	195.08	195.25	34238.0
2020-03-09 04:30:00	QQQ	ETF	195.02	195.9	194.01	195.64	28958.0
2020-03-09 05:00:00	QQQ	ETF	195.6	198.45	195.24	197.89	50893.0
2020-03-09 05:30:00	QQQ	ETF	197.91	198.06	196.05	196.6	41608.0
2020-03-09 06:00:00	QQQ	ETF	196.71	196.86	195.51	196.5	51183.0
2020-03-09 06:30:00	QQQ	ETF	196.5	197.12	195.7	196.4	50835.0
2020-03-09 07:00:00	QQQ	ETF	196.21	197.9	195.0	195.5	114070.0
2020-03-09 07:30:00	QQQ	ETF	195.45	195.95	195.0	195.49	143431.0
2020-03-09 08:00:00	QQQ	ETF	195.5	208.02	194.22	194.75	298602.0
2020-03-09 08:30:00	QQQ	ETF	194.7101	195.5	194.0	194.73	303928.0
2020-03-09 09:00:00	QQQ	ETF	194.78	194.84	192.8	193.54	365527.0
2020-03-09 09:30:00	QQQ	ETF	193.48	197.89	192.11	197.25	6313178.0
2020-03-09 10:00:00	QQQ	ETF	197.25	199.63	195.97	197.5699	9708744.0
2020-03-09 10:30:00	QQQ	ETF	197.54	198.6	196.45	196.8237	7367601.0
2020-03-09 11:00:00	QQQ	ETF	196.82	199.16	196.325	198.41	6462324.0
2020-03-09 11:30:00	QQQ	ETF	198.42	200.7	197.72	200.04	6080796.0
2020-03-09 12:00:00	QQQ	ETF	200.02	201.16	198.99	199.04	4579765.0
2020-03-09 12:30:00	QQQ	ETF	199.03	199.51	197.69	198.23	4855173.0

> showing 50 of 24,521 rows — these rows as CSV

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