PREVIEW / etf_30min / 2020-07-01

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-01.parquet
  size:    550 KB
  rows:    20,570

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-07-01 04:00:00	SPY	ETF	308.74	309.12	308.5	308.5	24774.0
2020-07-01 04:30:00	SPY	ETF	308.7	308.8	308.6	308.75	2589.0
2020-07-01 05:00:00	SPY	ETF	308.88	309.34	308.86	309.34	10976.0
2020-07-01 05:30:00	SPY	ETF	309.36	309.37	307.94	308.15	40462.0
2020-07-01 06:00:00	SPY	ETF	307.98	308.63	307.98	308.35	22567.0
2020-07-01 06:30:00	SPY	ETF	308.28	308.48	307.16	307.44	145714.0
2020-07-01 07:00:00	SPY	ETF	307.45	307.48	306.73	307.26	265361.0
2020-07-01 07:30:00	SPY	ETF	307.19	307.24	306.42	307.15	394595.0
2020-07-01 08:00:00	SPY	ETF	307.1	308.98	306.48	307.7498	486834.0
2020-07-01 08:30:00	SPY	ETF	307.72	309.58	307.66	309.55	1217400.0
2020-07-01 09:00:00	SPY	ETF	309.55	310.36	309.32	309.55	1535564.0
2020-07-01 09:30:00	SPY	ETF	309.57	310.92	309.3	309.81	8979750.0
2020-07-01 10:00:00	SPY	ETF	309.85	311.03	309.78	310.91	5288083.0
2020-07-01 10:30:00	SPY	ETF	310.92	311.26	309.76	310.6	5026450.0
2020-07-01 11:00:00	SPY	ETF	310.63	310.7	309.07	309.23	4149463.0
2020-07-01 11:30:00	SPY	ETF	309.22	310.45	309.18	310.26	3376104.0
2020-07-01 12:00:00	SPY	ETF	310.2501	311.115	310.11	310.985	2623320.0
2020-07-01 12:30:00	SPY	ETF	310.98	311.44	310.45	310.78	4968364.0
2020-07-01 13:00:00	SPY	ETF	310.79	310.94	310.295	310.81	2430761.0
2020-07-01 13:30:00	SPY	ETF	310.8058	311.07	310.31	310.74	2139369.0
2020-07-01 14:00:00	SPY	ETF	310.745	311.275	310.6699	310.92	2874669.0
2020-07-01 14:30:00	SPY	ETF	310.92	311.18	310.3	310.91	3838198.0
2020-07-01 15:00:00	SPY	ETF	310.91	311.7	310.77	311.5	3840747.0
2020-07-01 15:30:00	SPY	ETF	311.49	311.89	310.44	310.57	11922883.0
2020-07-01 16:00:00	SPY	ETF	310.58	311.658	310.16	310.25	4606803.0
2020-07-01 16:30:00	SPY	ETF	310.25	310.6	310.11	310.14	549537.0
2020-07-01 17:00:00	SPY	ETF	310.11	310.25	309.97	310.02	114267.0
2020-07-01 17:30:00	SPY	ETF	310.09	310.23	310.0	310.13	32704.0
2020-07-01 18:00:00	SPY	ETF	310.16	310.52	309.95	310.42	139171.0
2020-07-01 18:30:00	SPY	ETF	310.42	310.65	310.3	310.64	123059.0
2020-07-01 19:00:00	SPY	ETF	310.64	310.75	310.25	310.25	110396.0
2020-07-01 19:30:00	SPY	ETF	310.22	310.64	310.15	310.35	108220.0
2020-07-01 20:00:00	SPY	ETF	310.33	310.33	310.33	310.33	200.0
2020-07-01 04:00:00	QQQ	ETF	247.36	247.68	247.23	247.31	29285.0
2020-07-01 04:30:00	QQQ	ETF	247.31	247.36	247.22	247.22	3596.0
2020-07-01 05:00:00	QQQ	ETF	247.43	247.7	247.37	247.7	6320.0
2020-07-01 05:30:00	QQQ	ETF	247.63	247.63	246.77	246.96	9040.0
2020-07-01 06:00:00	QQQ	ETF	246.82	247.29	246.82	247.22	11751.0
2020-07-01 06:30:00	QQQ	ETF	247.0	247.0	246.33	246.54	35557.0
2020-07-01 07:00:00	QQQ	ETF	246.52	246.62	246.14	246.46	66152.0
2020-07-01 07:30:00	QQQ	ETF	246.39	246.39	245.92	246.15	84607.0
2020-07-01 08:00:00	QQQ	ETF	246.3199	247.55	245.97	246.85	133497.0
2020-07-01 08:30:00	QQQ	ETF	246.81	247.71	246.81	247.62	192135.0
2020-07-01 09:00:00	QQQ	ETF	247.7	247.9	247.44	247.61	312695.0
2020-07-01 09:30:00	QQQ	ETF	247.61	248.7	247.0802	247.62	4620960.0
2020-07-01 10:00:00	QQQ	ETF	247.65	249.08	247.46	249.03	2502994.0
2020-07-01 10:30:00	QQQ	ETF	249.05	249.46	248.72	249.2961	1737010.0
2020-07-01 11:00:00	QQQ	ETF	249.32	249.81	248.92	248.97	2435551.0
2020-07-01 11:30:00	QQQ	ETF	248.99	249.77	248.92	249.6	1905842.0
2020-07-01 12:00:00	QQQ	ETF	249.6	250.11	249.5	250.043	1104684.0

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

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