PREVIEW / etf_30min / 2020-09-04

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-04.parquet
  size:    588 KB
  rows:    21,798

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-04 04:00:00	SPY	ETF	347.0	347.44	346.69	347.21	46549.0
2020-09-04 04:30:00	SPY	ETF	347.2	347.8	347.17	347.36	25563.0
2020-09-04 05:00:00	SPY	ETF	347.6	347.6	347.25	347.5	11350.0
2020-09-04 05:30:00	SPY	ETF	347.43	348.32	347.22	348.26	47814.0
2020-09-04 06:00:00	SPY	ETF	348.36	348.5	347.29	347.4	42919.0
2020-09-04 06:30:00	SPY	ETF	347.39	347.54	347.16	347.28	114546.0
2020-09-04 07:00:00	SPY	ETF	347.2	347.27	345.92	346.07	309066.0
2020-09-04 07:30:00	SPY	ETF	346.02	346.02	344.79	345.06	301156.0
2020-09-04 08:00:00	SPY	ETF	345.4901	348.3904	344.23	345.52	378540.0
2020-09-04 08:30:00	SPY	ETF	345.95	347.33	344.84	346.54	1065829.0
2020-09-04 09:00:00	SPY	ETF	346.49	347.37	345.87	346.11	622581.0
2020-09-04 09:30:00	SPY	ETF	346.13	347.83	343.05	343.56	13797049.0
2020-09-04 10:00:00	SPY	ETF	343.55	345.427	339.08	339.23	12738924.0
2020-09-04 10:30:00	SPY	ETF	339.24	340.126	334.87	338.42	16693886.0
2020-09-04 11:00:00	SPY	ETF	338.41	338.79	335.42	336.39	6941164.0
2020-09-04 11:30:00	SPY	ETF	336.4	339.55	336.27	339.21	7602178.0
2020-09-04 12:00:00	SPY	ETF	339.22	340.55	338.05	340.5	6102257.0
2020-09-04 12:30:00	SPY	ETF	340.49	341.6	340.06	340.91	6143277.0
2020-09-04 13:00:00	SPY	ETF	340.89	340.9	338.6	339.31	5023161.0
2020-09-04 13:30:00	SPY	ETF	339.31	340.58	338.46	340.355	5136523.0
2020-09-04 14:00:00	SPY	ETF	340.355	341.6099	339.69	341.5	4338398.0
2020-09-04 14:30:00	SPY	ETF	341.49	344.625	341.06	344.55	6401035.0
2020-09-04 15:00:00	SPY	ETF	344.56	345.4	343.31	345.0	7768226.0
2020-09-04 15:30:00	SPY	ETF	345.0	345.01	342.26	342.6	19639638.0
2020-09-04 16:00:00	SPY	ETF	342.59	343.5	341.1628	341.95	14031243.0
2020-09-04 16:30:00	SPY	ETF	341.95	342.57	341.55	341.55	365002.0
2020-09-04 17:00:00	SPY	ETF	341.64	342.4	341.64	342.34	274839.0
2020-09-04 17:30:00	SPY	ETF	342.35	342.52	342.2	342.45	111883.0
2020-09-04 18:00:00	SPY	ETF	342.45	342.51	342.4	342.46	50953.0
2020-09-04 18:30:00	SPY	ETF	342.45	342.46	342.29	342.31	17593.0
2020-09-04 19:00:00	SPY	ETF	342.29	342.3	342.05	342.2	14190.0
2020-09-04 19:30:00	SPY	ETF	342.15	342.15	341.86	342.0	20416.0
2020-09-04 04:00:00	QQQ	ETF	287.05	287.26	286.19	286.57	64044.0
2020-09-04 04:30:00	QQQ	ETF	286.47	287.57	286.47	287.12	42515.0
2020-09-04 05:00:00	QQQ	ETF	287.11	287.12	286.35	286.85	20131.0
2020-09-04 05:30:00	QQQ	ETF	286.64	287.73	286.55	287.6	58126.0
2020-09-04 06:00:00	QQQ	ETF	287.66	287.85	286.54	286.78	135091.0
2020-09-04 06:30:00	QQQ	ETF	286.73	287.0	286.6	286.63	13158.0
2020-09-04 07:00:00	QQQ	ETF	286.58	286.64	284.13	284.44	270218.0
2020-09-04 07:30:00	QQQ	ETF	284.51	284.54	283.34	284.0	326302.0
2020-09-04 08:00:00	QQQ	ETF	283.97	287.8496	283.4101	284.16	453631.0
2020-09-04 08:30:00	QQQ	ETF	284.65	286.36	283.43	285.15	995715.0
2020-09-04 09:00:00	QQQ	ETF	285.15	287.02	284.98	285.66	647640.0
2020-09-04 09:30:00	QQQ	ETF	285.76	288.93	280.51	281.58	13782916.0
2020-09-04 10:00:00	QQQ	ETF	281.52	283.25	276.92	277.07	12610931.0
2020-09-04 10:30:00	QQQ	ETF	277.08	277.86	271.8	276.89	15834033.0
2020-09-04 11:00:00	QQQ	ETF	276.86	277.25	274.12	275.36	6582207.0
2020-09-04 11:30:00	QQQ	ETF	275.36	280.46	275.21	280.275	7221245.0
2020-09-04 12:00:00	QQQ	ETF	280.28	281.31	278.28	281.25	4278784.0
2020-09-04 12:30:00	QQQ	ETF	281.2572	282.55	279.34	280.75	5747995.0

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

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