PREVIEW / etf_1hour / 2020-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-29.parquet
  size:    383 KB
  rows:    13,029

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-29 04:00:00	SPY	ETF	329.16	330.1	328.41	328.95	104152.0
2020-10-29 05:00:00	SPY	ETF	329.05	329.64	328.62	329.07	66259.0
2020-10-29 06:00:00	SPY	ETF	328.99	328.99	328.18	328.53	190002.0
2020-10-29 07:00:00	SPY	ETF	328.51	328.53	325.65	325.75	776616.0
2020-10-29 08:00:00	SPY	ETF	325.79	331.02	325.67	327.18	1265300.0
2020-10-29 09:00:00	SPY	ETF	327.08	329.4853	325.09	327.83	11636626.0
2020-10-29 10:00:00	SPY	ETF	327.87	329.82	327.11	329.22	14505192.0
2020-10-29 11:00:00	SPY	ETF	329.21	329.87	327.82	328.43	9903193.0
2020-10-29 12:00:00	SPY	ETF	328.44	329.71	327.98	329.2	5469687.0
2020-10-29 13:00:00	SPY	ETF	329.21	331.57	328.5734	331.49	7886091.0
2020-10-29 14:00:00	SPY	ETF	331.48	333.395	331.45	332.09	12259448.0
2020-10-29 15:00:00	SPY	ETF	332.11	332.58	329.93	329.99	15777089.0
2020-10-29 16:00:00	SPY	ETF	329.97	331.11	327.18	327.64	8358680.0
2020-10-29 17:00:00	SPY	ETF	327.55	327.59	326.88	327.05	263371.0
2020-10-29 18:00:00	SPY	ETF	327.03	327.46	326.47	327.01	277526.0
2020-10-29 19:00:00	SPY	ETF	327.1	328.16	327.1	327.65	261841.0
2020-10-29 04:00:00	QQQ	ETF	274.32	275.12	274.0	274.41	66295.0
2020-10-29 05:00:00	QQQ	ETF	274.54	275.31	274.44	274.64	51033.0
2020-10-29 06:00:00	QQQ	ETF	274.7	274.7	273.82	274.43	59247.0
2020-10-29 07:00:00	QQQ	ETF	274.41	274.41	271.95	272.02	470024.0
2020-10-29 08:00:00	QQQ	ETF	272.1	275.31	271.64	273.3	562402.0
2020-10-29 09:00:00	QQQ	ETF	273.27	274.9898	272.52	274.71	5578168.0
2020-10-29 10:00:00	QQQ	ETF	274.74	275.85	274.37	275.34	4556945.0
2020-10-29 11:00:00	QQQ	ETF	275.34	276.53	274.79	275.2958	3659317.0
2020-10-29 12:00:00	QQQ	ETF	275.3072	276.49	274.97	276.12	2424413.0
2020-10-29 13:00:00	QQQ	ETF	276.13	277.7899	275.86	277.705	3091890.0
2020-10-29 14:00:00	QQQ	ETF	277.7	279.49	277.68	278.26	4825521.0
2020-10-29 15:00:00	QQQ	ETF	278.3	279.02	276.21	276.23	6151523.0
2020-10-29 16:00:00	QQQ	ETF	276.25	278.83	273.75	274.34	4019372.0
2020-10-29 17:00:00	QQQ	ETF	274.25	274.42	273.5	273.71	213523.0
2020-10-29 18:00:00	QQQ	ETF	273.65	273.93	272.69	273.12	318951.0
2020-10-29 19:00:00	QQQ	ETF	273.15	274.13	273.11	273.59	189651.0
2020-10-29 04:00:00	IWM	ETF	154.25	154.7	153.64	153.75	29729.0
2020-10-29 05:00:00	IWM	ETF	153.8	154.24	153.59	153.75	13600.0
2020-10-29 06:00:00	IWM	ETF	153.8	153.8	153.39	153.64	19187.0
2020-10-29 07:00:00	IWM	ETF	153.65	153.65	152.34	152.4	138311.0
2020-10-29 08:00:00	IWM	ETF	153.58	155.0	152.25	153.1	278706.0
2020-10-29 09:00:00	IWM	ETF	152.99	153.2	151.67	153.06	3800128.0
2020-10-29 10:00:00	IWM	ETF	153.06	154.31	152.43	154.0	4421369.0
2020-10-29 11:00:00	IWM	ETF	153.99	154.31	153.47	153.78	2199173.0
2020-10-29 12:00:00	IWM	ETF	153.83	154.09	153.495	153.56	1555331.0
2020-10-29 13:00:00	IWM	ETF	153.56	154.81	153.12	154.8	1942022.0
2020-10-29 14:00:00	IWM	ETF	154.79	155.7	154.76	155.18	3163688.0
2020-10-29 15:00:00	IWM	ETF	155.2	155.79	154.96	155.11	4266126.0
2020-10-29 16:00:00	IWM	ETF	155.11	155.58	153.5	153.91	1389719.0
2020-10-29 17:00:00	IWM	ETF	153.91	154.09	153.82	153.95	43188.0
2020-10-29 18:00:00	IWM	ETF	153.8	154.09	153.51	153.77	56021.0
2020-10-29 19:00:00	IWM	ETF	153.95	154.31	153.95	154.15	41585.0
2020-10-29 04:00:00	DIA	ETF	267.84	267.85	266.38	267.02	1610.0
2020-10-29 05:00:00	DIA	ETF	267.34	267.34	266.5	266.91	4350.0

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

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