PREVIEW / etf_30min / 2021-03-09

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-09.parquet
  size:    641 KB
  rows:    24,535

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-03-09 04:00:00	SPY	ETF	385.17	385.68	385.0	385.42	40112.0
2021-03-09 04:30:00	SPY	ETF	385.52	386.0	385.4	385.65	47982.0
2021-03-09 05:00:00	SPY	ETF	385.65	385.95	385.39	385.51	46824.0
2021-03-09 05:30:00	SPY	ETF	385.45	385.8	385.15	385.49	17748.0
2021-03-09 06:00:00	SPY	ETF	385.4	386.01	385.4	386.01	73961.0
2021-03-09 06:30:00	SPY	ETF	386.05	386.31	385.86	386.05	73763.0
2021-03-09 07:00:00	SPY	ETF	386.0	386.01	385.38	385.43	158808.0
2021-03-09 07:30:00	SPY	ETF	385.55	385.61	384.85	385.03	128828.0
2021-03-09 08:00:00	SPY	ETF	385.02	386.0296	384.1	385.2	321670.0
2021-03-09 08:30:00	SPY	ETF	385.19	385.73	384.92	385.56	292518.0
2021-03-09 09:00:00	SPY	ETF	385.53	385.85	385.3	385.85	362984.0
2021-03-09 09:30:00	SPY	ETF	385.85	387.53	385.31	387.25	13801481.0
2021-03-09 10:00:00	SPY	ETF	387.2684	388.61	387.05	388.35	9536170.0
2021-03-09 10:30:00	SPY	ETF	388.34	388.72	388.02	388.425	4687434.0
2021-03-09 11:00:00	SPY	ETF	388.415	389.0	388.095	388.67	3651957.0
2021-03-09 11:30:00	SPY	ETF	388.67	388.96	388.38	388.919	2808673.0
2021-03-09 12:00:00	SPY	ETF	388.92	389.65	388.78	389.56	2706967.0
2021-03-09 12:30:00	SPY	ETF	389.54	389.75	388.82	389.0481	2513728.0
2021-03-09 13:00:00	SPY	ETF	389.05	389.84	389.05	389.4	3255065.0
2021-03-09 13:30:00	SPY	ETF	389.4	389.9	389.33	389.7605	2585383.0
2021-03-09 14:00:00	SPY	ETF	389.77	389.91	388.91	389.005	3295464.0
2021-03-09 14:30:00	SPY	ETF	389.0005	389.79	388.9586	389.06	3572983.0
2021-03-09 15:00:00	SPY	ETF	389.06	389.65	388.9601	389.01	5004808.0
2021-03-09 15:30:00	SPY	ETF	389.01	389.09	386.85	387.11	18901594.0
2021-03-09 16:00:00	SPY	ETF	387.11	387.37	386.75	386.91	7943362.0
2021-03-09 16:30:00	SPY	ETF	386.87	387.38	386.84	387.01	591962.0
2021-03-09 17:00:00	SPY	ETF	387.02	387.45	386.9	387.43	103645.0
2021-03-09 17:30:00	SPY	ETF	387.37	387.47	387.17	387.4	126368.0
2021-03-09 18:00:00	SPY	ETF	387.48	387.65	387.22	387.56	87716.0
2021-03-09 18:30:00	SPY	ETF	387.17	387.73	387.17	387.52	30547.0
2021-03-09 19:00:00	SPY	ETF	387.37	387.4	386.74	386.93	61784.0
2021-03-09 19:30:00	SPY	ETF	386.92	387.27	386.81	387.01	42113.0
2021-03-09 04:00:00	QQQ	ETF	303.98	305.91	303.98	305.75	95639.0
2021-03-09 04:30:00	QQQ	ETF	305.78	306.69	305.73	306.29	75962.0
2021-03-09 05:00:00	QQQ	ETF	306.22	306.42	305.55	305.75	316846.0
2021-03-09 05:30:00	QQQ	ETF	305.81	306.5	305.75	306.25	86906.0
2021-03-09 06:00:00	QQQ	ETF	306.18	307.08	306.17	307.04	199323.0
2021-03-09 06:30:00	QQQ	ETF	307.02	307.44	306.56	307.17	125877.0
2021-03-09 07:00:00	QQQ	ETF	307.1	307.1	305.91	306.2	364709.0
2021-03-09 07:30:00	QQQ	ETF	306.2	306.58	305.72	305.78	181824.0
2021-03-09 08:00:00	QQQ	ETF	306.6604	307.4004	301.93	306.5	568064.0
2021-03-09 08:30:00	QQQ	ETF	306.48	307.28	306.02	307.07	400637.0
2021-03-09 09:00:00	QQQ	ETF	307.07	307.61	306.7	307.45	406452.0
2021-03-09 09:30:00	QQQ	ETF	307.44	310.03	306.92	309.77	10948499.0
2021-03-09 10:00:00	QQQ	ETF	309.7799	311.309	309.48	310.87	6858424.0
2021-03-09 10:30:00	QQQ	ETF	310.87	311.08	309.4	309.775	5239529.0
2021-03-09 11:00:00	QQQ	ETF	309.77	310.88	309.255	310.73	3083266.0
2021-03-09 11:30:00	QQQ	ETF	310.72	311.13	310.2501	310.81	2751876.0
2021-03-09 12:00:00	QQQ	ETF	310.82	311.91	310.51	311.735	2268784.0
2021-03-09 12:30:00	QQQ	ETF	311.74	312.0	311.24	311.47	2313201.0

> showing 50 of 24,535 rows — these rows as CSV

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