PREVIEW / etf_1hour / 2020-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-23.parquet
  size:    367 KB
  rows:    12,679

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-23 04:00:00	SPY	ETF	328.15	328.51	327.57	327.57	29502.0
2020-07-23 05:00:00	SPY	ETF	327.56	327.98	327.56	327.85	19062.0
2020-07-23 06:00:00	SPY	ETF	327.85	328.27	327.59	327.64	50272.0
2020-07-23 07:00:00	SPY	ETF	327.68	327.93	327.21	327.65	320269.0
2020-07-23 08:00:00	SPY	ETF	327.9	328.19	326.29	326.3	475447.0
2020-07-23 09:00:00	SPY	ETF	326.28	327.23	326.121	326.99	5002994.0
2020-07-23 10:00:00	SPY	ETF	327.0	327.09	325.5238	326.26	7023443.0
2020-07-23 11:00:00	SPY	ETF	326.26	327.12	325.83	326.64	4985661.0
2020-07-23 12:00:00	SPY	ETF	326.665	326.67	324.98	325.27	7143716.0
2020-07-23 13:00:00	SPY	ETF	325.25	325.9	322.98	323.57	8912564.0
2020-07-23 14:00:00	SPY	ETF	323.56	323.59	321.48	322.95	13691416.0
2020-07-23 15:00:00	SPY	ETF	322.96	323.24	321.72	322.935	21780292.0
2020-07-23 16:00:00	SPY	ETF	322.94	323.05	322.05	323.0	5173033.0
2020-07-23 17:00:00	SPY	ETF	323.0	323.08	322.85	322.98	106250.0
2020-07-23 18:00:00	SPY	ETF	323.04	323.59	323.04	323.59	116582.0
2020-07-23 19:00:00	SPY	ETF	323.55	323.61	323.11	323.45	55044.0
2020-07-23 04:00:00	QQQ	ETF	266.29	266.43	265.66	265.66	33727.0
2020-07-23 05:00:00	QQQ	ETF	265.68	266.09	265.54	265.82	16916.0
2020-07-23 06:00:00	QQQ	ETF	265.99	266.13	265.64	265.75	27415.0
2020-07-23 07:00:00	QQQ	ETF	265.79	265.93	265.1	265.45	210071.0
2020-07-23 08:00:00	QQQ	ETF	265.91	266.0904	264.3	264.64	241235.0
2020-07-23 09:00:00	QQQ	ETF	264.54	265.24	263.46	264.57	3452245.0
2020-07-23 10:00:00	QQQ	ETF	264.57	264.83	262.7722	263.76	4044190.0
2020-07-23 11:00:00	QQQ	ETF	263.77	264.2	263.14	263.31	2686092.0
2020-07-23 12:00:00	QQQ	ETF	263.31	263.32	259.88	260.81	5920835.0
2020-07-23 13:00:00	QQQ	ETF	260.78	261.52	257.96	258.75	6881829.0
2020-07-23 14:00:00	QQQ	ETF	258.73	258.8	256.55	258.22	9162615.0
2020-07-23 15:00:00	QQQ	ETF	258.25	258.48	257.01	257.95	8771636.0
2020-07-23 16:00:00	QQQ	ETF	257.95	258.23	256.84	257.75	1321183.0
2020-07-23 17:00:00	QQQ	ETF	257.79	257.9	257.38	257.82	137595.0
2020-07-23 18:00:00	QQQ	ETF	257.92	258.43	257.92	258.27	178000.0
2020-07-23 19:00:00	QQQ	ETF	258.38	258.4	258.0	258.21	375485.0
2020-07-23 04:00:00	IWM	ETF	148.96	149.26	148.7	148.7	13564.0
2020-07-23 05:00:00	IWM	ETF	148.69	148.93	148.69	148.76	4600.0
2020-07-23 06:00:00	IWM	ETF	148.85	149.05	148.65	148.65	3467.0
2020-07-23 07:00:00	IWM	ETF	148.74	148.85	148.5	148.8	44282.0
2020-07-23 08:00:00	IWM	ETF	149.0396	149.0396	147.55	147.62	205617.0
2020-07-23 09:00:00	IWM	ETF	147.7	149.0	147.51	148.985	1691023.0
2020-07-23 10:00:00	IWM	ETF	149.02	149.49	148.36	149.12	2524179.0
2020-07-23 11:00:00	IWM	ETF	149.13	150.2	149.025	149.94	2345591.0
2020-07-23 12:00:00	IWM	ETF	149.945	149.96	149.18	149.23	1941553.0
2020-07-23 13:00:00	IWM	ETF	149.2293	149.48	147.85	148.21	2600599.0
2020-07-23 14:00:00	IWM	ETF	148.2	148.26	146.7	148.07	2800043.0
2020-07-23 15:00:00	IWM	ETF	148.1	148.36	147.59	148.2981	4011915.0
2020-07-23 16:00:00	IWM	ETF	148.26	148.32	147.63	148.25	538338.0
2020-07-23 17:00:00	IWM	ETF	148.33	148.33	148.12	148.26	4917.0
2020-07-23 18:00:00	IWM	ETF	148.33	148.75	148.33	148.75	26794.0
2020-07-23 19:00:00	IWM	ETF	148.63	148.72	148.46	148.56	17750.0
2020-07-23 04:00:00	DIA	ETF	271.29	271.49	271.25	271.49	4300.0
2020-07-23 05:00:00	DIA	ETF	271.03	271.03	271.03	271.03	150.0

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

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