PREVIEW / etf_30min / 2022-11-03

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-03.parquet
  size:    685 KB
  rows:    27,417

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-11-03 04:00:00	SPY	ETF	375.05	375.77	374.3	374.39	67390.0
2022-11-03 04:30:00	SPY	ETF	374.56	374.68	373.98	374.6	35860.0
2022-11-03 05:00:00	SPY	ETF	374.6	375.0	374.21	374.69	50453.0
2022-11-03 05:30:00	SPY	ETF	374.69	374.77	373.76	374.26	17833.0
2022-11-03 06:00:00	SPY	ETF	374.62	374.62	373.0	373.0	58610.0
2022-11-03 06:30:00	SPY	ETF	373.07	373.18	372.44	372.95	55234.0
2022-11-03 07:00:00	SPY	ETF	372.94	372.98	372.38	372.5	104200.0
2022-11-03 07:30:00	SPY	ETF	372.5	372.8	371.83	372.19	297874.0
2022-11-03 08:00:00	SPY	ETF	372.76	376.35	371.84	372.19	348120.0
2022-11-03 08:30:00	SPY	ETF	372.1	372.47	371.08	371.14	684399.0
2022-11-03 09:00:00	SPY	ETF	371.2	371.82	370.98	371.46	333152.0
2022-11-03 09:30:00	SPY	ETF	371.465	372.25	369.04	369.17	8784318.0
2022-11-03 10:00:00	SPY	ETF	369.22	372.83	368.79	372.615	7522455.0
2022-11-03 10:30:00	SPY	ETF	372.63	373.59	371.1605	373.5	5542662.0
2022-11-03 11:00:00	SPY	ETF	373.49	373.69	371.71	371.7201	4463079.0
2022-11-03 11:30:00	SPY	ETF	371.73	372.775	371.02	371.721	3696901.0
2022-11-03 12:00:00	SPY	ETF	371.73	373.54	371.4	373.09	2704601.0
2022-11-03 12:30:00	SPY	ETF	373.08	374.2	372.33	373.8899	2828407.0
2022-11-03 13:00:00	SPY	ETF	373.87	374.0483	372.6301	372.9	2347607.0
2022-11-03 13:30:00	SPY	ETF	372.8899	373.14	372.245	372.2622	2234692.0
2022-11-03 14:00:00	SPY	ETF	372.27	373.465	371.87	373.3101	2636294.0
2022-11-03 14:30:00	SPY	ETF	373.325	373.67	372.61	373.5272	2658396.0
2022-11-03 15:00:00	SPY	ETF	373.5201	373.62	372.77	373.2	2791164.0
2022-11-03 15:30:00	SPY	ETF	373.21	373.5124	370.92	371.02	7857059.0
2022-11-03 16:00:00	SPY	ETF	371.01	371.49	370.9	371.24	4856963.0
2022-11-03 16:30:00	SPY	ETF	371.26	371.3	370.8	370.93	551282.0
2022-11-03 17:00:00	SPY	ETF	370.9501	371.01	370.7	370.72	685179.0
2022-11-03 17:30:00	SPY	ETF	370.74	370.75	370.5802	370.67	45158.0
2022-11-03 18:00:00	SPY	ETF	370.65	370.77	369.95	370.47	143264.0
2022-11-03 18:30:00	SPY	ETF	370.47	370.6	370.31	370.39	42567.0
2022-11-03 19:00:00	SPY	ETF	370.35	370.59	370.35	370.49	83506.0
2022-11-03 19:30:00	SPY	ETF	370.45	370.48	370.18	370.42	54665.0
2022-11-03 04:00:00	QQQ	ETF	266.0	266.32	265.17	265.3	108798.0
2022-11-03 04:30:00	QQQ	ETF	265.31	265.39	264.7	265.21	49316.0
2022-11-03 05:00:00	QQQ	ETF	265.26	265.58	264.86	265.47	34103.0
2022-11-03 05:30:00	QQQ	ETF	265.22	265.37	264.58	265.1	51306.0
2022-11-03 06:00:00	QQQ	ETF	265.1	265.28	263.86	263.93	141630.0
2022-11-03 06:30:00	QQQ	ETF	263.98	264.09	263.65	263.98	125411.0
2022-11-03 07:00:00	QQQ	ETF	263.97	264.04	263.3	263.33	167820.0
2022-11-03 07:30:00	QQQ	ETF	263.39	263.64	262.79	263.06	237529.0
2022-11-03 08:00:00	QQQ	ETF	263.69	266.89	262.84	263.07	589023.0
2022-11-03 08:30:00	QQQ	ETF	263.08	263.34	262.4	262.45	475768.0
2022-11-03 09:00:00	QQQ	ETF	262.55	265.68	262.31	263.01	685205.0
2022-11-03 09:30:00	QQQ	ETF	263.01	263.48	260.47	260.5479	7427178.0
2022-11-03 10:00:00	QQQ	ETF	260.57	263.5	260.1	263.4	6552595.0
2022-11-03 10:30:00	QQQ	ETF	263.405	264.35	261.88	264.0	5374549.0
2022-11-03 11:00:00	QQQ	ETF	263.99	264.5	261.81	261.84	3221144.0
2022-11-03 11:30:00	QQQ	ETF	261.81	262.69	261.25	261.587	2778219.0
2022-11-03 12:00:00	QQQ	ETF	261.57	263.05	261.22	262.6346	2829866.0
2022-11-03 12:30:00	QQQ	ETF	262.62	263.86	262.1	263.63	2647507.0

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

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