PREVIEW / etf_1hour / 2020-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-14.parquet
  size:    371 KB
  rows:    12,664

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-09-14 04:00:00	SPY	ETF	338.1	338.57	337.35	337.43	44485.0
2020-09-14 05:00:00	SPY	ETF	337.36	337.7	336.55	336.82	28692.0
2020-09-14 06:00:00	SPY	ETF	336.69	337.46	336.67	337.46	66287.0
2020-09-14 07:00:00	SPY	ETF	337.45	337.84	337.24	337.24	162589.0
2020-09-14 08:00:00	SPY	ETF	337.6	338.35	336.96	337.26	604653.0
2020-09-14 09:00:00	SPY	ETF	337.24	339.06	336.93	338.94	6092861.0
2020-09-14 10:00:00	SPY	ETF	338.945	340.38	338.76	339.69	7860196.0
2020-09-14 11:00:00	SPY	ETF	339.685	340.22	339.21	339.81	4955472.0
2020-09-14 12:00:00	SPY	ETF	339.78	340.075	339.25	339.58	4007691.0
2020-09-14 13:00:00	SPY	ETF	339.57	339.84	338.08	338.9	8765231.0
2020-09-14 14:00:00	SPY	ETF	338.9	339.39	337.9	338.68	5742106.0
2020-09-14 15:00:00	SPY	ETF	338.69	339.82	337.5499	338.42	17387258.0
2020-09-14 16:00:00	SPY	ETF	338.42	339.03	337.88	338.0	7463319.0
2020-09-14 17:00:00	SPY	ETF	338.02	338.46	337.99	338.19	161232.0
2020-09-14 18:00:00	SPY	ETF	338.17	338.86	338.1	338.83	182612.0
2020-09-14 19:00:00	SPY	ETF	338.83	338.85	338.26	338.65	82699.0
2020-09-14 04:00:00	QQQ	ETF	274.5	275.12	273.43	273.61	76097.0
2020-09-14 05:00:00	QQQ	ETF	273.64	273.93	272.87	273.26	30435.0
2020-09-14 06:00:00	QQQ	ETF	273.25	274.58	273.17	274.58	63632.0
2020-09-14 07:00:00	QQQ	ETF	274.49	274.53	273.39	273.4	184192.0
2020-09-14 08:00:00	QQQ	ETF	273.8701	274.72	272.826	273.43	220019.0
2020-09-14 09:00:00	QQQ	ETF	273.43	276.12	273.288	275.67	4439799.0
2020-09-14 10:00:00	QQQ	ETF	275.67	277.22	275.26	276.76	4200249.0
2020-09-14 11:00:00	QQQ	ETF	276.76	277.0	275.71	276.62	3475191.0
2020-09-14 12:00:00	QQQ	ETF	276.61	277.05	274.93	275.4	2997053.0
2020-09-14 13:00:00	QQQ	ETF	275.41	275.72	272.96	274.64	4192053.0
2020-09-14 14:00:00	QQQ	ETF	274.62	275.492	273.93	274.77	3452069.0
2020-09-14 15:00:00	QQQ	ETF	274.8	276.85	274.19	275.09	6564440.0
2020-09-14 16:00:00	QQQ	ETF	275.11	275.64	274.89	275.07	1004742.0
2020-09-14 17:00:00	QQQ	ETF	275.07	275.6	275.06	275.51	78787.0
2020-09-14 18:00:00	QQQ	ETF	275.41	276.07	275.32	276.05	116000.0
2020-09-14 19:00:00	QQQ	ETF	276.04	276.04	275.31	275.63	92193.0
2020-09-14 04:00:00	IWM	ETF	151.0	151.25	150.89	150.89	8889.0
2020-09-14 05:00:00	IWM	ETF	150.77	150.9	150.28	150.38	19169.0
2020-09-14 06:00:00	IWM	ETF	150.47	150.7	150.39	150.68	64680.0
2020-09-14 07:00:00	IWM	ETF	150.64	150.82	150.51	150.7	56734.0
2020-09-14 08:00:00	IWM	ETF	150.68	151.04	150.42	150.8	120436.0
2020-09-14 09:00:00	IWM	ETF	150.8	152.13	150.37	151.99	2116214.0
2020-09-14 10:00:00	IWM	ETF	151.99	152.21	151.57	151.73	1681283.0
2020-09-14 11:00:00	IWM	ETF	151.72	152.53	151.52	152.175	1629096.0
2020-09-14 12:00:00	IWM	ETF	152.16	152.98	152.12	152.87	1516926.0
2020-09-14 13:00:00	IWM	ETF	152.88	153.15	152.415	152.785	1303803.0
2020-09-14 14:00:00	IWM	ETF	152.77	153.18	152.53	152.99	1956203.0
2020-09-14 15:00:00	IWM	ETF	153.02	153.43	152.515	153.05	5039444.0
2020-09-14 16:00:00	IWM	ETF	153.04	153.4	152.87	152.92	1861851.0
2020-09-14 17:00:00	IWM	ETF	153.07	153.09	152.93	153.03	34245.0
2020-09-14 18:00:00	IWM	ETF	153.05	153.29	152.95	153.27	13505.0
2020-09-14 19:00:00	IWM	ETF	153.21	153.25	153.02	153.25	5257.0
2020-09-14 04:00:00	DIA	ETF	279.92	279.93	279.53	279.53	1625.0
2020-09-14 05:00:00	DIA	ETF	279.33	279.56	278.62	278.62	1000.0

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

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