PREVIEW / etf_1hour / 2020-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-21.parquet
  size:    360 KB
  rows:    12,231

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-08-21 04:00:00	SPY	ETF	338.35	338.35	337.65	337.85	29585.0
2020-08-21 05:00:00	SPY	ETF	337.81	338.32	337.69	338.27	13443.0
2020-08-21 06:00:00	SPY	ETF	338.27	338.31	337.35	337.56	65207.0
2020-08-21 07:00:00	SPY	ETF	337.57	337.69	336.24	336.3	565785.0
2020-08-21 08:00:00	SPY	ETF	336.3	338.94	335.75	336.86	1001121.0
2020-08-21 09:00:00	SPY	ETF	336.85	338.67	336.57	338.62	6865207.0
2020-08-21 10:00:00	SPY	ETF	338.635	338.94	337.93	338.6318	6337585.0
2020-08-21 11:00:00	SPY	ETF	338.61	338.69	337.9	337.97	6947164.0
2020-08-21 12:00:00	SPY	ETF	337.965	338.79	337.92	338.57	2926583.0
2020-08-21 13:00:00	SPY	ETF	338.57	338.96	338.33	338.845	4532397.0
2020-08-21 14:00:00	SPY	ETF	338.8485	339.46	338.68	339.345	3990464.0
2020-08-21 15:00:00	SPY	ETF	339.34	339.72	339.12	339.44	11885261.0
2020-08-21 16:00:00	SPY	ETF	339.43	339.66	339.238	339.33	8437821.0
2020-08-21 17:00:00	SPY	ETF	339.28	339.66	339.06	339.58	406539.0
2020-08-21 18:00:00	SPY	ETF	339.57	339.68	339.56	339.61	17604.0
2020-08-21 19:00:00	SPY	ETF	339.62	339.67	339.5	339.65	17818.0
2020-08-21 04:00:00	QQQ	ETF	280.23	280.23	279.65	279.72	43979.0
2020-08-21 05:00:00	QQQ	ETF	279.99	280.39	279.97	280.29	20055.0
2020-08-21 06:00:00	QQQ	ETF	280.26	280.32	279.21	279.62	67283.0
2020-08-21 07:00:00	QQQ	ETF	279.64	279.88	278.79	278.88	381379.0
2020-08-21 08:00:00	QQQ	ETF	278.85	280.7	278.27	279.65	426702.0
2020-08-21 09:00:00	QQQ	ETF	279.62	280.65	279.31	280.43	4687391.0
2020-08-21 10:00:00	QQQ	ETF	280.4334	281.97	279.76	281.675	4486845.0
2020-08-21 11:00:00	QQQ	ETF	281.67	281.755	280.22	280.35	3081475.0
2020-08-21 12:00:00	QQQ	ETF	280.34	281.6	280.22	281.5	1926198.0
2020-08-21 13:00:00	QQQ	ETF	281.5	281.59	280.9	281.15	1805447.0
2020-08-21 14:00:00	QQQ	ETF	281.15	282.025	281.05	281.8888	2333722.0
2020-08-21 15:00:00	QQQ	ETF	281.88	282.34	281.2801	281.85	4207808.0
2020-08-21 16:00:00	QQQ	ETF	281.86	282.24	281.8	282.12	1099924.0
2020-08-21 17:00:00	QQQ	ETF	282.12	282.32	281.87	282.25	1225145.0
2020-08-21 18:00:00	QQQ	ETF	282.16	282.36	282.11	282.25	14941.0
2020-08-21 19:00:00	QQQ	ETF	282.28	282.3	282.06	282.3	367840.0
2020-08-21 04:00:00	IWM	ETF	155.65	155.65	155.15	155.36	8300.0
2020-08-21 05:00:00	IWM	ETF	155.26	155.66	155.26	155.58	6950.0
2020-08-21 06:00:00	IWM	ETF	155.5	155.62	155.12	155.14	4600.0
2020-08-21 07:00:00	IWM	ETF	155.17	155.22	154.29	154.29	58691.0
2020-08-21 08:00:00	IWM	ETF	155.18	155.87	154.04	154.57	84332.0
2020-08-21 09:00:00	IWM	ETF	154.58	155.66	154.35	155.18	2493166.0
2020-08-21 10:00:00	IWM	ETF	155.2	155.32	154.0	154.47	2265684.0
2020-08-21 11:00:00	IWM	ETF	154.45	154.66	154.03	154.43	1261983.0
2020-08-21 12:00:00	IWM	ETF	154.44	154.94	153.74	153.75	1542967.0
2020-08-21 13:00:00	IWM	ETF	153.75	154.395	153.6	154.27	1546863.0
2020-08-21 14:00:00	IWM	ETF	154.265	154.55	154.1901	154.255	993919.0
2020-08-21 15:00:00	IWM	ETF	154.255	154.64	154.11	154.59	2407064.0
2020-08-21 16:00:00	IWM	ETF	154.61	154.7545	154.28	154.32	952371.0
2020-08-21 17:00:00	IWM	ETF	154.39	154.61	154.29	154.5	161795.0
2020-08-21 18:00:00	IWM	ETF	154.5	154.5	154.4	154.5	487.0
2020-08-21 19:00:00	IWM	ETF	154.32	154.5	154.32	154.5	129701.0
2020-08-21 04:00:00	DIA	ETF	277.22	277.23	277.22	277.23	5500.0
2020-08-21 06:00:00	DIA	ETF	276.63	276.71	276.63	276.7	1600.0

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

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