PREVIEW / etf_30min / 2020-09-14

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-14.parquet
  size:    552 KB
  rows:    20,457

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-14 04:00:00	SPY	ETF	338.1	338.57	337.84	337.84	28742.0
2020-09-14 04:30:00	SPY	ETF	337.81	337.81	337.35	337.43	15743.0
2020-09-14 05:00:00	SPY	ETF	337.36	337.7	337.3	337.7	9402.0
2020-09-14 05:30:00	SPY	ETF	337.7	337.7	336.55	336.82	19290.0
2020-09-14 06:00:00	SPY	ETF	336.69	337.12	336.67	336.79	14097.0
2020-09-14 06:30:00	SPY	ETF	336.7	337.46	336.7	337.46	52190.0
2020-09-14 07:00:00	SPY	ETF	337.45	337.84	337.26	337.74	102130.0
2020-09-14 07:30:00	SPY	ETF	337.7	337.78	337.24	337.24	60459.0
2020-09-14 08:00:00	SPY	ETF	337.6	338.35	336.96	337.13	156881.0
2020-09-14 08:30:00	SPY	ETF	337.12	337.56	337.05	337.26	447772.0
2020-09-14 09:00:00	SPY	ETF	337.24	337.66	337.18	337.48	439077.0
2020-09-14 09:30:00	SPY	ETF	337.49	339.06	336.93	338.94	5653784.0
2020-09-14 10:00:00	SPY	ETF	338.945	340.38	338.76	340.195	5045597.0
2020-09-14 10:30:00	SPY	ETF	340.19	340.2219	339.47	339.69	2814599.0
2020-09-14 11:00:00	SPY	ETF	339.685	339.94	339.21	339.77	2365489.0
2020-09-14 11:30:00	SPY	ETF	339.79	340.22	339.59	339.81	2589983.0
2020-09-14 12:00:00	SPY	ETF	339.78	340.075	339.41	339.73	2186336.0
2020-09-14 12:30:00	SPY	ETF	339.72	339.91	339.25	339.58	1821355.0
2020-09-14 13:00:00	SPY	ETF	339.57	339.84	338.21	338.76	3372356.0
2020-09-14 13:30:00	SPY	ETF	338.76	339.11	338.08	338.9	5392875.0
2020-09-14 14:00:00	SPY	ETF	338.9	339.39	338.51	338.84	2405463.0
2020-09-14 14:30:00	SPY	ETF	338.85	339.17	337.9	338.68	3336643.0
2020-09-14 15:00:00	SPY	ETF	338.69	338.87	337.5499	338.33	4399628.0
2020-09-14 15:30:00	SPY	ETF	338.34	339.82	338.0	338.42	12987630.0
2020-09-14 16:00:00	SPY	ETF	338.42	339.03	338.23	338.42	7237778.0
2020-09-14 16:30:00	SPY	ETF	338.42	338.46	337.88	338.0	225541.0
2020-09-14 17:00:00	SPY	ETF	338.02	338.15	337.99	338.15	38788.0
2020-09-14 17:30:00	SPY	ETF	338.14	338.46	338.13	338.19	122444.0
2020-09-14 18:00:00	SPY	ETF	338.17	338.74	338.1	338.71	149343.0
2020-09-14 18:30:00	SPY	ETF	338.68	338.86	338.61	338.83	33269.0
2020-09-14 19:00:00	SPY	ETF	338.83	338.85	338.46	338.46	39172.0
2020-09-14 19:30:00	SPY	ETF	338.46	338.65	338.26	338.65	43527.0
2020-09-14 04:00:00	QQQ	ETF	274.5	275.12	274.24	274.25	57284.0
2020-09-14 04:30:00	QQQ	ETF	274.11	274.16	273.43	273.61	18813.0
2020-09-14 05:00:00	QQQ	ETF	273.64	273.93	273.62	273.81	10574.0
2020-09-14 05:30:00	QQQ	ETF	273.79	273.84	272.87	273.26	19861.0
2020-09-14 06:00:00	QQQ	ETF	273.25	273.72	273.17	273.39	22316.0
2020-09-14 06:30:00	QQQ	ETF	273.49	274.58	273.43	274.58	41316.0
2020-09-14 07:00:00	QQQ	ETF	274.49	274.53	274.06	274.19	85539.0
2020-09-14 07:30:00	QQQ	ETF	274.04	274.08	273.39	273.4	98653.0
2020-09-14 08:00:00	QQQ	ETF	273.8701	274.72	272.826	273.42	115833.0
2020-09-14 08:30:00	QQQ	ETF	273.44	273.96	273.28	273.43	104186.0
2020-09-14 09:00:00	QQQ	ETF	273.43	274.53	273.288	274.31	168262.0
2020-09-14 09:30:00	QQQ	ETF	274.28	276.12	273.485	275.67	4271537.0
2020-09-14 10:00:00	QQQ	ETF	275.67	277.22	275.26	277.07	2337840.0
2020-09-14 10:30:00	QQQ	ETF	277.07	277.12	276.045	276.76	1862409.0
2020-09-14 11:00:00	QQQ	ETF	276.76	276.97	275.71	276.79	1944383.0
2020-09-14 11:30:00	QQQ	ETF	276.8	277.0	276.26	276.62	1530808.0
2020-09-14 12:00:00	QQQ	ETF	276.61	277.05	275.48	275.6301	1447512.0
2020-09-14 12:30:00	QQQ	ETF	275.67	275.9	274.93	275.4	1549541.0

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

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