PREVIEW / etf_30min / 2021-07-12

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-12.parquet
  size:    598 KB
  rows:    22,872

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-07-12 04:00:00	SPY	ETF	433.95	435.68	433.8	434.66	15778.0
2021-07-12 04:30:00	SPY	ETF	434.62	434.9	434.56	434.9	4843.0
2021-07-12 05:00:00	SPY	ETF	434.75	434.75	434.35	434.38	5991.0
2021-07-12 05:30:00	SPY	ETF	434.61	434.71	434.57	434.57	1549.0
2021-07-12 06:00:00	SPY	ETF	434.48	434.48	433.83	434.11	113007.0
2021-07-12 06:30:00	SPY	ETF	434.0	434.27	433.92	433.92	23647.0
2021-07-12 07:00:00	SPY	ETF	433.94	434.75	433.94	434.71	63617.0
2021-07-12 07:30:00	SPY	ETF	434.73	434.97	434.63	434.68	84970.0
2021-07-12 08:00:00	SPY	ETF	434.3201	435.01	434.06	434.97	162466.0
2021-07-12 08:30:00	SPY	ETF	434.98	435.4	434.92	435.38	81733.0
2021-07-12 09:00:00	SPY	ETF	435.43	435.49	435.23	435.42	181020.0
2021-07-12 09:30:00	SPY	ETF	435.42	435.935	434.97	435.93	4519103.0
2021-07-12 10:00:00	SPY	ETF	435.94	436.4599	435.6209	436.45	3185850.0
2021-07-12 10:30:00	SPY	ETF	436.46	436.74	436.39	436.62	2354717.0
2021-07-12 11:00:00	SPY	ETF	436.62	436.66	436.3	436.38	2059889.0
2021-07-12 11:30:00	SPY	ETF	436.39	436.6	436.07	436.59	1903341.0
2021-07-12 12:00:00	SPY	ETF	436.585	436.73	436.45	436.5	1511153.0
2021-07-12 12:30:00	SPY	ETF	436.49	436.63	436.38	436.53	1025146.0
2021-07-12 13:00:00	SPY	ETF	436.5311	436.685	436.4715	436.68	979340.0
2021-07-12 13:30:00	SPY	ETF	436.68	436.8	436.41	436.5699	1119237.0
2021-07-12 14:00:00	SPY	ETF	436.56	436.97	436.5201	436.96	2223348.0
2021-07-12 14:30:00	SPY	ETF	436.965	437.1	436.76	436.88	2114532.0
2021-07-12 15:00:00	SPY	ETF	436.87	437.2	436.75	437.18	3323181.0
2021-07-12 15:30:00	SPY	ETF	437.175	437.35	436.89	437.08	8664185.0
2021-07-12 16:00:00	SPY	ETF	437.08	437.5	437.04	437.18	4388476.0
2021-07-12 16:30:00	SPY	ETF	437.17	437.28	437.05	437.05	66415.0
2021-07-12 17:00:00	SPY	ETF	437.01	437.19	436.96	437.07	81222.0
2021-07-12 17:30:00	SPY	ETF	437.01	437.12	437.0	437.08	6671.0
2021-07-12 18:00:00	SPY	ETF	437.15	437.15	437.0	437.05	23283.0
2021-07-12 18:30:00	SPY	ETF	437.08	437.08	436.84	436.84	26310.0
2021-07-12 19:00:00	SPY	ETF	436.86	436.96	436.85	436.96	3748.0
2021-07-12 19:30:00	SPY	ETF	436.97	437.24	436.969	437.18	18077.0
2021-07-12 04:00:00	QQQ	ETF	358.77	361.44	358.77	361.44	15313.0
2021-07-12 04:30:00	QQQ	ETF	361.42	361.99	361.3	361.9	20407.0
2021-07-12 05:00:00	QQQ	ETF	361.77	362.0	361.57	361.61	26570.0
2021-07-12 05:30:00	QQQ	ETF	361.65	361.8	361.64	361.65	14983.0
2021-07-12 06:00:00	QQQ	ETF	361.68	361.72	361.08	361.5	21808.0
2021-07-12 06:30:00	QQQ	ETF	361.51	361.83	361.34	361.61	16218.0
2021-07-12 07:00:00	QQQ	ETF	361.58	361.91	361.57	361.85	38417.0
2021-07-12 07:30:00	QQQ	ETF	361.9	361.99	361.73	361.82	34782.0
2021-07-12 08:00:00	QQQ	ETF	361.76	362.42	360.8	362.35	71584.0
2021-07-12 08:30:00	QQQ	ETF	362.32	362.63	362.29	362.63	75548.0
2021-07-12 09:00:00	QQQ	ETF	362.63	362.73	362.45	362.45	79771.0
2021-07-12 09:30:00	QQQ	ETF	362.45	362.89	361.145	361.48	3936195.0
2021-07-12 10:00:00	QQQ	ETF	361.48	361.635	360.83	361.5236	2277734.0
2021-07-12 10:30:00	QQQ	ETF	361.53	362.03	361.1801	361.81	1469324.0
2021-07-12 11:00:00	QQQ	ETF	361.8	362.15	361.345	361.42	1150004.0
2021-07-12 11:30:00	QQQ	ETF	361.435	361.88	361.3598	361.7599	788320.0
2021-07-12 12:00:00	QQQ	ETF	361.76	361.945	361.51	361.8	710098.0
2021-07-12 12:30:00	QQQ	ETF	361.82	361.92	361.6	361.69	662240.0

> showing 50 of 22,872 rows — these rows as CSV

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