PREVIEW / etf_30min / 2020-03-10

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-10.parquet
  size:    620 KB
  rows:    22,752

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-03-10 04:00:00	SPY	ETF	281.96	283.8	281.24	283.5	128816.0
2020-03-10 04:30:00	SPY	ETF	283.6	286.04	283.37	285.9	125822.0
2020-03-10 05:00:00	SPY	ETF	285.9	286.88	285.1	286.4	108999.0
2020-03-10 05:30:00	SPY	ETF	286.34	288.33	286.3	287.91	183104.0
2020-03-10 06:00:00	SPY	ETF	287.96	288.24	287.01	287.26	361847.0
2020-03-10 06:30:00	SPY	ETF	287.2	288.45	286.91	287.86	319149.0
2020-03-10 07:00:00	SPY	ETF	287.85	288.01	286.11	286.2	628068.0
2020-03-10 07:30:00	SPY	ETF	286.17	286.9	285.6	286.0	446060.0
2020-03-10 08:00:00	SPY	ETF	285.96	287.8904	281.92	283.75	1619081.0
2020-03-10 08:30:00	SPY	ETF	283.66	285.36	282.33	284.5	1613536.0
2020-03-10 09:00:00	SPY	ETF	284.3	285.12	274.23	284.65	1918799.0
2020-03-10 09:30:00	SPY	ETF	284.64	285.18	280.91	282.64	21227258.0
2020-03-10 10:00:00	SPY	ETF	282.63	284.79	282.02	282.36	12525027.0
2020-03-10 10:30:00	SPY	ETF	282.33	282.41	278.565	278.6	17249738.0
2020-03-10 11:00:00	SPY	ETF	278.59	280.31	274.83	274.9	18756153.0
2020-03-10 11:30:00	SPY	ETF	274.905	277.59	273.5	275.46	23334229.0
2020-03-10 12:00:00	SPY	ETF	275.465	280.28	275.46	277.57	15261627.0
2020-03-10 12:30:00	SPY	ETF	277.58	279.26	275.71	278.36	16304158.0
2020-03-10 13:00:00	SPY	ETF	278.35	280.89	276.97	279.2794	13101672.0
2020-03-10 13:30:00	SPY	ETF	279.26	280.25	276.47	277.17	13418283.0
2020-03-10 14:00:00	SPY	ETF	277.1962	279.2	276.11	278.91	15262608.0
2020-03-10 14:30:00	SPY	ETF	278.88	283.69	278.58	282.49	17665863.0
2020-03-10 15:00:00	SPY	ETF	282.49	286.55	282.01	284.21	21623548.0
2020-03-10 15:30:00	SPY	ETF	284.2	288.52	283.22	288.44	40913959.0
2020-03-10 16:00:00	SPY	ETF	288.46	288.83	277.4	286.9	16315939.0
2020-03-10 16:30:00	SPY	ETF	286.94	288.12	286.41	288.07	1589952.0
2020-03-10 17:00:00	SPY	ETF	288.07	288.42	287.37	287.5	614640.0
2020-03-10 17:30:00	SPY	ETF	287.45	288.42	286.5	286.6999	358329.0
2020-03-10 18:00:00	SPY	ETF	286.58	288.42	284.48	285.31	633250.0
2020-03-10 18:30:00	SPY	ETF	285.21	285.91	283.65	284.2	326672.0
2020-03-10 19:00:00	SPY	ETF	284.15	284.9	283.45	283.55	212715.0
2020-03-10 19:30:00	SPY	ETF	283.63	283.92	281.65	283.14	364339.0
2020-03-10 04:00:00	QQQ	ETF	199.8	200.72	199.09	200.5	81214.0
2020-03-10 04:30:00	QQQ	ETF	200.42	202.16	200.42	202.13	75388.0
2020-03-10 05:00:00	QQQ	ETF	202.15	202.45	201.43	202.11	75158.0
2020-03-10 05:30:00	QQQ	ETF	202.19	203.28	202.15	203.1	68952.0
2020-03-10 06:00:00	QQQ	ETF	203.09	203.46	202.58	202.77	142300.0
2020-03-10 06:30:00	QQQ	ETF	202.74	203.66	202.6	203.3	221877.0
2020-03-10 07:00:00	QQQ	ETF	203.18	203.3	202.1	202.15	271844.0
2020-03-10 07:30:00	QQQ	ETF	202.17	202.5	201.54	201.84	228129.0
2020-03-10 08:00:00	QQQ	ETF	202.95	203.67	199.29	200.29	626032.0
2020-03-10 08:30:00	QQQ	ETF	200.27	201.4	199.45	200.83	1346626.0
2020-03-10 09:00:00	QQQ	ETF	200.8	201.2	200.4	201.18	1544067.0
2020-03-10 09:30:00	QQQ	ETF	201.12	201.23	198.65	199.94	8575544.0
2020-03-10 10:00:00	QQQ	ETF	199.92	201.5	199.5	200.04	4318582.0
2020-03-10 10:30:00	QQQ	ETF	200.02	200.16	197.36	197.39	4272903.0
2020-03-10 11:00:00	QQQ	ETF	197.37	198.68	194.74	194.91	5373382.0
2020-03-10 11:30:00	QQQ	ETF	194.95	196.66	193.6802	195.41	7203090.0
2020-03-10 12:00:00	QQQ	ETF	195.42	198.7	195.42	196.96	6045787.0
2020-03-10 12:30:00	QQQ	ETF	196.97	198.32	195.96	197.47	4163474.0

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

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