PREVIEW / etf_1hour / 2020-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-28.parquet
  size:    397 KB
  rows:    13,733

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-10-28 04:00:00	SPY	ETF	335.27	335.57	333.17	334.2	190022.0
2020-10-28 05:00:00	SPY	ETF	334.07	334.57	333.31	333.84	134972.0
2020-10-28 06:00:00	SPY	ETF	333.89	334.3	333.3	333.3	69880.0
2020-10-28 07:00:00	SPY	ETF	333.39	333.82	332.86	333.4	346987.0
2020-10-28 08:00:00	SPY	ETF	333.37	337.05	331.38	331.76	1227794.0
2020-10-28 09:00:00	SPY	ETF	331.75	332.84	330.91	331.299	12066273.0
2020-10-28 10:00:00	SPY	ETF	331.29	331.44	327.7212	328.57	20444931.0
2020-10-28 11:00:00	SPY	ETF	328.55	338.2483	327.58	329.6901	14512480.0
2020-10-28 12:00:00	SPY	ETF	329.67	330.34	327.85	328.41	10487035.0
2020-10-28 13:00:00	SPY	ETF	328.38	328.87	327.14	328.75	10123893.0
2020-10-28 14:00:00	SPY	ETF	328.75	329.18	327.37	328.78	12154089.0
2020-10-28 15:00:00	SPY	ETF	328.79	329.85	326.13	326.68	31460352.0
2020-10-28 16:00:00	SPY	ETF	326.68	328.3918	326.24	327.51	10319789.0
2020-10-28 17:00:00	SPY	ETF	327.54	327.65	326.66	327.53	312540.0
2020-10-28 18:00:00	SPY	ETF	327.53	328.22	327.53	328.17	287862.0
2020-10-28 19:00:00	SPY	ETF	328.17	328.27	327.32	328.22	217905.0
2020-10-28 04:00:00	QQQ	ETF	280.92	281.12	279.14	280.17	100237.0
2020-10-28 05:00:00	QQQ	ETF	280.07	280.27	279.56	279.83	76821.0
2020-10-28 06:00:00	QQQ	ETF	279.83	280.07	278.95	278.98	51299.0
2020-10-28 07:00:00	QQQ	ETF	279.05	279.9	279.05	279.13	173515.0
2020-10-28 08:00:00	QQQ	ETF	279.4301	282.0	277.69	278.06	349037.0
2020-10-28 09:00:00	QQQ	ETF	278.0	278.6401	274.88	275.78	5605916.0
2020-10-28 10:00:00	QQQ	ETF	275.78	275.89	273.33	274.22	7709917.0
2020-10-28 11:00:00	QQQ	ETF	274.2	274.76	273.16	274.3082	5614204.0
2020-10-28 12:00:00	QQQ	ETF	274.29	274.87	273.03	273.33	3735786.0
2020-10-28 13:00:00	QQQ	ETF	273.32	274.27	272.32	274.18	4119608.0
2020-10-28 14:00:00	QQQ	ETF	274.155	274.4	272.925	274.0599	3897418.0
2020-10-28 15:00:00	QQQ	ETF	274.0499	275.01	271.38	271.71	8321910.0
2020-10-28 16:00:00	QQQ	ETF	271.69	273.8979	271.57	272.66	2114380.0
2020-10-28 17:00:00	QQQ	ETF	272.6	273.0	272.53	272.85	119542.0
2020-10-28 18:00:00	QQQ	ETF	272.88	273.24	272.47	273.14	173523.0
2020-10-28 19:00:00	QQQ	ETF	273.1	273.23	272.44	273.0	86621.0
2020-10-28 04:00:00	IWM	ETF	156.0	156.0	154.98	155.33	40954.0
2020-10-28 05:00:00	IWM	ETF	155.37	155.65	155.0	155.2	25318.0
2020-10-28 06:00:00	IWM	ETF	155.2	155.6	155.16	155.2	29206.0
2020-10-28 07:00:00	IWM	ETF	155.21	155.5	154.88	155.35	85833.0
2020-10-28 08:00:00	IWM	ETF	154.93	155.72	154.36	154.65	274889.0
2020-10-28 09:00:00	IWM	ETF	154.6	155.44	154.05	154.38	5448391.0
2020-10-28 10:00:00	IWM	ETF	154.39	154.49	153.32	153.68	5046057.0
2020-10-28 11:00:00	IWM	ETF	153.665	154.67	153.37	154.46	3174569.0
2020-10-28 12:00:00	IWM	ETF	154.45	154.91	153.45	153.81	2460800.0
2020-10-28 13:00:00	IWM	ETF	153.8	154.12	153.045	154.07	2125797.0
2020-10-28 14:00:00	IWM	ETF	154.06	154.16	153.26	153.99	2051654.0
2020-10-28 15:00:00	IWM	ETF	154.01	154.35	153.12	153.32	4745065.0
2020-10-28 16:00:00	IWM	ETF	153.31	153.8121	153.02	153.61	1173466.0
2020-10-28 17:00:00	IWM	ETF	153.35	153.57	153.31	153.57	56731.0
2020-10-28 18:00:00	IWM	ETF	153.58	153.9	153.57	153.81	63020.0
2020-10-28 19:00:00	IWM	ETF	153.93	153.94	153.46	153.91	19378.0
2020-10-28 04:00:00	DIA	ETF	270.9	270.9	269.84	270.44	3395.0
2020-10-28 05:00:00	DIA	ETF	270.34	270.72	270.2	270.2	5800.0

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

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