PREVIEW / etf_30min / 2021-10-04

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-04.parquet
  size:    639 KB
  rows:    24,826

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-10-04 04:00:00	SPY	ETF	432.99	432.99	432.06	432.06	30111.0
2021-10-04 04:30:00	SPY	ETF	432.02	432.68	431.49	432.68	36633.0
2021-10-04 05:00:00	SPY	ETF	432.59	433.03	432.56	432.8	25222.0
2021-10-04 05:30:00	SPY	ETF	432.84	433.12	432.36	432.63	58516.0
2021-10-04 06:00:00	SPY	ETF	432.72	433.04	432.3	432.59	16965.0
2021-10-04 06:30:00	SPY	ETF	432.57	432.8	432.13	432.77	35058.0
2021-10-04 07:00:00	SPY	ETF	432.78	432.88	431.84	432.25	118147.0
2021-10-04 07:30:00	SPY	ETF	432.31	432.39	431.87	432.29	112237.0
2021-10-04 08:00:00	SPY	ETF	432.25	434.565	431.28	432.71	172498.0
2021-10-04 08:30:00	SPY	ETF	432.73	433.67	432.4	433.37	218189.0
2021-10-04 09:00:00	SPY	ETF	433.36	433.38	432.9	433.02	299684.0
2021-10-04 09:30:00	SPY	ETF	433.0	433.96	432.16	432.68	7543073.0
2021-10-04 10:00:00	SPY	ETF	432.67	433.17	429.82	429.95	8308211.0
2021-10-04 10:30:00	SPY	ETF	429.95	429.95	427.07	428.03	10353968.0
2021-10-04 11:00:00	SPY	ETF	428.02	428.82	427.15	427.89	7229694.0
2021-10-04 11:30:00	SPY	ETF	427.89	428.67	426.36	428.4	8746252.0
2021-10-04 12:00:00	SPY	ETF	428.39	428.59	427.21	427.45	4321047.0
2021-10-04 12:30:00	SPY	ETF	427.46	427.9	426.65	427.24	4664987.0
2021-10-04 13:00:00	SPY	ETF	427.23	428.25	426.5	427.23	4890118.0
2021-10-04 13:30:00	SPY	ETF	427.22	428.06	427.17	427.335	3778346.0
2021-10-04 14:00:00	SPY	ETF	427.3424	428.55	427.23	427.7501	5688576.0
2021-10-04 14:30:00	SPY	ETF	427.75	428.58	427.3144	428.22	4845025.0
2021-10-04 15:00:00	SPY	ETF	428.23	429.22	427.32	427.635	5917143.0
2021-10-04 15:30:00	SPY	ETF	427.63	429.04	427.32	428.69	17198690.0
2021-10-04 16:00:00	SPY	ETF	428.69	429.13	428.5361	428.86	6600697.0
2021-10-04 16:30:00	SPY	ETF	428.86	429.0996	428.5	428.89	218296.0
2021-10-04 17:00:00	SPY	ETF	428.81	428.98	428.64	428.77	1871317.0
2021-10-04 17:30:00	SPY	ETF	428.77	428.95	428.77	428.93	69494.0
2021-10-04 18:00:00	SPY	ETF	428.96	429.24	428.86	429.15	127120.0
2021-10-04 18:30:00	SPY	ETF	428.64	429.45	428.64	429.36	38296.0
2021-10-04 19:00:00	SPY	ETF	429.41	429.46	428.93	429.06	14451.0
2021-10-04 19:30:00	SPY	ETF	428.93	429.13	428.6	428.79	50399.0
2021-10-04 04:00:00	QQQ	ETF	358.88	358.88	357.68	358.02	65650.0
2021-10-04 04:30:00	QQQ	ETF	357.91	358.21	357.46	358.21	16547.0
2021-10-04 05:00:00	QQQ	ETF	358.31	358.68	358.31	358.4	5980.0
2021-10-04 05:30:00	QQQ	ETF	358.4	358.8	358.17	358.25	16762.0
2021-10-04 06:00:00	QQQ	ETF	358.5	358.8	358.04	358.17	31007.0
2021-10-04 06:30:00	QQQ	ETF	358.36	358.46	357.94	358.46	20920.0
2021-10-04 07:00:00	QQQ	ETF	358.45	358.61	357.61	358.0	218092.0
2021-10-04 07:30:00	QQQ	ETF	358.03	358.16	357.72	358.07	116193.0
2021-10-04 08:00:00	QQQ	ETF	357.7801	360.45	357.04	358.51	95117.0
2021-10-04 08:30:00	QQQ	ETF	358.5	359.24	358.22	358.97	124250.0
2021-10-04 09:00:00	QQQ	ETF	358.95	358.95	358.34	358.5	123458.0
2021-10-04 09:30:00	QQQ	ETF	358.52	358.86	355.17	355.84	5823773.0
2021-10-04 10:00:00	QQQ	ETF	355.84	356.19	353.77	353.785	5339944.0
2021-10-04 10:30:00	QQQ	ETF	353.78	353.78	351.06	352.08	8256874.0
2021-10-04 11:00:00	QQQ	ETF	352.09	352.985	351.46	352.26	4923678.0
2021-10-04 11:30:00	QQQ	ETF	352.24	352.39	350.68	352.2	4570768.0
2021-10-04 12:00:00	QQQ	ETF	352.18	352.2901	350.92	351.169	2717585.0
2021-10-04 12:30:00	QQQ	ETF	351.17	351.63	350.44	351.015	3057027.0

> showing 50 of 24,826 rows — these rows as CSV

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