PREVIEW / etf_30min / 2021-12-16

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-16.parquet
  size:    662 KB
  rows:    25,895

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
2021-12-16 04:00:00	SPY	ETF	472.51	473.28	471.0	472.78	76499.0
2021-12-16 04:30:00	SPY	ETF	472.83	473.1	472.82	473.1	12587.0
2021-12-16 05:00:00	SPY	ETF	473.08	473.32	472.95	473.11	17464.0
2021-12-16 05:30:00	SPY	ETF	473.14	473.9	473.09	473.9	12677.0
2021-12-16 06:00:00	SPY	ETF	473.92	474.48	473.75	474.44	28918.0
2021-12-16 06:30:00	SPY	ETF	474.43	474.86	474.41	474.44	221252.0
2021-12-16 07:00:00	SPY	ETF	474.4	474.41	473.78	473.81	143636.0
2021-12-16 07:30:00	SPY	ETF	473.8	474.01	473.6	473.71	81589.0
2021-12-16 08:00:00	SPY	ETF	473.0396	474.8396	471.75	473.68	211761.0
2021-12-16 08:30:00	SPY	ETF	473.75	473.83	472.52	473.02	435001.0
2021-12-16 09:00:00	SPY	ETF	473.03	473.03	471.95	472.57	601539.0
2021-12-16 09:30:00	SPY	ETF	472.57	472.87	470.8	470.8301	7307545.0
2021-12-16 10:00:00	SPY	ETF	470.84	471.995	469.79	471.85	5782918.0
2021-12-16 10:30:00	SPY	ETF	471.86	472.29	471.2	471.57	4618236.0
2021-12-16 11:00:00	SPY	ETF	471.56	471.67	469.72	470.65	5049501.0
2021-12-16 11:30:00	SPY	ETF	470.64	470.74	469.35	469.43	3367393.0
2021-12-16 12:00:00	SPY	ETF	469.42	469.87	468.63	468.9	3600038.0
2021-12-16 12:30:00	SPY	ETF	468.91	469.18	467.6	467.65	2955360.0
2021-12-16 13:00:00	SPY	ETF	467.65	469.01	467.64	468.81	2668936.0
2021-12-16 13:30:00	SPY	ETF	468.805	469.22	468.08	468.2246	3194045.0
2021-12-16 14:00:00	SPY	ETF	468.24	468.61	466.58	466.875	4042759.0
2021-12-16 14:30:00	SPY	ETF	466.89	467.58	464.8	465.88	6204125.0
2021-12-16 15:00:00	SPY	ETF	465.9	467.39	464.9683	467.18	7690381.0
2021-12-16 15:30:00	SPY	ETF	467.17	468.33	466.19	466.43	15568156.0
2021-12-16 16:00:00	SPY	ETF	466.42	467.36	466.16	466.69	7764123.0
2021-12-16 16:30:00	SPY	ETF	466.69	467.16	466.45	467.12	173567.0
2021-12-16 17:00:00	SPY	ETF	467.07	467.15	466.71	466.8	176072.0
2021-12-16 17:30:00	SPY	ETF	466.82	466.91	466.76	466.91	27709.0
2021-12-16 18:00:00	SPY	ETF	466.92	467.02	465.89	465.89	351341.0
2021-12-16 18:30:00	SPY	ETF	466.45	466.51	465.89	466.39	67010.0
2021-12-16 19:00:00	SPY	ETF	466.44	466.89	466.44	466.58	34831.0
2021-12-16 19:30:00	SPY	ETF	466.62	467.1	466.62	466.96	46341.0
2021-12-16 04:00:00	QQQ	ETF	399.23	400.01	399.15	399.16	46603.0
2021-12-16 04:30:00	QQQ	ETF	399.22	399.58	399.19	399.5	9795.0
2021-12-16 05:00:00	QQQ	ETF	399.52	399.84	399.5	399.62	19163.0
2021-12-16 05:30:00	QQQ	ETF	399.7	400.28	399.63	400.25	19475.0
2021-12-16 06:00:00	QQQ	ETF	400.29	401.0	400.12	400.83	39359.0
2021-12-16 06:30:00	QQQ	ETF	400.94	401.24	400.73	400.83	47149.0
2021-12-16 07:00:00	QQQ	ETF	400.72	400.73	399.83	399.89	229616.0
2021-12-16 07:30:00	QQQ	ETF	399.87	400.08	399.54	399.65	105943.0
2021-12-16 08:00:00	QQQ	ETF	400.33	401.2696	398.39	399.25	481327.0
2021-12-16 08:30:00	QQQ	ETF	399.25	399.45	398.06	398.52	242177.0
2021-12-16 09:00:00	QQQ	ETF	398.54	398.54	397.57	398.06	460533.0
2021-12-16 09:30:00	QQQ	ETF	398.04	398.475	394.22	394.28	8444841.0
2021-12-16 10:00:00	QQQ	ETF	394.28	394.5	392.39	394.3971	6076021.0
2021-12-16 10:30:00	QQQ	ETF	394.39	394.91	392.79	393.19	3537907.0
2021-12-16 11:00:00	QQQ	ETF	393.17	393.35	390.36	391.63	4642232.0
2021-12-16 11:30:00	QQQ	ETF	391.63	391.72	389.51	389.72	3612320.0
2021-12-16 12:00:00	QQQ	ETF	389.68	390.18	388.61	388.899	3796626.0
2021-12-16 12:30:00	QQQ	ETF	388.88	389.56	387.8	387.86	3108355.0

> showing 50 of 25,895 rows — these rows as CSV

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