PREVIEW / etf_30min / 2021-01-05

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-05.parquet
  size:    620 KB
  rows:    23,481

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-01-05 04:00:00	SPY	ETF	369.1	369.6	368.89	369.15	40789.0
2021-01-05 04:30:00	SPY	ETF	369.17	369.74	369.17	369.64	20114.0
2021-01-05 05:00:00	SPY	ETF	369.36	369.57	369.26	369.3	4330.0
2021-01-05 05:30:00	SPY	ETF	369.3	369.59	369.26	369.42	9634.0
2021-01-05 06:00:00	SPY	ETF	369.39	369.88	369.39	369.88	91178.0
2021-01-05 06:30:00	SPY	ETF	369.7	369.7	368.67	368.92	77639.0
2021-01-05 07:00:00	SPY	ETF	368.93	369.05	367.76	367.89	195004.0
2021-01-05 07:30:00	SPY	ETF	367.95	368.56	367.63	368.46	113219.0
2021-01-05 08:00:00	SPY	ETF	368.0601	369.51	367.59	367.69	339377.0
2021-01-05 08:30:00	SPY	ETF	367.75	368.79	366.97	367.0	475276.0
2021-01-05 09:00:00	SPY	ETF	367.01	368.18	366.84	368.09	435437.0
2021-01-05 09:30:00	SPY	ETF	368.1	370.745	368.05	370.1301	5682953.0
2021-01-05 10:00:00	SPY	ETF	370.16	370.92	369.28	369.7467	5492135.0
2021-01-05 10:30:00	SPY	ETF	369.75	369.93	368.43	368.815	6321778.0
2021-01-05 11:00:00	SPY	ETF	368.82	369.59	368.31	369.57	4471692.0
2021-01-05 11:30:00	SPY	ETF	369.5719	370.09	369.4901	369.75	2049755.0
2021-01-05 12:00:00	SPY	ETF	369.75	370.5319	369.66	369.8934	1875860.0
2021-01-05 12:30:00	SPY	ETF	369.8967	370.55	369.86	370.5	2462656.0
2021-01-05 13:00:00	SPY	ETF	370.51	370.63	370.33	370.3968	1705512.0
2021-01-05 13:30:00	SPY	ETF	370.393	370.885	370.36	370.87	1449997.0
2021-01-05 14:00:00	SPY	ETF	370.88	372.28	370.8789	372.1586	4244973.0
2021-01-05 14:30:00	SPY	ETF	372.1589	372.5	371.3601	371.44	2518293.0
2021-01-05 15:00:00	SPY	ETF	371.44	372.1	371.02	371.06	4873882.0
2021-01-05 15:30:00	SPY	ETF	371.07	372.22	370.86	371.32	10572661.0
2021-01-05 16:00:00	SPY	ETF	371.3	371.47	370.96	371.08	8291014.0
2021-01-05 16:30:00	SPY	ETF	371.08	371.53	371.03	371.2	206620.0
2021-01-05 17:00:00	SPY	ETF	371.39	371.4	371.07	371.26	161275.0
2021-01-05 17:30:00	SPY	ETF	371.28	371.34	371.14	371.23	162899.0
2021-01-05 18:00:00	SPY	ETF	371.23	371.48	370.81	371.0	115666.0
2021-01-05 18:30:00	SPY	ETF	370.98	371.23	370.65	370.92	41752.0
2021-01-05 19:00:00	SPY	ETF	371.04	372.13	371.04	371.92	99570.0
2021-01-05 19:30:00	SPY	ETF	371.99	372.89	370.81	371.41	235127.0
2021-01-05 04:00:00	QQQ	ETF	309.31	309.72	309.15	309.43	39690.0
2021-01-05 04:30:00	QQQ	ETF	309.43	309.9	309.43	309.61	4587.0
2021-01-05 05:00:00	QQQ	ETF	309.67	309.82	309.51	309.6	10634.0
2021-01-05 05:30:00	QQQ	ETF	309.58	309.78	309.55	309.64	11040.0
2021-01-05 06:00:00	QQQ	ETF	309.75	310.14	309.75	310.14	14223.0
2021-01-05 06:30:00	QQQ	ETF	310.01	310.01	309.0	309.35	33546.0
2021-01-05 07:00:00	QQQ	ETF	309.37	309.37	308.56	308.72	65741.0
2021-01-05 07:30:00	QQQ	ETF	308.7	309.15	308.45	309.05	102893.0
2021-01-05 08:00:00	QQQ	ETF	308.8101	309.45	307.77	307.97	217274.0
2021-01-05 08:30:00	QQQ	ETF	307.951	308.18	307.38	307.41	352500.0
2021-01-05 09:00:00	QQQ	ETF	307.37	308.41	307.3604	308.25	136366.0
2021-01-05 09:30:00	QQQ	ETF	308.29	311.1901	308.29	310.76	3529252.0
2021-01-05 10:00:00	QQQ	ETF	310.77	311.55	310.01	310.61	2113296.0
2021-01-05 10:30:00	QQQ	ETF	310.63	310.98	309.84	309.87	1383213.0
2021-01-05 11:00:00	QQQ	ETF	309.89	310.44	309.24	310.29	1639846.0
2021-01-05 11:30:00	QQQ	ETF	310.29	310.65	310.2	310.22	808093.0
2021-01-05 12:00:00	QQQ	ETF	310.28	310.55	309.59	309.805	1181022.0
2021-01-05 12:30:00	QQQ	ETF	309.84	310.3	309.65	310.24	1442795.0

> showing 50 of 23,481 rows — these rows as CSV

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