PREVIEW / etf_30min / 2020-03-17

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-17.parquet
  size:    635 KB
  rows:    23,328

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-03-17 04:00:00	SPY	ETF	246.97	256.45	246.97	250.3	373943.0
2020-03-17 04:30:00	SPY	ETF	250.16	250.74	244.69	245.02	507710.0
2020-03-17 05:00:00	SPY	ETF	245.1	246.73	242.02	242.5	222664.0
2020-03-17 05:30:00	SPY	ETF	242.29	243.63	239.14	241.66	249831.0
2020-03-17 06:00:00	SPY	ETF	241.86	246.97	241.0	246.61	211251.0
2020-03-17 06:30:00	SPY	ETF	246.6	250.02	244.2	250.0	409004.0
2020-03-17 07:00:00	SPY	ETF	250.02	250.02	244.69	245.07	534465.0
2020-03-17 07:30:00	SPY	ETF	245.01	245.26	242.38	242.62	457619.0
2020-03-17 08:00:00	SPY	ETF	242.68	252.26	241.71	244.8	1160531.0
2020-03-17 08:30:00	SPY	ETF	244.89	245.81	243.35	245.55	741124.0
2020-03-17 09:00:00	SPY	ETF	245.64	246.07	243.11	245.06	1383324.0
2020-03-17 09:30:00	SPY	ETF	245.04	247.45	237.67	238.16	29942079.0
2020-03-17 10:00:00	SPY	ETF	238.16	244.45	237.07	243.75	20508265.0
2020-03-17 10:30:00	SPY	ETF	243.76	245.83	241.62	245.22	17269804.0
2020-03-17 11:00:00	SPY	ETF	245.18	250.57	244.41	248.4812	16519337.0
2020-03-17 11:30:00	SPY	ETF	248.48	251.6	247.2	251.03	15243342.0
2020-03-17 12:00:00	SPY	ETF	251.045	256.17	250.34	250.51	19997884.0
2020-03-17 12:30:00	SPY	ETF	250.57	251.69	247.31	249.1	12834351.0
2020-03-17 13:00:00	SPY	ETF	249.12	250.385	245.05	246.86	12050152.0
2020-03-17 13:30:00	SPY	ETF	246.93	250.5999	246.09	249.6201	12193421.0
2020-03-17 14:00:00	SPY	ETF	249.56	253.7	248.21	252.68	12946316.0
2020-03-17 14:30:00	SPY	ETF	252.68	254.84	248.89	251.0075	13950329.0
2020-03-17 15:00:00	SPY	ETF	251.03	251.0643	247.0	248.05	14856058.0
2020-03-17 15:30:00	SPY	ETF	248.04	254.45	247.59	254.19	32706743.0
2020-03-17 16:00:00	SPY	ETF	254.34	254.75	249.5	250.01	8894175.0
2020-03-17 16:30:00	SPY	ETF	250.0	253.3751	249.03	249.03	7512556.0
2020-03-17 17:00:00	SPY	ETF	249.46	252.8	248.83	249.2	1755593.0
2020-03-17 17:30:00	SPY	ETF	249.2	252.8	239.1037	248.62	2289003.0
2020-03-17 18:00:00	SPY	ETF	248.51	252.8	239.1237	249.2	739773.0
2020-03-17 18:30:00	SPY	ETF	249.2	249.99	245.83	246.87	277551.0
2020-03-17 19:00:00	SPY	ETF	246.8	247.4	244.5	245.3	272829.0
2020-03-17 19:30:00	SPY	ETF	245.19	245.99	241.72	242.79	410267.0
2020-03-17 04:00:00	QQQ	ETF	178.06	180.89	177.8	177.83	61981.0
2020-03-17 04:30:00	QQQ	ETF	179.3	179.95	174.78	175.14	32529.0
2020-03-17 05:00:00	QQQ	ETF	175.0	176.45	173.0	173.33	52725.0
2020-03-17 05:30:00	QQQ	ETF	172.91	174.33	171.06	173.89	77053.0
2020-03-17 06:00:00	QQQ	ETF	173.32	177.7	173.32	177.2	83871.0
2020-03-17 06:30:00	QQQ	ETF	177.21	178.1	174.5	178.04	80941.0
2020-03-17 07:00:00	QQQ	ETF	178.04	178.53	175.5	175.66	192360.0
2020-03-17 07:30:00	QQQ	ETF	175.5	175.5	173.27	173.27	170407.0
2020-03-17 08:00:00	QQQ	ETF	173.56	178.07	172.81	174.87	271858.0
2020-03-17 08:30:00	QQQ	ETF	174.92	175.42	173.78	175.35	233206.0
2020-03-17 09:00:00	QQQ	ETF	175.33	175.72	173.82	175.29	389326.0
2020-03-17 09:30:00	QQQ	ETF	175.4	177.15	170.19	170.6	9385791.0
2020-03-17 10:00:00	QQQ	ETF	170.61	175.11	169.78	174.622	6805351.0
2020-03-17 10:30:00	QQQ	ETF	174.68	177.15	174.03	176.62	5647048.0
2020-03-17 11:00:00	QQQ	ETF	176.62	180.768	176.14	178.99	6786883.0
2020-03-17 11:30:00	QQQ	ETF	178.98	181.39	177.8	181.1	7552351.0
2020-03-17 12:00:00	QQQ	ETF	181.08	184.39	180.34	180.52	9980195.0
2020-03-17 12:30:00	QQQ	ETF	180.52	181.47	177.94	179.42	5474209.0

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

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