PREVIEW / etf_30min / 2020-10-02

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-02.parquet
  size:    567 KB
  rows:    21,044

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-10-02 04:00:00	SPY	ETF	332.89	333.25	332.16	333.22	62615.0
2020-10-02 04:30:00	SPY	ETF	332.62	333.1	332.53	332.85	23845.0
2020-10-02 05:00:00	SPY	ETF	332.83	333.44	332.2	332.23	42332.0
2020-10-02 05:30:00	SPY	ETF	332.3	332.34	331.05	331.34	148009.0
2020-10-02 06:00:00	SPY	ETF	331.3	331.58	330.47	331.39	345650.0
2020-10-02 06:30:00	SPY	ETF	331.43	332.32	331.29	332.17	237281.0
2020-10-02 07:00:00	SPY	ETF	332.15	332.52	331.36	331.55	717225.0
2020-10-02 07:30:00	SPY	ETF	331.57	331.97	331.13	331.36	339874.0
2020-10-02 08:00:00	SPY	ETF	331.38	336.4	330.67	332.6	937290.0
2020-10-02 08:30:00	SPY	ETF	332.59	332.64	330.89	331.5	766361.0
2020-10-02 09:00:00	SPY	ETF	331.54	331.82	330.62	331.65	798703.0
2020-10-02 09:30:00	SPY	ETF	331.7	334.38	331.19	334.03	10972622.0
2020-10-02 10:00:00	SPY	ETF	334.05	335.35	333.94	335.0	5973329.0
2020-10-02 10:30:00	SPY	ETF	335.01	335.1	333.62	334.52	3859493.0
2020-10-02 11:00:00	SPY	ETF	334.52	335.33	333.96	334.78	3332441.0
2020-10-02 11:30:00	SPY	ETF	334.77	334.82	332.69	332.79	4617101.0
2020-10-02 12:00:00	SPY	ETF	332.79	335.92	331.95	335.095	10806425.0
2020-10-02 12:30:00	SPY	ETF	335.1	335.9	334.75	335.42	3813769.0
2020-10-02 13:00:00	SPY	ETF	335.415	337.0126	334.83	335.61	2976453.0
2020-10-02 13:30:00	SPY	ETF	335.6	335.73	333.84	334.5	5496120.0
2020-10-02 14:00:00	SPY	ETF	334.5	337.0126	334.455	335.31	2741026.0
2020-10-02 14:30:00	SPY	ETF	335.32	335.6	334.61	335.205	5392320.0
2020-10-02 15:00:00	SPY	ETF	335.2299	335.58	334.08	334.965	5615029.0
2020-10-02 15:30:00	SPY	ETF	334.96	335.565	333.66	333.87	11079982.0
2020-10-02 16:00:00	SPY	ETF	333.88	334.7	333.57	334.36	4875411.0
2020-10-02 16:30:00	SPY	ETF	334.35	334.84	334.15	334.6	290234.0
2020-10-02 17:00:00	SPY	ETF	334.55	334.55	333.11	333.3	547116.0
2020-10-02 17:30:00	SPY	ETF	333.3	333.39	332.55	332.97	268247.0
2020-10-02 18:00:00	SPY	ETF	333.0	333.25	332.42	332.65	90345.0
2020-10-02 18:30:00	SPY	ETF	332.69	332.8	332.06	332.41	68839.0
2020-10-02 19:00:00	SPY	ETF	332.35	332.59	332.16	332.4	42854.0
2020-10-02 19:30:00	SPY	ETF	332.42	332.75	332.28	332.64	55767.0
2020-10-02 04:00:00	QQQ	ETF	277.9	278.15	277.12	278.06	109451.0
2020-10-02 04:30:00	QQQ	ETF	278.02	278.03	277.47	277.66	24525.0
2020-10-02 05:00:00	QQQ	ETF	277.61	277.97	276.52	276.56	36511.0
2020-10-02 05:30:00	QQQ	ETF	276.54	276.73	275.64	276.18	85944.0
2020-10-02 06:00:00	QQQ	ETF	276.2	276.79	275.45	276.5	108612.0
2020-10-02 06:30:00	QQQ	ETF	276.47	277.19	276.35	277.13	114638.0
2020-10-02 07:00:00	QQQ	ETF	276.99	277.29	275.89	276.0	226593.0
2020-10-02 07:30:00	QQQ	ETF	275.95	276.33	275.2	275.37	215729.0
2020-10-02 08:00:00	QQQ	ETF	275.34	282.03	275.25	276.98	540814.0
2020-10-02 08:30:00	QQQ	ETF	276.84	276.99	275.63	276.1	374027.0
2020-10-02 09:00:00	QQQ	ETF	276.08	278.88	275.19	276.07	701388.0
2020-10-02 09:30:00	QQQ	ETF	276.05	278.84	275.66	278.32	6056201.0
2020-10-02 10:00:00	QQQ	ETF	278.31	279.7798	278.21	279.72	2966404.0
2020-10-02 10:30:00	QQQ	ETF	279.6999	279.6999	277.75	278.66	2617691.0
2020-10-02 11:00:00	QQQ	ETF	278.63	278.73	277.45	277.47	2776078.0
2020-10-02 11:30:00	QQQ	ETF	277.47	277.49	274.855	275.0099	5208896.0
2020-10-02 12:00:00	QQQ	ETF	275.02	277.0	273.44	276.43	7412540.0
2020-10-02 12:30:00	QQQ	ETF	276.41	276.89	275.6	276.112	3762633.0

> showing 50 of 21,044 rows — these rows as CSV

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