PREVIEW / etf_1hour / 2020-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-10.parquet
  size:    401 KB
  rows:    13,767

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-11-10 04:00:00	SPY	ETF	354.42	355.77	354.28	355.19	130285.0
2020-11-10 05:00:00	SPY	ETF	355.12	355.18	352.4	352.45	179719.0
2020-11-10 06:00:00	SPY	ETF	352.26	354.44	351.96	354.38	238479.0
2020-11-10 07:00:00	SPY	ETF	354.41	355.0	353.39	353.47	520133.0
2020-11-10 08:00:00	SPY	ETF	353.6801	355.05	351.69	353.37	529242.0
2020-11-10 09:00:00	SPY	ETF	353.3	354.41	351.92	353.56	8678685.0
2020-11-10 10:00:00	SPY	ETF	353.58	354.5699	350.51	351.6719	10886230.0
2020-11-10 11:00:00	SPY	ETF	351.65	354.25	351.57	353.58	9374705.0
2020-11-10 12:00:00	SPY	ETF	353.57	355.18	353.48	354.27	7568470.0
2020-11-10 13:00:00	SPY	ETF	354.26	354.7	352.22	354.08	7727709.0
2020-11-10 14:00:00	SPY	ETF	354.07	354.624	352.86	353.99	10615535.0
2020-11-10 15:00:00	SPY	ETF	353.97	354.81	353.27	354.07	16968547.0
2020-11-10 16:00:00	SPY	ETF	354.0601	354.68	353.579	354.47	9686461.0
2020-11-10 17:00:00	SPY	ETF	354.47	354.51	354.2	354.4	658103.0
2020-11-10 18:00:00	SPY	ETF	354.46	355.07	353.42	353.68	267449.0
2020-11-10 19:00:00	SPY	ETF	353.62	353.94	353.02	353.52	155557.0
2020-11-10 04:00:00	QQQ	ETF	287.49	287.64	285.8	286.09	112014.0
2020-11-10 05:00:00	QQQ	ETF	286.11	286.49	282.2	282.28	432751.0
2020-11-10 06:00:00	QQQ	ETF	282.29	284.4	281.93	284.22	427432.0
2020-11-10 07:00:00	QQQ	ETF	284.24	284.91	283.29	283.47	1018608.0
2020-11-10 08:00:00	QQQ	ETF	284.0	289.11	282.21	284.65	933133.0
2020-11-10 09:00:00	QQQ	ETF	284.64	286.6599	283.3	284.22	6665361.0
2020-11-10 10:00:00	QQQ	ETF	284.2	285.17	280.62	282.23	10087564.0
2020-11-10 11:00:00	QQQ	ETF	282.22	285.96	282.0664	284.43	6423889.0
2020-11-10 12:00:00	QQQ	ETF	284.436	286.49	284.4	285.33	4285851.0
2020-11-10 13:00:00	QQQ	ETF	285.33	286.2172	282.4	284.3113	5122530.0
2020-11-10 14:00:00	QQQ	ETF	284.28	285.18	282.37	283.6221	6613208.0
2020-11-10 15:00:00	QQQ	ETF	283.61	284.49	282.6453	283.46	7003314.0
2020-11-10 16:00:00	QQQ	ETF	283.49	284.04	283.3	283.62	1989457.0
2020-11-10 17:00:00	QQQ	ETF	283.46	283.6	283.38	283.539	29330.0
2020-11-10 18:00:00	QQQ	ETF	283.55	284.26	282.7	282.99	167872.0
2020-11-10 19:00:00	QQQ	ETF	282.95	283.55	282.55	283.43	216732.0
2020-11-10 04:00:00	IWM	ETF	171.41	173.3	171.31	173.1	87511.0
2020-11-10 05:00:00	IWM	ETF	173.13	173.42	172.33	172.7	102716.0
2020-11-10 06:00:00	IWM	ETF	172.6	174.02	172.24	172.95	161724.0
2020-11-10 07:00:00	IWM	ETF	172.95	172.97	171.81	171.88	265713.0
2020-11-10 08:00:00	IWM	ETF	172.4299	172.92	169.47	171.99	272736.0
2020-11-10 09:00:00	IWM	ETF	171.99	172.18	170.03	171.555	5118756.0
2020-11-10 10:00:00	IWM	ETF	171.545	171.679	169.75	170.42	3978030.0
2020-11-10 11:00:00	IWM	ETF	170.43	172.09	170.36	171.79	2656266.0
2020-11-10 12:00:00	IWM	ETF	171.79	172.96	171.76	172.65	2537255.0
2020-11-10 13:00:00	IWM	ETF	172.62	172.849	171.7	172.55	1848528.0
2020-11-10 14:00:00	IWM	ETF	172.55	173.2	172.17	173.09	2361731.0
2020-11-10 15:00:00	IWM	ETF	173.08	173.33	172.15	172.64	4904807.0
2020-11-10 16:00:00	IWM	ETF	172.65	172.91	169.4461	172.75	2130739.0
2020-11-10 17:00:00	IWM	ETF	172.71	172.99	172.61	172.99	26435.0
2020-11-10 18:00:00	IWM	ETF	172.8	173.08	172.3	172.3	126372.0
2020-11-10 19:00:00	IWM	ETF	172.35	172.51	171.95	172.02	35543.0
2020-11-10 04:00:00	DIA	ETF	292.53	294.12	292.25	293.87	10012.0
2020-11-10 05:00:00	DIA	ETF	293.77	293.77	292.3	292.69	8614.0

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

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