PREVIEW / etf_1hour / 2020-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-20.parquet
  size:    382 KB
  rows:    12,985

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-04-20 04:00:00	SPY	ETF	285.84	285.84	284.57	285.15	104135.0
2020-04-20 05:00:00	SPY	ETF	285.3	285.39	283.83	283.83	178909.0
2020-04-20 06:00:00	SPY	ETF	284.03	284.05	282.44	282.85	481166.0
2020-04-20 07:00:00	SPY	ETF	282.85	283.34	281.25	281.53	1596625.0
2020-04-20 08:00:00	SPY	ETF	281.4	287.61	281.28	282.0	1331926.0
2020-04-20 09:00:00	SPY	ETF	281.95	283.99	281.61	283.35	10416624.0
2020-04-20 10:00:00	SPY	ETF	283.35	285.595	282.85	285.15	14907780.0
2020-04-20 11:00:00	SPY	ETF	285.14	286.7912	284.71	285.934	13220611.0
2020-04-20 12:00:00	SPY	ETF	285.93	286.01	285.136	285.4	7281139.0
2020-04-20 13:00:00	SPY	ETF	285.42	285.45	284.0965	284.8445	7921930.0
2020-04-20 14:00:00	SPY	ETF	284.82	285.13	281.656	281.72	14696965.0
2020-04-20 15:00:00	SPY	ETF	281.71	283.04	281.35	281.61	20837306.0
2020-04-20 16:00:00	SPY	ETF	281.61	284.3811	280.5	281.33	4024189.0
2020-04-20 17:00:00	SPY	ETF	281.31	281.63	281.27	281.35	600997.0
2020-04-20 18:00:00	SPY	ETF	281.35	282.86	281.05	282.57	389408.0
2020-04-20 19:00:00	SPY	ETF	282.63	282.98	281.51	282.03	393070.0
2020-04-20 04:00:00	QQQ	ETF	214.23	214.33	213.5	213.94	84969.0
2020-04-20 05:00:00	QQQ	ETF	213.97	214.18	213.41	213.41	18444.0
2020-04-20 06:00:00	QQQ	ETF	213.46	213.53	212.5	213.0	60287.0
2020-04-20 07:00:00	QQQ	ETF	212.98	213.3	212.32	212.7	211921.0
2020-04-20 08:00:00	QQQ	ETF	212.9096	215.52	212.4396	212.96	492576.0
2020-04-20 09:00:00	QQQ	ETF	212.86	214.42	212.6	213.34	5805773.0
2020-04-20 10:00:00	QQQ	ETF	213.34	215.44	213.13	215.2	5173073.0
2020-04-20 11:00:00	QQQ	ETF	215.2	215.88	214.86	215.605	4161733.0
2020-04-20 12:00:00	QQQ	ETF	215.6	215.66	215.02	215.3	2529089.0
2020-04-20 13:00:00	QQQ	ETF	215.31	215.34	214.3	215.22	3151785.0
2020-04-20 14:00:00	QQQ	ETF	215.23	215.4536	213.11	213.18	4622335.0
2020-04-20 15:00:00	QQQ	ETF	213.185	213.87	212.57	212.64	6546162.0
2020-04-20 16:00:00	QQQ	ETF	212.64	214.4526	212.05	212.66	1295160.0
2020-04-20 17:00:00	QQQ	ETF	212.74	212.75	212.14	212.55	472358.0
2020-04-20 18:00:00	QQQ	ETF	212.55	213.49	212.23	213.23	98359.0
2020-04-20 19:00:00	QQQ	ETF	213.37	213.6	212.79	213.09	67761.0
2020-04-20 04:00:00	IWM	ETF	121.45	121.45	121.07	121.21	19962.0
2020-04-20 05:00:00	IWM	ETF	121.4	121.4	120.95	120.95	7700.0
2020-04-20 06:00:00	IWM	ETF	120.68	120.68	119.74	119.74	64135.0
2020-04-20 07:00:00	IWM	ETF	119.74	120.03	118.82	118.91	236643.0
2020-04-20 08:00:00	IWM	ETF	119.5099	122.25	118.84	119.05	392078.0
2020-04-20 09:00:00	IWM	ETF	119.03	121.3186	118.96	120.8799	4842947.0
2020-04-20 10:00:00	IWM	ETF	120.88	122.5	120.54	122.16	4674189.0
2020-04-20 11:00:00	IWM	ETF	122.15	122.9	121.67	122.5	3007968.0
2020-04-20 12:00:00	IWM	ETF	122.5	122.77	122.15	122.28	2267903.0
2020-04-20 13:00:00	IWM	ETF	122.3	122.32	121.445	121.82	2251429.0
2020-04-20 14:00:00	IWM	ETF	121.82	121.98	119.47	119.52	5752626.0
2020-04-20 15:00:00	IWM	ETF	119.51	121.01	119.49	120.58	5770140.0
2020-04-20 16:00:00	IWM	ETF	120.58	120.85	120.16	120.67	2546816.0
2020-04-20 17:00:00	IWM	ETF	120.63	120.85	120.25	120.83	405206.0
2020-04-20 18:00:00	IWM	ETF	120.66	121.39	120.5	121.32	130861.0
2020-04-20 19:00:00	IWM	ETF	121.38	121.52	120.75	121.08	15300.0
2020-04-20 04:00:00	DIA	ETF	241.26	241.5	240.33	240.74	9475.0
2020-04-20 05:00:00	DIA	ETF	240.97	240.97	239.8	239.8	2504.0

> showing 50 of 12,985 rows — these rows as CSV

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