PREVIEW / etf_1hour / 2020-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-07.parquet
  size:    388 KB
  rows:    13,385

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-07 04:00:00	SPY	ETF	270.75	272.26	270.48	270.75	244115.0
2020-04-07 05:00:00	SPY	ETF	270.78	272.2	270.71	271.77	192593.0
2020-04-07 06:00:00	SPY	ETF	271.81	274.64	271.62	274.02	895421.0
2020-04-07 07:00:00	SPY	ETF	274.02	274.07	271.92	272.04	1705407.0
2020-04-07 08:00:00	SPY	ETF	272.04	274.05	263.22	273.47	2775482.0
2020-04-07 09:00:00	SPY	ETF	273.47	275.03	271.83	273.75	31443866.0
2020-04-07 10:00:00	SPY	ETF	273.76	273.98	268.02	269.03	27906929.0
2020-04-07 11:00:00	SPY	ETF	269.015	272.54	268.3	271.4873	20596616.0
2020-04-07 12:00:00	SPY	ETF	271.5	273.92	271.44	272.65	18391511.0
2020-04-07 13:00:00	SPY	ETF	272.64	273.25	270.53	270.78	14428991.0
2020-04-07 14:00:00	SPY	ETF	270.78	270.91	266.15	266.71	22382959.0
2020-04-07 15:00:00	SPY	ETF	266.725	269.86	264.89	265.1	47636394.0
2020-04-07 16:00:00	SPY	ETF	265.1	274.39	263.65	263.82	9517978.0
2020-04-07 17:00:00	SPY	ETF	263.82	265.13	263.64	264.16	849893.0
2020-04-07 18:00:00	SPY	ETF	264.13	264.41	262.89	263.43	1255459.0
2020-04-07 19:00:00	SPY	ETF	263.43	266.04	263.29	265.22	982866.0
2020-04-07 20:00:00	SPY	ETF	265.19	265.19	265.14	265.14	700.0
2020-04-07 04:00:00	QQQ	ETF	200.18	201.18	199.91	200.17	216082.0
2020-04-07 05:00:00	QQQ	ETF	200.28	200.94	200.0	200.5	78718.0
2020-04-07 06:00:00	QQQ	ETF	200.51	202.56	200.51	202.32	193625.0
2020-04-07 07:00:00	QQQ	ETF	202.3	202.37	201.05	201.16	386644.0
2020-04-07 08:00:00	QQQ	ETF	201.13	202.31	194.5	202.14	711121.0
2020-04-07 09:00:00	QQQ	ETF	202.02	202.66	200.16	201.6181	9503877.0
2020-04-07 10:00:00	QQQ	ETF	201.61	201.79	196.98	197.74	12274970.0
2020-04-07 11:00:00	QQQ	ETF	197.72	200.08	197.11	199.5097	7089077.0
2020-04-07 12:00:00	QQQ	ETF	199.51	201.54	199.45	200.73	6128994.0
2020-04-07 13:00:00	QQQ	ETF	200.78	201.11	199.21	199.42	4038920.0
2020-04-07 14:00:00	QQQ	ETF	199.43	199.52	196.455	196.85	7558656.0
2020-04-07 15:00:00	QQQ	ETF	196.85	199.27	196.0	196.22	10796894.0
2020-04-07 16:00:00	QQQ	ETF	196.22	196.46	195.06	195.21	908300.0
2020-04-07 17:00:00	QQQ	ETF	195.3	195.6	195.24	195.6	28031.0
2020-04-07 18:00:00	QQQ	ETF	195.66	195.79	194.82	195.11	264217.0
2020-04-07 19:00:00	QQQ	ETF	195.2	196.87	195.08	196.32	151853.0
2020-04-07 04:00:00	IWM	ETF	115.21	116.0	115.17	115.28	15697.0
2020-04-07 05:00:00	IWM	ETF	115.38	115.6	115.3	115.41	8729.0
2020-04-07 06:00:00	IWM	ETF	115.59	116.68	115.59	116.26	100428.0
2020-04-07 07:00:00	IWM	ETF	116.21	116.27	115.4	115.4	156473.0
2020-04-07 08:00:00	IWM	ETF	116.23	116.48	111.25	116.37	664016.0
2020-04-07 09:00:00	IWM	ETF	116.3	118.63	115.87	118.49	8835170.0
2020-04-07 10:00:00	IWM	ETF	118.51	118.64	113.71	114.58	8303079.0
2020-04-07 11:00:00	IWM	ETF	114.57	116.61	114.29	115.735	4776361.0
2020-04-07 12:00:00	IWM	ETF	115.74	116.98	115.71	116.25	2879468.0
2020-04-07 13:00:00	IWM	ETF	116.27	116.47	114.65	115.07	4246823.0
2020-04-07 14:00:00	IWM	ETF	115.06	115.105	112.39	112.86	6767689.0
2020-04-07 15:00:00	IWM	ETF	112.865	114.15	112.39	112.95	9133668.0
2020-04-07 16:00:00	IWM	ETF	112.97	113.4	111.83	111.93	1800665.0
2020-04-07 17:00:00	IWM	ETF	112.0	112.15	111.9	112.02	49384.0
2020-04-07 18:00:00	IWM	ETF	112.06	112.92	111.57	111.76	55755.0
2020-04-07 19:00:00	IWM	ETF	111.73	112.92	111.72	112.6	39883.0
2020-04-07 04:00:00	DIA	ETF	233.45	233.45	229.9	232.15	20619.0

> showing 50 of 13,385 rows — these rows as CSV

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