PREVIEW / etf_1hour / 2020-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-28.parquet
  size:    359 KB
  rows:    12,324

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-28 04:00:00	SPY	ETF	323.4	323.48	323.08	323.4	24434.0
2020-07-28 05:00:00	SPY	ETF	323.53	323.6	322.12	322.4	51721.0
2020-07-28 06:00:00	SPY	ETF	322.44	322.71	321.79	322.67	77803.0
2020-07-28 07:00:00	SPY	ETF	322.68	322.84	321.59	321.98	187115.0
2020-07-28 08:00:00	SPY	ETF	322.0	323.7	321.59	322.48	258992.0
2020-07-28 09:00:00	SPY	ETF	322.47	323.04	321.31	321.89	4525433.0
2020-07-28 10:00:00	SPY	ETF	321.88	323.08	321.71	322.81	5397187.0
2020-07-28 11:00:00	SPY	ETF	322.82	323.5	322.12	322.93	5809401.0
2020-07-28 12:00:00	SPY	ETF	322.93	323.055	322.52	323.02	5186906.0
2020-07-28 13:00:00	SPY	ETF	323.01	323.64	322.73	323.52	5937811.0
2020-07-28 14:00:00	SPY	ETF	323.54	323.61	322.945	323.0	4967730.0
2020-07-28 15:00:00	SPY	ETF	323.0	323.09	320.85	321.2	17358560.0
2020-07-28 16:00:00	SPY	ETF	321.22	321.55	320.98	321.38	5429855.0
2020-07-28 17:00:00	SPY	ETF	321.33	321.49	321.17	321.46	431164.0
2020-07-28 18:00:00	SPY	ETF	321.48	321.85	321.48	321.71	79027.0
2020-07-28 19:00:00	SPY	ETF	321.75	321.81	321.38	321.8	56524.0
2020-07-28 04:00:00	QQQ	ETF	260.64	260.71	259.98	260.52	38409.0
2020-07-28 05:00:00	QQQ	ETF	260.55	260.67	259.25	259.47	31476.0
2020-07-28 06:00:00	QQQ	ETF	259.48	259.85	259.0	259.85	59260.0
2020-07-28 07:00:00	QQQ	ETF	259.88	260.08	258.65	258.88	309371.0
2020-07-28 08:00:00	QQQ	ETF	259.3999	261.25	258.7	259.68	142578.0
2020-07-28 09:00:00	QQQ	ETF	259.65	259.71	257.56	258.27	4479282.0
2020-07-28 10:00:00	QQQ	ETF	258.27	259.36	257.95	259.2	3802580.0
2020-07-28 11:00:00	QQQ	ETF	259.22	259.85	258.39	258.99	2379421.0
2020-07-28 12:00:00	QQQ	ETF	258.99	259.465	258.42	259.36	2040177.0
2020-07-28 13:00:00	QQQ	ETF	259.36	259.83	258.9101	259.5	1667297.0
2020-07-28 14:00:00	QQQ	ETF	259.51	259.55	258.47	258.5908	3058649.0
2020-07-28 15:00:00	QQQ	ETF	258.59	258.66	256.51	256.76	6521391.0
2020-07-28 16:00:00	QQQ	ETF	256.79	257.38	256.6475	257.37	1097645.0
2020-07-28 17:00:00	QQQ	ETF	257.38	257.64	257.3	257.54	42007.0
2020-07-28 18:00:00	QQQ	ETF	257.58	257.93	257.49	257.77	107011.0
2020-07-28 19:00:00	QQQ	ETF	257.75	257.75	257.36	257.73	78019.0
2020-07-28 04:00:00	IWM	ETF	147.55	147.75	147.52	147.75	6201.0
2020-07-28 05:00:00	IWM	ETF	147.61	147.61	147.0	147.03	5420.0
2020-07-28 06:00:00	IWM	ETF	147.04	147.3	146.65	147.3	19981.0
2020-07-28 07:00:00	IWM	ETF	147.31	147.41	146.75	146.85	38292.0
2020-07-28 08:00:00	IWM	ETF	146.87	147.77	146.75	147.27	33172.0
2020-07-28 09:00:00	IWM	ETF	147.2	148.04	146.63	147.11	1925362.0
2020-07-28 10:00:00	IWM	ETF	147.11	147.77	146.83	147.14	1858437.0
2020-07-28 11:00:00	IWM	ETF	147.13	147.7	146.72	147.445	1431568.0
2020-07-28 12:00:00	IWM	ETF	147.45	147.6	147.1	147.51	1068474.0
2020-07-28 13:00:00	IWM	ETF	147.51	147.59	147.23	147.58	760537.0
2020-07-28 14:00:00	IWM	ETF	147.59	147.715	147.26	147.29	1060995.0
2020-07-28 15:00:00	IWM	ETF	147.29	147.35	146.06	146.14	2625944.0
2020-07-28 16:00:00	IWM	ETF	146.15	147.2077	145.99	146.42	755432.0
2020-07-28 17:00:00	IWM	ETF	146.45	146.45	146.2908	146.44	18478.0
2020-07-28 18:00:00	IWM	ETF	146.44	146.7	146.44	146.62	7746.0
2020-07-28 19:00:00	IWM	ETF	146.55	146.61	146.4	146.6	14605.0
2020-07-28 04:00:00	DIA	ETF	265.94	265.94	265.94	265.94	100.0
2020-07-28 05:00:00	DIA	ETF	265.76	265.76	265.3	265.3	3000.0

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

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