PREVIEW / etf_30min / 2020-08-06

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-06.parquet
  size:    555 KB
  rows:    20,409

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-08-06 04:00:00	SPY	ETF	332.25	332.26	331.83	332.06	4358.0
2020-08-06 04:30:00	SPY	ETF	331.97	332.08	331.65	331.83	3022.0
2020-08-06 05:00:00	SPY	ETF	331.73	332.02	331.73	331.9	9658.0
2020-08-06 05:30:00	SPY	ETF	331.9	332.08	331.9	332.06	9077.0
2020-08-06 06:00:00	SPY	ETF	332.04	332.05	331.73	331.73	7268.0
2020-08-06 06:30:00	SPY	ETF	331.71	331.71	330.67	330.85	47097.0
2020-08-06 07:00:00	SPY	ETF	330.85	331.11	330.61	331.1	53204.0
2020-08-06 07:30:00	SPY	ETF	331.1	331.24	330.15	330.49	212597.0
2020-08-06 08:00:00	SPY	ETF	330.6699	331.9504	330.13	330.75	316023.0
2020-08-06 08:30:00	SPY	ETF	330.81	331.84	330.77	331.72	633856.0
2020-08-06 09:00:00	SPY	ETF	331.73	331.75	331.42	331.49	164100.0
2020-08-06 09:30:00	SPY	ETF	331.4799	332.32	331.39	332.28	4050172.0
2020-08-06 10:00:00	SPY	ETF	332.295	332.64	331.9602	332.46	2351467.0
2020-08-06 10:30:00	SPY	ETF	332.465	332.62	331.13	331.75	2744108.0
2020-08-06 11:00:00	SPY	ETF	331.75	332.0223	331.54	331.58	2028110.0
2020-08-06 11:30:00	SPY	ETF	331.57	332.2999	331.28	331.66	2202249.0
2020-08-06 12:00:00	SPY	ETF	331.655	332.205	331.59	332.07	2288435.0
2020-08-06 12:30:00	SPY	ETF	332.07	332.46	331.925	332.42	1756175.0
2020-08-06 13:00:00	SPY	ETF	332.425	332.55	332.27	332.48	1187835.0
2020-08-06 13:30:00	SPY	ETF	332.48	332.9	332.34	332.81	1425292.0
2020-08-06 14:00:00	SPY	ETF	332.815	333.7	332.77	333.635	2638779.0
2020-08-06 14:30:00	SPY	ETF	333.6301	334.15	333.615	333.995	2580377.0
2020-08-06 15:00:00	SPY	ETF	334.0	334.46	333.85	334.13	4774080.0
2020-08-06 15:30:00	SPY	ETF	334.14	334.36	333.66	334.31	8268917.0
2020-08-06 16:00:00	SPY	ETF	334.3	334.55	334.23	334.33	2180858.0
2020-08-06 16:30:00	SPY	ETF	334.39	334.55	334.3	334.4	233464.0
2020-08-06 17:00:00	SPY	ETF	334.46	334.46	334.24	334.33	56820.0
2020-08-06 17:30:00	SPY	ETF	334.3	334.4	334.29	334.34	21667.0
2020-08-06 18:00:00	SPY	ETF	334.37	334.44	334.11	334.26	94963.0
2020-08-06 18:30:00	SPY	ETF	334.29	334.35	334.23	334.26	19741.0
2020-08-06 19:00:00	SPY	ETF	334.22	334.27	334.18	334.24	15437.0
2020-08-06 19:30:00	SPY	ETF	334.26	334.29	334.1	334.16	20096.0
2020-08-06 04:00:00	QQQ	ETF	270.89	270.89	270.59	270.78	4800.0
2020-08-06 04:30:00	QQQ	ETF	270.75	270.75	270.47	270.58	5885.0
2020-08-06 05:00:00	QQQ	ETF	270.77	270.77	270.62	270.71	1500.0
2020-08-06 05:30:00	QQQ	ETF	270.74	270.79	270.54	270.67	7316.0
2020-08-06 06:00:00	QQQ	ETF	270.61	270.71	270.45	270.45	300.0
2020-08-06 06:30:00	QQQ	ETF	270.49	270.49	269.79	269.95	46301.0
2020-08-06 07:00:00	QQQ	ETF	269.95	270.26	269.83	270.25	37341.0
2020-08-06 07:30:00	QQQ	ETF	270.27	270.47	269.67	270.26	68580.0
2020-08-06 08:00:00	QQQ	ETF	270.27	271.05	269.7099	270.33	121376.0
2020-08-06 08:30:00	QQQ	ETF	270.37	271.13	270.34	270.98	302747.0
2020-08-06 09:00:00	QQQ	ETF	270.92	270.9399	270.58	270.83	228200.0
2020-08-06 09:30:00	QQQ	ETF	270.78	271.31	270.19	271.27	2321770.0
2020-08-06 10:00:00	QQQ	ETF	271.28	271.97	271.02	271.63	1401552.0
2020-08-06 10:30:00	QQQ	ETF	271.64	271.77	270.36	271.135	1390494.0
2020-08-06 11:00:00	QQQ	ETF	271.11	271.8	270.99	271.22	1290375.0
2020-08-06 11:30:00	QQQ	ETF	271.22	271.73	271.1144	271.46	1015751.0
2020-08-06 12:00:00	QQQ	ETF	271.44	272.31	271.3799	272.065	1098199.0
2020-08-06 12:30:00	QQQ	ETF	272.07	272.62	271.88	272.6	793791.0

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

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