PREVIEW / etf_30min / 2022-10-04

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-04.parquet
  size:    694 KB
  rows:    28,576

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
2022-10-04 04:00:00	SPY	ETF	372.0	372.07	369.18	371.57	65249.0
2022-10-04 04:30:00	SPY	ETF	371.71	372.12	371.5	372.01	39135.0
2022-10-04 05:00:00	SPY	ETF	372.06	372.06	371.0	371.97	28597.0
2022-10-04 05:30:00	SPY	ETF	371.92	372.44	371.19	372.43	27910.0
2022-10-04 06:00:00	SPY	ETF	372.4	373.3	372.12	373.29	75307.0
2022-10-04 06:30:00	SPY	ETF	373.24	373.55	372.65	372.78	89718.0
2022-10-04 07:00:00	SPY	ETF	372.8	372.8	372.1	372.17	163638.0
2022-10-04 07:30:00	SPY	ETF	372.31	372.81	372.27	372.71	220523.0
2022-10-04 08:00:00	SPY	ETF	372.6999	373.4204	369.45	372.27	519748.0
2022-10-04 08:30:00	SPY	ETF	372.27	372.5	371.66	372.43	493290.0
2022-10-04 09:00:00	SPY	ETF	372.46	372.46	371.86	372.41	432719.0
2022-10-04 09:30:00	SPY	ETF	372.4	376.07	372.31	376.0023	10379294.0
2022-10-04 10:00:00	SPY	ETF	376.01	377.24	376.01	376.08	7718746.0
2022-10-04 10:30:00	SPY	ETF	376.07	377.39	375.89	377.2201	4550196.0
2022-10-04 11:00:00	SPY	ETF	377.22	377.46	376.44	377.3407	3848739.0
2022-10-04 11:30:00	SPY	ETF	377.35	377.66	376.402	377.03	4110176.0
2022-10-04 12:00:00	SPY	ETF	377.03	377.595	376.66	377.295	3056066.0
2022-10-04 12:30:00	SPY	ETF	377.3	377.57	375.86	376.17	2932785.0
2022-10-04 13:00:00	SPY	ETF	376.16	376.2999	374.1	375.39	5183193.0
2022-10-04 13:30:00	SPY	ETF	375.39	376.78	375.14	376.29	3592084.0
2022-10-04 14:00:00	SPY	ETF	376.295	376.69	375.535	375.5991	2674254.0
2022-10-04 14:30:00	SPY	ETF	375.58	377.41	375.47	377.09	3945852.0
2022-10-04 15:00:00	SPY	ETF	377.0978	377.23	375.46	376.6	4490191.0
2022-10-04 15:30:00	SPY	ETF	376.58	378.0	376.105	377.93	13840108.0
2022-10-04 16:00:00	SPY	ETF	377.93	378.26	377.52	377.71	6327781.0
2022-10-04 16:30:00	SPY	ETF	377.71	377.97	377.61	377.79	294106.0
2022-10-04 17:00:00	SPY	ETF	377.84	377.87	377.61	377.65	133517.0
2022-10-04 17:30:00	SPY	ETF	377.65	377.8	377.65	377.68	44019.0
2022-10-04 18:00:00	SPY	ETF	377.66	377.71	376.97	377.11	180926.0
2022-10-04 18:30:00	SPY	ETF	377.16	377.21	376.9	377.11	96332.0
2022-10-04 19:00:00	SPY	ETF	377.1	377.15	376.72	376.75	36427.0
2022-10-04 19:30:00	SPY	ETF	376.74	377.14	376.73	377.05	32034.0
2022-10-04 04:00:00	QQQ	ETF	278.06	278.64	277.56	278.3	59786.0
2022-10-04 04:30:00	QQQ	ETF	278.23	278.46	278.06	278.4	24309.0
2022-10-04 05:00:00	QQQ	ETF	278.6	278.64	277.82	278.58	23798.0
2022-10-04 05:30:00	QQQ	ETF	278.61	279.0	278.14	278.84	40555.0
2022-10-04 06:00:00	QQQ	ETF	278.93	279.69	278.78	279.54	109235.0
2022-10-04 06:30:00	QQQ	ETF	279.54	279.88	279.19	279.26	131238.0
2022-10-04 07:00:00	QQQ	ETF	279.25	279.31	278.78	278.85	216559.0
2022-10-04 07:30:00	QQQ	ETF	278.92	279.17	278.8	279.09	88736.0
2022-10-04 08:00:00	QQQ	ETF	279.1401	279.6104	273.735	278.67	368854.0
2022-10-04 08:30:00	QQQ	ETF	278.63	278.99	278.224	278.98	448185.0
2022-10-04 09:00:00	QQQ	ETF	278.959	279.03	278.56	279.03	472779.0
2022-10-04 09:30:00	QQQ	ETF	278.99	281.53	278.99	281.4599	8645849.0
2022-10-04 10:00:00	QQQ	ETF	281.47	282.67	281.47	281.6	6108536.0
2022-10-04 10:30:00	QQQ	ETF	281.61	282.85	281.6	282.72	3601952.0
2022-10-04 11:00:00	QQQ	ETF	282.72	282.84	281.91	282.43	2485785.0
2022-10-04 11:30:00	QQQ	ETF	282.45	282.67	281.65	282.2	2591914.0
2022-10-04 12:00:00	QQQ	ETF	282.205	282.5	281.46	282.1467	2248920.0
2022-10-04 12:30:00	QQQ	ETF	282.145	282.3	280.81	281.1	2136636.0

> showing 50 of 28,576 rows — these rows as CSV

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