PREVIEW / etf_1hour / 2020-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-07.parquet
  size:    365 KB
  rows:    12,801

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-07-07 04:00:00	SPY	ETF	315.6	315.77	314.5	314.79	77740.0
2020-07-07 05:00:00	SPY	ETF	314.69	314.79	314.09	314.4	47220.0
2020-07-07 06:00:00	SPY	ETF	314.47	315.0	313.95	314.35	138911.0
2020-07-07 07:00:00	SPY	ETF	314.53	315.46	314.32	315.23	333029.0
2020-07-07 08:00:00	SPY	ETF	315.24	316.9	314.1704	315.32	465388.0
2020-07-07 09:00:00	SPY	ETF	315.3	316.25	314.9	315.99	8872238.0
2020-07-07 10:00:00	SPY	ETF	315.985	317.0496	315.83	316.8317	8884160.0
2020-07-07 11:00:00	SPY	ETF	316.83	317.52	316.58	316.73	5604929.0
2020-07-07 12:00:00	SPY	ETF	316.74	316.98	315.93	316.37	5099197.0
2020-07-07 13:00:00	SPY	ETF	316.375	317.034	315.72	316.2	6002180.0
2020-07-07 14:00:00	SPY	ETF	316.2007	316.3	315.04	315.53	12312531.0
2020-07-07 15:00:00	SPY	ETF	315.53	315.53	313.37	313.72	24977983.0
2020-07-07 16:00:00	SPY	ETF	313.71	314.5426	313.57	313.67	9049844.0
2020-07-07 17:00:00	SPY	ETF	313.6	313.76	313.52	313.69	110051.0
2020-07-07 18:00:00	SPY	ETF	313.69	314.09	313.63	313.76	244741.0
2020-07-07 19:00:00	SPY	ETF	313.75	314.26	313.73	314.17	78423.0
2020-07-07 04:00:00	QQQ	ETF	257.59	258.05	257.1	257.24	73106.0
2020-07-07 05:00:00	QQQ	ETF	257.41	257.41	257.0	257.35	25513.0
2020-07-07 06:00:00	QQQ	ETF	257.3	257.52	257.01	257.31	110550.0
2020-07-07 07:00:00	QQQ	ETF	257.37	257.84	257.25	257.73	117331.0
2020-07-07 08:00:00	QQQ	ETF	257.6199	258.78	257.0196	257.94	266177.0
2020-07-07 09:00:00	QQQ	ETF	257.93	259.4	257.54	258.77	5835949.0
2020-07-07 10:00:00	QQQ	ETF	258.79	260.35	258.56	260.115	5155250.0
2020-07-07 11:00:00	QQQ	ETF	260.11	260.88	259.8	259.95	3465800.0
2020-07-07 12:00:00	QQQ	ETF	259.97	260.19	258.87	259.49	2759552.0
2020-07-07 13:00:00	QQQ	ETF	259.48	259.6	258.5601	258.86	2435665.0
2020-07-07 14:00:00	QQQ	ETF	258.87	258.96	257.67	258.28	3227190.0
2020-07-07 15:00:00	QQQ	ETF	258.27	258.275	256.3	256.56	5840438.0
2020-07-07 16:00:00	QQQ	ETF	256.57	257.08	256.4582	256.81	1198427.0
2020-07-07 17:00:00	QQQ	ETF	256.89	256.98	256.82	256.9	56391.0
2020-07-07 18:00:00	QQQ	ETF	256.89	257.32	256.79	257.13	84052.0
2020-07-07 19:00:00	QQQ	ETF	257.11	257.48	257.11	257.4	87352.0
2020-07-07 04:00:00	IWM	ETF	142.53	142.77	141.8	141.8	7681.0
2020-07-07 05:00:00	IWM	ETF	141.84	141.84	141.57	141.74	28700.0
2020-07-07 06:00:00	IWM	ETF	141.8	142.05	141.4	141.56	97645.0
2020-07-07 07:00:00	IWM	ETF	141.75	142.58	141.71	142.32	59866.0
2020-07-07 08:00:00	IWM	ETF	142.2799	142.49	141.7196	142.24	131424.0
2020-07-07 09:00:00	IWM	ETF	142.24	142.36	141.53	141.74	2168202.0
2020-07-07 10:00:00	IWM	ETF	141.75	142.67	141.625	142.62	2446767.0
2020-07-07 11:00:00	IWM	ETF	142.62	143.435	142.49	142.88	1910662.0
2020-07-07 12:00:00	IWM	ETF	142.89	143.24	141.92	142.16	2251584.0
2020-07-07 13:00:00	IWM	ETF	142.15	142.58	141.95	142.47	1177208.0
2020-07-07 14:00:00	IWM	ETF	142.47	142.55	141.585	141.89	1544533.0
2020-07-07 15:00:00	IWM	ETF	141.9	141.92	140.48	140.81	3954702.0
2020-07-07 16:00:00	IWM	ETF	140.84	140.93	140.6	140.74	701421.0
2020-07-07 17:00:00	IWM	ETF	140.62	140.79	140.6	140.64	17669.0
2020-07-07 18:00:00	IWM	ETF	140.65	140.9	140.65	140.77	29009.0
2020-07-07 19:00:00	IWM	ETF	140.85	141.0	140.83	140.93	28996.0
2020-07-07 04:00:00	DIA	ETF	261.08	261.35	260.36	260.5	12250.0
2020-07-07 05:00:00	DIA	ETF	260.09	260.16	259.99	260.16	2623.0

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

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