PREVIEW / etf_1hour / 2020-07-22

all etf 1-hour files

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

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-22 04:00:00	SPY	ETF	324.5	324.5	323.33	323.57	56920.0
2020-07-22 05:00:00	SPY	ETF	323.61	324.11	322.79	324.11	60725.0
2020-07-22 06:00:00	SPY	ETF	324.16	324.37	323.62	324.14	191248.0
2020-07-22 07:00:00	SPY	ETF	324.22	324.85	324.17	324.75	423345.0
2020-07-22 08:00:00	SPY	ETF	324.76	326.3	323.7	324.81	427880.0
2020-07-22 09:00:00	SPY	ETF	324.72	326.16	324.37	325.71	6343180.0
2020-07-22 10:00:00	SPY	ETF	325.72	326.02	324.7	325.2001	6096580.0
2020-07-22 11:00:00	SPY	ETF	325.21	325.8	324.5	325.6	4077690.0
2020-07-22 12:00:00	SPY	ETF	325.61	326.3216	325.44	325.865	3370677.0
2020-07-22 13:00:00	SPY	ETF	325.8614	326.03	324.74	324.77	3522120.0
2020-07-22 14:00:00	SPY	ETF	324.77	325.9377	324.73	325.76	6093298.0
2020-07-22 15:00:00	SPY	ETF	325.7783	327.2	325.67	326.82	16670123.0
2020-07-22 16:00:00	SPY	ETF	326.81	327.13	326.43	326.73	9224840.0
2020-07-22 17:00:00	SPY	ETF	326.7	326.82	326.6	326.72	89864.0
2020-07-22 18:00:00	SPY	ETF	326.72	326.99	326.41	326.7	128445.0
2020-07-22 19:00:00	SPY	ETF	326.7	326.72	326.05	326.11	115504.0
2020-07-22 04:00:00	QQQ	ETF	263.81	263.87	263.11	263.53	37061.0
2020-07-22 05:00:00	QQQ	ETF	263.5	264.47	263.15	264.31	27400.0
2020-07-22 06:00:00	QQQ	ETF	264.35	265.29	264.22	265.17	38942.0
2020-07-22 07:00:00	QQQ	ETF	265.14	265.45	264.94	265.0	220277.0
2020-07-22 08:00:00	QQQ	ETF	265.21	265.77	263.81	265.13	208636.0
2020-07-22 09:00:00	QQQ	ETF	265.2	265.795	263.99	265.3299	3965351.0
2020-07-22 10:00:00	QQQ	ETF	265.33	265.89	263.11	263.475	4045910.0
2020-07-22 11:00:00	QQQ	ETF	263.47	264.49	262.55	264.24	3584190.0
2020-07-22 12:00:00	QQQ	ETF	264.28	264.97	263.85	264.2076	2059093.0
2020-07-22 13:00:00	QQQ	ETF	264.19	264.49	263.08	263.155	2400192.0
2020-07-22 14:00:00	QQQ	ETF	263.16	264.16	263.12	263.87	2428863.0
2020-07-22 15:00:00	QQQ	ETF	263.9	265.33	263.87	264.92	5053281.0
2020-07-22 16:00:00	QQQ	ETF	264.91	265.26	263.37	264.55	1464778.0
2020-07-22 17:00:00	QQQ	ETF	264.56	264.69	264.35	264.5	64357.0
2020-07-22 18:00:00	QQQ	ETF	264.53	264.99	264.31	264.57	161659.0
2020-07-22 19:00:00	QQQ	ETF	264.62	264.74	264.0	264.06	74358.0
2020-07-22 04:00:00	IWM	ETF	147.46	147.56	146.15	146.47	45555.0
2020-07-22 05:00:00	IWM	ETF	146.43	146.97	145.96	146.97	14586.0
2020-07-22 06:00:00	IWM	ETF	146.9	146.97	146.55	146.97	12864.0
2020-07-22 07:00:00	IWM	ETF	146.93	147.45	146.9	147.12	299474.0
2020-07-22 08:00:00	IWM	ETF	147.1199	148.7	146.7	147.15	88032.0
2020-07-22 09:00:00	IWM	ETF	147.1	148.3	146.96	147.62	2574459.0
2020-07-22 10:00:00	IWM	ETF	147.61	148.67	147.52	148.38	2016928.0
2020-07-22 11:00:00	IWM	ETF	148.375	148.495	147.84	148.09	1573799.0
2020-07-22 12:00:00	IWM	ETF	148.075	148.47	147.94	148.04	922581.0
2020-07-22 13:00:00	IWM	ETF	148.04	148.08	147.495	147.505	1254288.0
2020-07-22 14:00:00	IWM	ETF	147.51	147.865	147.35	147.755	1300507.0
2020-07-22 15:00:00	IWM	ETF	147.76	148.22	147.65	148.17	2550425.0
2020-07-22 16:00:00	IWM	ETF	148.11	148.63	148.05	148.46	4447156.0
2020-07-22 17:00:00	IWM	ETF	148.64	148.64	148.35	148.39	8870.0
2020-07-22 18:00:00	IWM	ETF	148.37	148.67	148.28	148.32	17131.0
2020-07-22 19:00:00	IWM	ETF	148.33	148.36	148.06	148.07	9150.0
2020-07-22 04:00:00	DIA	ETF	267.75	267.83	266.82	266.89	8200.0
2020-07-22 05:00:00	DIA	ETF	266.82	267.57	266.82	267.57	1000.0

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

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