PREVIEW / etf_1hour / 2020-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-18.parquet
  size:    364 KB
  rows:    12,344

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-18 04:00:00	SPY	ETF	334.51	335.16	334.33	334.79	129117.0
2020-09-18 05:00:00	SPY	ETF	334.76	335.51	334.64	334.87	32554.0
2020-09-18 06:00:00	SPY	ETF	334.85	335.18	334.72	335.01	24215.0
2020-09-18 07:00:00	SPY	ETF	335.05	335.73	334.94	335.09	127600.0
2020-09-18 08:00:00	SPY	ETF	335.34	335.82	334.36	335.82	262442.0
2020-09-18 09:00:00	SPY	ETF	335.79	336.15	333.05	333.91	10308974.0
2020-09-18 10:00:00	SPY	ETF	333.915	334.99	332.54	332.78	13519908.0
2020-09-18 11:00:00	SPY	ETF	332.77	333.36	331.86	333.0	13154787.0
2020-09-18 12:00:00	SPY	ETF	333.0	333.34	330.57	330.905	12327079.0
2020-09-18 13:00:00	SPY	ETF	330.89	331.115	327.97	329.96	15282885.0
2020-09-18 14:00:00	SPY	ETF	329.96	330.5401	329.091	330.53	8465577.0
2020-09-18 15:00:00	SPY	ETF	330.53	331.57	330.33	330.69	16573316.0
2020-09-18 16:00:00	SPY	ETF	330.68	334.1127	330.44	331.49	12335439.0
2020-09-18 17:00:00	SPY	ETF	331.46	331.5	330.65	331.4	1706412.0
2020-09-18 18:00:00	SPY	ETF	331.35	331.43	331.01	331.17	53949.0
2020-09-18 19:00:00	SPY	ETF	331.29	331.48	331.11	331.26	43458.0
2020-09-18 04:00:00	QQQ	ETF	270.95	271.67	270.63	271.25	48197.0
2020-09-18 05:00:00	QQQ	ETF	271.25	272.2	271.19	271.5	39413.0
2020-09-18 06:00:00	QQQ	ETF	271.4	271.9	271.28	271.46	29036.0
2020-09-18 07:00:00	QQQ	ETF	271.43	272.5	271.38	271.93	234882.0
2020-09-18 08:00:00	QQQ	ETF	271.88	272.4	270.31	272.07	453065.0
2020-09-18 09:00:00	QQQ	ETF	272.1002	272.66	269.23	270.18	6433716.0
2020-09-18 10:00:00	QQQ	ETF	270.2	271.35	267.47	267.8	7756615.0
2020-09-18 11:00:00	QQQ	ETF	267.8	268.23	266.21	267.68	8921378.0
2020-09-18 12:00:00	QQQ	ETF	267.62	268.22	264.51	265.18	8220035.0
2020-09-18 13:00:00	QQQ	ETF	265.16	265.63	262.63	265.12	10207830.0
2020-09-18 14:00:00	QQQ	ETF	265.12	266.26	264.43	266.194	6856069.0
2020-09-18 15:00:00	QQQ	ETF	266.205	267.41	265.94	266.76	8407523.0
2020-09-18 16:00:00	QQQ	ETF	266.76	271.9415	266.46	267.27	2194116.0
2020-09-18 17:00:00	QQQ	ETF	267.24	267.29	266.84	266.94	75725.0
2020-09-18 18:00:00	QQQ	ETF	266.87	266.99	266.87	266.95	164313.0
2020-09-18 19:00:00	QQQ	ETF	266.95	267.02	266.5	266.74	38362.0
2020-09-18 04:00:00	IWM	ETF	153.35	153.54	153.35	153.49	2154.0
2020-09-18 05:00:00	IWM	ETF	153.54	153.68	153.5	153.52	4930.0
2020-09-18 06:00:00	IWM	ETF	153.37	153.59	153.37	153.5	1701.0
2020-09-18 07:00:00	IWM	ETF	153.65	153.87	153.52	153.52	64958.0
2020-09-18 08:00:00	IWM	ETF	153.7416	153.88	153.48	153.79	34718.0
2020-09-18 09:00:00	IWM	ETF	153.819	154.71	153.66	153.955	2515103.0
2020-09-18 10:00:00	IWM	ETF	153.97	155.29	153.89	154.43	3477155.0
2020-09-18 11:00:00	IWM	ETF	154.43	154.82	153.53	153.81	2180467.0
2020-09-18 12:00:00	IWM	ETF	153.81	153.9	152.12	152.38	2030567.0
2020-09-18 13:00:00	IWM	ETF	152.39	152.71	151.14	152.195	2412075.0
2020-09-18 14:00:00	IWM	ETF	152.2	152.75	151.94	152.75	1931232.0
2020-09-18 15:00:00	IWM	ETF	152.74	153.355	152.66	153.27	4767744.0
2020-09-18 16:00:00	IWM	ETF	153.29	153.57	152.94	153.32	2519520.0
2020-09-18 17:00:00	IWM	ETF	153.22	153.46	153.22	153.29	845999.0
2020-09-18 18:00:00	IWM	ETF	153.36	153.6	153.36	153.43	659811.0
2020-09-18 19:00:00	IWM	ETF	153.43	153.47	153.32	153.45	5204.0
2020-09-18 04:00:00	DIA	ETF	278.96	279.44	278.96	279.16	21300.0
2020-09-18 05:00:00	DIA	ETF	279.03	279.03	278.79	278.79	800.0

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

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