PREVIEW / etf_30min / 2022-01-10

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-10.parquet
  size:    698 KB
  rows:    27,475

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-01-10 04:00:00	SPY	ETF	466.5	466.68	465.85	466.68	10318.0
2022-01-10 04:30:00	SPY	ETF	466.74	466.86	466.22	466.22	3496.0
2022-01-10 05:00:00	SPY	ETF	466.0	466.8	465.95	466.2	5244.0
2022-01-10 05:30:00	SPY	ETF	466.24	466.34	465.72	465.82	3674.0
2022-01-10 06:00:00	SPY	ETF	465.95	465.95	465.33	465.33	3388.0
2022-01-10 06:30:00	SPY	ETF	465.4	465.69	464.95	465.6	10047.0
2022-01-10 07:00:00	SPY	ETF	465.65	465.77	464.46	464.6	76637.0
2022-01-10 07:30:00	SPY	ETF	464.62	464.62	462.74	462.74	223536.0
2022-01-10 08:00:00	SPY	ETF	464.5515	467.0	462.59	463.3	167107.0
2022-01-10 08:30:00	SPY	ETF	463.25	463.55	462.76	462.94	289191.0
2022-01-10 09:00:00	SPY	ETF	462.95	463.26	462.45	462.7	252001.0
2022-01-10 09:30:00	SPY	ETF	462.7	463.02	459.01	459.36	10689670.0
2022-01-10 10:00:00	SPY	ETF	459.34	459.58	457.36	458.175	8936545.0
2022-01-10 10:30:00	SPY	ETF	458.15	458.73	456.5973	457.79	7371518.0
2022-01-10 11:00:00	SPY	ETF	457.77	460.175	457.08	460.06	6380591.0
2022-01-10 11:30:00	SPY	ETF	460.06	460.08	458.4284	459.48	4483559.0
2022-01-10 12:00:00	SPY	ETF	459.47	459.54	458.04	458.33	3358431.0
2022-01-10 12:30:00	SPY	ETF	458.34	460.18	457.95	459.23	4697534.0
2022-01-10 13:00:00	SPY	ETF	459.24	460.87	459.09	460.56	5017253.0
2022-01-10 13:30:00	SPY	ETF	460.5464	462.1762	460.16	461.88	4375203.0
2022-01-10 14:00:00	SPY	ETF	461.89	463.39	461.67	463.11	4551893.0
2022-01-10 14:30:00	SPY	ETF	463.12	463.87	462.12	462.96	4287161.0
2022-01-10 15:00:00	SPY	ETF	462.96	463.49	461.58	462.69	4875584.0
2022-01-10 15:30:00	SPY	ETF	462.68	465.74	462.23	465.54	13419454.0
2022-01-10 16:00:00	SPY	ETF	465.54	465.74	465.31	465.611	3937206.0
2022-01-10 16:30:00	SPY	ETF	465.64	465.78	465.28	465.51	149497.0
2022-01-10 17:00:00	SPY	ETF	465.51	465.7	465.37	465.7	61834.0
2022-01-10 17:30:00	SPY	ETF	465.67	465.89	465.6	465.66	49714.0
2022-01-10 18:00:00	SPY	ETF	465.68	466.14	465.31	466.05	109815.0
2022-01-10 18:30:00	SPY	ETF	465.51	466.05	465.51	465.83	12233.0
2022-01-10 19:00:00	SPY	ETF	465.83	466.16	465.1	465.18	54499.0
2022-01-10 19:30:00	SPY	ETF	465.11	466.02	465.02	465.98	61792.0
2022-01-10 04:00:00	QQQ	ETF	380.25	380.25	379.36	380.21	26947.0
2022-01-10 04:30:00	QQQ	ETF	380.14	380.14	379.75	379.77	25446.0
2022-01-10 05:00:00	QQQ	ETF	379.66	380.15	379.4	379.57	11185.0
2022-01-10 05:30:00	QQQ	ETF	379.5	379.62	378.69	378.74	8323.0
2022-01-10 06:00:00	QQQ	ETF	378.99	379.0	378.2	378.27	35429.0
2022-01-10 06:30:00	QQQ	ETF	378.4	378.75	377.81	378.58	54530.0
2022-01-10 07:00:00	QQQ	ETF	378.65	378.88	377.08	377.31	148644.0
2022-01-10 07:30:00	QQQ	ETF	377.271	377.28	374.63	374.64	495705.0
2022-01-10 08:00:00	QQQ	ETF	378.71	381.49	374.54	375.5	674315.0
2022-01-10 08:30:00	QQQ	ETF	375.44	375.83	374.8	375.08	371672.0
2022-01-10 09:00:00	QQQ	ETF	375.04	375.29	374.27	374.82	407061.0
2022-01-10 09:30:00	QQQ	ETF	374.82	375.71	371.47	371.9	11584231.0
2022-01-10 10:00:00	QQQ	ETF	371.88	372.21	370.34	371.2697	7632479.0
2022-01-10 10:30:00	QQQ	ETF	371.26	371.56	369.31	370.4001	5683522.0
2022-01-10 11:00:00	QQQ	ETF	370.39	373.64	369.92	373.47	5352193.0
2022-01-10 11:30:00	QQQ	ETF	373.48	373.49	371.7	372.9401	3489018.0
2022-01-10 12:00:00	QQQ	ETF	372.93	372.98	370.725	370.89	2957588.0
2022-01-10 12:30:00	QQQ	ETF	370.89	373.29	370.57	372.37	3747915.0

> showing 50 of 27,475 rows — these rows as CSV

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