PREVIEW / etf_30min / 2020-09-30

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-30.parquet
  size:    559 KB
  rows:    20,654

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
2020-09-30 04:00:00	SPY	ETF	330.55	331.01	330.35	330.51	53181.0
2020-09-30 04:30:00	SPY	ETF	330.62	330.92	330.4	330.74	22146.0
2020-09-30 05:00:00	SPY	ETF	330.81	330.81	329.6	329.6	38426.0
2020-09-30 05:30:00	SPY	ETF	329.74	330.81	329.71	330.8	38911.0
2020-09-30 06:00:00	SPY	ETF	330.71	331.09	330.0	331.0	41470.0
2020-09-30 06:30:00	SPY	ETF	331.04	332.49	331.04	331.77	88693.0
2020-09-30 07:00:00	SPY	ETF	331.75	332.0	331.48	331.84	143322.0
2020-09-30 07:30:00	SPY	ETF	331.85	331.88	331.21	331.32	172664.0
2020-09-30 08:00:00	SPY	ETF	331.7401	332.29	330.0	332.22	304913.0
2020-09-30 08:30:00	SPY	ETF	332.3	333.24	332.07	332.93	308631.0
2020-09-30 09:00:00	SPY	ETF	332.9	333.52	332.78	333.06	386262.0
2020-09-30 09:30:00	SPY	ETF	333.09	335.22	333.05	335.07	4881513.0
2020-09-30 10:00:00	SPY	ETF	335.06	336.3	335.01	335.91	4815097.0
2020-09-30 10:30:00	SPY	ETF	335.92	336.6	335.8	335.88	4521338.0
2020-09-30 11:00:00	SPY	ETF	335.875	337.12	335.665	336.84	4225212.0
2020-09-30 11:30:00	SPY	ETF	336.84	336.98	336.2	336.86	3490064.0
2020-09-30 12:00:00	SPY	ETF	336.81	337.51	336.78	337.42	2350894.0
2020-09-30 12:30:00	SPY	ETF	337.43	337.59	336.773	337.07	2304249.0
2020-09-30 13:00:00	SPY	ETF	337.08	337.16	336.22	336.65	2276140.0
2020-09-30 13:30:00	SPY	ETF	336.66	337.53	336.63	337.505	4929911.0
2020-09-30 14:00:00	SPY	ETF	337.52	338.29	335.61	336.65	7988737.0
2020-09-30 14:30:00	SPY	ETF	336.61	336.61	334.21	335.88	8079605.0
2020-09-30 15:00:00	SPY	ETF	335.885	336.18	332.88	334.2	9959317.0
2020-09-30 15:30:00	SPY	ETF	334.22	336.33	333.52	334.9	19635663.0
2020-09-30 16:00:00	SPY	ETF	334.9	337.35	333.38	333.94	15239603.0
2020-09-30 16:30:00	SPY	ETF	333.98	335.2	333.48	333.85	2601103.0
2020-09-30 17:00:00	SPY	ETF	333.86	334.89	333.8	334.21	515128.0
2020-09-30 17:30:00	SPY	ETF	334.22	334.89	334.17	334.36	243217.0
2020-09-30 18:00:00	SPY	ETF	334.4	335.57	334.4	335.4	271375.0
2020-09-30 18:30:00	SPY	ETF	335.36	335.75	335.03	335.69	60764.0
2020-09-30 19:00:00	SPY	ETF	335.71	336.0	335.67	335.78	108577.0
2020-09-30 19:30:00	SPY	ETF	335.71	336.11	335.7	336.1	210330.0
2020-09-30 04:00:00	QQQ	ETF	273.54	274.15	273.43	273.71	56787.0
2020-09-30 04:30:00	QQQ	ETF	273.99	274.21	273.7	274.02	33165.0
2020-09-30 05:00:00	QQQ	ETF	273.89	273.99	272.87	272.91	54149.0
2020-09-30 05:30:00	QQQ	ETF	272.92	274.09	272.84	274.07	43546.0
2020-09-30 06:00:00	QQQ	ETF	274.03	274.35	273.5	274.35	28319.0
2020-09-30 06:30:00	QQQ	ETF	274.33	275.54	274.33	275.0	106556.0
2020-09-30 07:00:00	QQQ	ETF	274.98	275.249	274.7	274.96	64470.0
2020-09-30 07:30:00	QQQ	ETF	275.14	275.17	274.57	274.68	44734.0
2020-09-30 08:00:00	QQQ	ETF	275.0501	275.35	272.77	275.35	190232.0
2020-09-30 08:30:00	QQQ	ETF	275.47	276.22	275.24	275.91	189066.0
2020-09-30 09:00:00	QQQ	ETF	275.9502	277.595	275.85	276.13	126500.0
2020-09-30 09:30:00	QQQ	ETF	276.1	278.5499	275.88	278.52	2999162.0
2020-09-30 10:00:00	QQQ	ETF	278.52	279.98	278.171	279.39	3215114.0
2020-09-30 10:30:00	QQQ	ETF	279.38	279.87	278.84	278.96	2091172.0
2020-09-30 11:00:00	QQQ	ETF	278.95	279.97	278.67	279.78	1693530.0
2020-09-30 11:30:00	QQQ	ETF	279.79	280.48	279.31	280.24	1917539.0
2020-09-30 12:00:00	QQQ	ETF	280.225	280.5	280.1	280.33	1514106.0
2020-09-30 12:30:00	QQQ	ETF	280.35	280.63	279.23	279.53	2067246.0

> showing 50 of 20,654 rows — these rows as CSV

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