PREVIEW / etf_30min / 2022-01-19

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-19.parquet
  size:    684 KB
  rows:    27,226

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-19 04:00:00	SPY	ETF	456.0	456.25	455.5	455.5	25572.0
2022-01-19 04:30:00	SPY	ETF	455.53	457.36	455.53	457.27	22922.0
2022-01-19 05:00:00	SPY	ETF	457.21	457.3	456.93	456.99	13307.0
2022-01-19 05:30:00	SPY	ETF	457.09	457.54	456.92	457.54	47189.0
2022-01-19 06:00:00	SPY	ETF	457.55	457.95	456.86	456.86	40893.0
2022-01-19 06:30:00	SPY	ETF	456.85	457.7	456.73	457.58	23090.0
2022-01-19 07:00:00	SPY	ETF	457.75	457.9	457.349	457.45	201825.0
2022-01-19 07:30:00	SPY	ETF	457.41	457.96	457.1	457.76	193620.0
2022-01-19 08:00:00	SPY	ETF	457.8001	458.77	453.39	458.77	302038.0
2022-01-19 08:30:00	SPY	ETF	458.77	458.8	458.02	458.63	297075.0
2022-01-19 09:00:00	SPY	ETF	458.68	458.68	457.96	458.17	267699.0
2022-01-19 09:30:00	SPY	ETF	458.17	459.6124	457.74	459.48	8210115.0
2022-01-19 10:00:00	SPY	ETF	459.48	459.55	456.32	456.39	5475533.0
2022-01-19 10:30:00	SPY	ETF	456.395	456.73	455.471	456.282	6148168.0
2022-01-19 11:00:00	SPY	ETF	456.28	456.59	454.73	455.6305	5271876.0
2022-01-19 11:30:00	SPY	ETF	455.64	456.87	454.9	456.72	4443581.0
2022-01-19 12:00:00	SPY	ETF	456.73	458.186	456.7	458.09	4050875.0
2022-01-19 12:30:00	SPY	ETF	458.09	458.26	457.07	458.09	3090847.0
2022-01-19 13:00:00	SPY	ETF	458.11	458.1712	456.84	456.905	2543623.0
2022-01-19 13:30:00	SPY	ETF	456.9	457.28	456.09	456.43	3320770.0
2022-01-19 14:00:00	SPY	ETF	456.42	456.66	454.42	454.48	4566928.0
2022-01-19 14:30:00	SPY	ETF	454.46	455.91	454.25	455.3699	3723067.0
2022-01-19 15:00:00	SPY	ETF	455.38	456.11	454.45	454.55	4514182.0
2022-01-19 15:30:00	SPY	ETF	454.54	454.65	451.46	451.79	17226983.0
2022-01-19 16:00:00	SPY	ETF	451.79	452.32	451.11	451.4	4900004.0
2022-01-19 16:30:00	SPY	ETF	451.415	451.99	451.27	451.75	311741.0
2022-01-19 17:00:00	SPY	ETF	451.81	451.84	451.69	451.72	52757.0
2022-01-19 17:30:00	SPY	ETF	451.73	451.9	451.71	451.8	26479.0
2022-01-19 18:00:00	SPY	ETF	451.86	452.22	451.36	451.42	118739.0
2022-01-19 18:30:00	SPY	ETF	451.75	451.75	450.88	450.88	49875.0
2022-01-19 19:00:00	SPY	ETF	451.14	452.43	451.14	452.43	102714.0
2022-01-19 19:30:00	SPY	ETF	452.34	452.52	451.55	452.08	87221.0
2022-01-19 04:00:00	QQQ	ETF	370.24	370.7	369.95	369.96	77795.0
2022-01-19 04:30:00	QQQ	ETF	369.98	372.03	369.88	372.03	50967.0
2022-01-19 05:00:00	QQQ	ETF	371.98	371.98	371.27	371.37	36926.0
2022-01-19 05:30:00	QQQ	ETF	371.6	372.0	371.41	372.0	20094.0
2022-01-19 06:00:00	QQQ	ETF	372.14	372.31	371.21	371.21	36399.0
2022-01-19 06:30:00	QQQ	ETF	371.15	372.3	371.05	372.25	71163.0
2022-01-19 07:00:00	QQQ	ETF	372.16	372.31	371.49	371.74	69771.0
2022-01-19 07:30:00	QQQ	ETF	371.62	372.15	371.27	372.06	75436.0
2022-01-19 08:00:00	QQQ	ETF	372.19	373.47	367.01	373.37	345647.0
2022-01-19 08:30:00	QQQ	ETF	373.35	373.35	372.4	373.27	221537.0
2022-01-19 09:00:00	QQQ	ETF	373.27	373.27	371.96	372.16	314444.0
2022-01-19 09:30:00	QQQ	ETF	372.08	374.609	371.75	374.4396	7328833.0
2022-01-19 10:00:00	QQQ	ETF	374.42	374.69	372.43	372.5063	5805469.0
2022-01-19 10:30:00	QQQ	ETF	372.52	372.79	369.48	370.5339	5606620.0
2022-01-19 11:00:00	QQQ	ETF	370.51	371.16	368.16	369.27	5307348.0
2022-01-19 11:30:00	QQQ	ETF	369.26	370.583	368.35	370.38	3899185.0
2022-01-19 12:00:00	QQQ	ETF	370.35	372.85	370.32	372.76	4924515.0
2022-01-19 12:30:00	QQQ	ETF	372.79	373.33	372.05	373.19	3086763.0

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

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