PREVIEW / etf_30min / 2021-09-21

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-21.parquet
  size:    620 KB
  rows:    23,820

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-09-21 04:00:00	SPY	ETF	435.0	438.73	435.0	438.17	77592.0
2021-09-21 04:30:00	SPY	ETF	438.25	438.93	438.07	438.09	36227.0
2021-09-21 05:00:00	SPY	ETF	438.28	438.35	437.51	437.72	32045.0
2021-09-21 05:30:00	SPY	ETF	437.71	438.32	437.71	438.12	55557.0
2021-09-21 06:00:00	SPY	ETF	438.1	438.26	437.73	438.0	61540.0
2021-09-21 06:30:00	SPY	ETF	437.91	437.98	437.7	437.94	98896.0
2021-09-21 07:00:00	SPY	ETF	437.97	438.0	437.49	437.5	273130.0
2021-09-21 07:30:00	SPY	ETF	437.5	437.57	436.88	437.46	347758.0
2021-09-21 08:00:00	SPY	ETF	437.9001	438.43	436.13	436.9	679744.0
2021-09-21 08:30:00	SPY	ETF	436.9	437.72	436.32	436.38	698419.0
2021-09-21 09:00:00	SPY	ETF	436.38	436.78	436.03	436.54	759717.0
2021-09-21 09:30:00	SPY	ETF	436.53	437.91	435.5	436.39	9860663.0
2021-09-21 10:00:00	SPY	ETF	436.39	436.74	434.4	435.34	8135590.0
2021-09-21 10:30:00	SPY	ETF	435.34	435.47	433.07	433.75	6105611.0
2021-09-21 11:00:00	SPY	ETF	433.77	435.29	433.15	434.53	4724530.0
2021-09-21 11:30:00	SPY	ETF	434.54	436.23	434.54	435.865	3874819.0
2021-09-21 12:00:00	SPY	ETF	435.88	436.97	435.8	436.0501	4610260.0
2021-09-21 12:30:00	SPY	ETF	436.06	436.2894	434.93	435.395	3358903.0
2021-09-21 13:00:00	SPY	ETF	435.38	435.6	434.24	434.385	3475538.0
2021-09-21 13:30:00	SPY	ETF	434.38	434.97	433.78	434.2114	3060043.0
2021-09-21 14:00:00	SPY	ETF	434.22	434.825	433.545	433.66	3122556.0
2021-09-21 14:30:00	SPY	ETF	433.68	435.78	433.59	434.979	3394999.0
2021-09-21 15:00:00	SPY	ETF	434.98	436.05	434.98	435.71	4686430.0
2021-09-21 15:30:00	SPY	ETF	435.705	436.03	433.54	433.68	9974611.0
2021-09-21 16:00:00	SPY	ETF	433.68	433.84	432.4	432.8499	3688037.0
2021-09-21 16:30:00	SPY	ETF	432.85	433.63	432.76	433.06	403513.0
2021-09-21 17:00:00	SPY	ETF	433.06	433.34	433.06	433.18	70885.0
2021-09-21 17:30:00	SPY	ETF	433.19	433.19	433.05	433.15	52400.0
2021-09-21 18:00:00	SPY	ETF	433.11	433.35	432.8	432.9	57242.0
2021-09-21 18:30:00	SPY	ETF	433.63	433.63	432.8	432.82	18769.0
2021-09-21 19:00:00	SPY	ETF	432.85	433.05	432.64	432.88	26440.0
2021-09-21 19:30:00	SPY	ETF	432.88	433.01	432.5	432.56	33396.0
2021-09-21 04:00:00	QQQ	ETF	367.06	369.31	367.06	369.03	100651.0
2021-09-21 04:30:00	QQQ	ETF	369.03	369.51	368.94	368.94	31748.0
2021-09-21 05:00:00	QQQ	ETF	369.05	369.11	368.3	368.47	26018.0
2021-09-21 05:30:00	QQQ	ETF	368.43	368.84	368.43	368.63	8798.0
2021-09-21 06:00:00	QQQ	ETF	368.64	368.72	368.37	368.53	24251.0
2021-09-21 06:30:00	QQQ	ETF	368.55	368.68	368.33	368.65	18212.0
2021-09-21 07:00:00	QQQ	ETF	368.65	368.67	368.39	368.45	79470.0
2021-09-21 07:30:00	QQQ	ETF	368.47	368.6	368.1	368.55	57191.0
2021-09-21 08:00:00	QQQ	ETF	368.6301	368.9	367.57	368.11	441860.0
2021-09-21 08:30:00	QQQ	ETF	368.12	368.49	367.43	367.47	160324.0
2021-09-21 09:00:00	QQQ	ETF	367.61	367.74	367.11	367.64	489921.0
2021-09-21 09:30:00	QQQ	ETF	367.58	368.81	366.28	367.25	5317659.0
2021-09-21 10:00:00	QQQ	ETF	367.25	367.59	365.71	366.69	3903960.0
2021-09-21 10:30:00	QQQ	ETF	366.7101	366.9194	364.99	365.58	3359180.0
2021-09-21 11:00:00	QQQ	ETF	365.59	367.48	365.08	366.79	2748565.0
2021-09-21 11:30:00	QQQ	ETF	366.79	368.3	366.79	367.78	1926627.0
2021-09-21 12:00:00	QQQ	ETF	367.81	368.49	367.6601	367.68	1352367.0
2021-09-21 12:30:00	QQQ	ETF	367.68	367.92	366.6401	367.02	1165842.0

> showing 50 of 23,820 rows — these rows as CSV

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