PREVIEW / etf_30min / 2020-05-04

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-04.parquet
  size:    559 KB
  rows:    20,568

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-05-04 04:00:00	SPY	ETF	280.56	281.12	279.92	280.18	83733.0
2020-05-04 04:30:00	SPY	ETF	280.07	280.2	279.71	279.8	31110.0
2020-05-04 05:00:00	SPY	ETF	279.69	279.69	278.69	278.75	53965.0
2020-05-04 05:30:00	SPY	ETF	278.79	279.89	278.78	279.89	84390.0
2020-05-04 06:00:00	SPY	ETF	279.94	280.51	279.61	280.07	164778.0
2020-05-04 06:30:00	SPY	ETF	280.18	280.32	279.78	279.99	58561.0
2020-05-04 07:00:00	SPY	ETF	280.03	280.25	279.69	280.13	119782.0
2020-05-04 07:30:00	SPY	ETF	280.06	280.85	280.06	280.36	302737.0
2020-05-04 08:00:00	SPY	ETF	280.31	281.55	279.7	281.0	328075.0
2020-05-04 08:30:00	SPY	ETF	280.96	281.07	280.39	280.44	499235.0
2020-05-04 09:00:00	SPY	ETF	280.4	281.02	280.09	280.73	708784.0
2020-05-04 09:30:00	SPY	ETF	280.74	280.97	279.13	280.57	10596300.0
2020-05-04 10:00:00	SPY	ETF	280.58	282.11	280.44	281.12	7321565.0
2020-05-04 10:30:00	SPY	ETF	281.12	281.55	280.63	280.6901	5622778.0
2020-05-04 11:00:00	SPY	ETF	280.7	281.73	280.53	280.96	4938952.0
2020-05-04 11:30:00	SPY	ETF	280.98	281.88	280.76	281.42	4495343.0
2020-05-04 12:00:00	SPY	ETF	281.42	281.95	281.29	281.88	2744009.0
2020-05-04 12:30:00	SPY	ETF	281.89	282.05	280.91	281.09	2982498.0
2020-05-04 13:00:00	SPY	ETF	281.1	281.28	280.2	280.8	4789329.0
2020-05-04 13:30:00	SPY	ETF	280.8	281.49	280.8	281.46	2786974.0
2020-05-04 14:00:00	SPY	ETF	281.44	281.82	281.19	281.53	3476260.0
2020-05-04 14:30:00	SPY	ETF	281.55	282.61	281.11	282.4791	5037650.0
2020-05-04 15:00:00	SPY	ETF	282.47	283.4	282.26	283.27	5910529.0
2020-05-04 15:30:00	SPY	ETF	283.28	283.9	283.05	283.66	9497473.0
2020-05-04 16:00:00	SPY	ETF	283.64	283.7135	280.55	282.96	6521110.0
2020-05-04 16:30:00	SPY	ETF	282.95	283.57	282.69	283.14	329542.0
2020-05-04 17:00:00	SPY	ETF	283.15	283.57	282.93	282.94	244772.0
2020-05-04 17:30:00	SPY	ETF	282.99	283.57	282.9	282.9	64436.0
2020-05-04 18:00:00	SPY	ETF	282.9	283.66	282.86	283.59	219674.0
2020-05-04 18:30:00	SPY	ETF	283.57	283.69	282.99	283.13	80461.0
2020-05-04 19:00:00	SPY	ETF	283.13	283.31	282.95	283.17	31813.0
2020-05-04 19:30:00	SPY	ETF	283.26	283.52	283.17	283.51	75030.0
2020-05-04 04:00:00	QQQ	ETF	211.43	211.92	211.17	211.36	39992.0
2020-05-04 04:30:00	QQQ	ETF	211.08	211.29	210.96	211.11	22414.0
2020-05-04 05:00:00	QQQ	ETF	211.0	211.0	210.4	210.41	13482.0
2020-05-04 05:30:00	QQQ	ETF	210.45	211.04	210.43	211.04	30842.0
2020-05-04 06:00:00	QQQ	ETF	211.12	211.47	210.91	211.31	69741.0
2020-05-04 06:30:00	QQQ	ETF	211.33	211.38	210.97	210.97	9306.0
2020-05-04 07:00:00	QQQ	ETF	211.04	211.08	210.72	210.99	57569.0
2020-05-04 07:30:00	QQQ	ETF	211.02	211.81	211.02	211.48	95961.0
2020-05-04 08:00:00	QQQ	ETF	211.52	212.18	210.75	211.63	601419.0
2020-05-04 08:30:00	QQQ	ETF	211.64	211.77	211.24	211.44	119896.0
2020-05-04 09:00:00	QQQ	ETF	211.3	212.0	210.45	211.58	298806.0
2020-05-04 09:30:00	QQQ	ETF	211.58	212.93	211.12	212.78	4954298.0
2020-05-04 10:00:00	QQQ	ETF	212.83	214.03	212.67	213.38	3142319.0
2020-05-04 10:30:00	QQQ	ETF	213.37	213.74	212.95	213.115	2042976.0
2020-05-04 11:00:00	QQQ	ETF	213.115	214.12	212.975	213.44	1653691.0
2020-05-04 11:30:00	QQQ	ETF	213.46	214.34	213.311	213.96	1604305.0
2020-05-04 12:00:00	QQQ	ETF	213.95	214.24	213.61	213.86	1039350.0
2020-05-04 12:30:00	QQQ	ETF	213.8766	213.94	212.755	212.9155	1343889.0

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

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