PREVIEW / etf_1hour / 2020-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-21.parquet
  size:    374 KB
  rows:    12,871

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-21 04:00:00	SPY	ETF	326.0	326.92	326.0	326.8	30195.0
2020-07-21 05:00:00	SPY	ETF	326.85	326.99	326.7	326.82	35964.0
2020-07-21 06:00:00	SPY	ETF	326.83	327.17	326.76	326.9	51921.0
2020-07-21 07:00:00	SPY	ETF	326.78	327.33	326.56	327.01	281464.0
2020-07-21 08:00:00	SPY	ETF	326.7199	327.32	325.05	326.7	271815.0
2020-07-21 09:00:00	SPY	ETF	326.67	326.93	325.89	326.71	7587804.0
2020-07-21 10:00:00	SPY	ETF	326.73	326.91	325.44	326.4	8374774.0
2020-07-21 11:00:00	SPY	ETF	326.4	326.6738	325.62	326.01	4975216.0
2020-07-21 12:00:00	SPY	ETF	326.02	326.3	325.59	326.29	3872000.0
2020-07-21 13:00:00	SPY	ETF	326.2883	326.69	325.77	326.52	3088357.0
2020-07-21 14:00:00	SPY	ETF	326.53	326.85	326.26	326.42	3315526.0
2020-07-21 15:00:00	SPY	ETF	326.43	326.505	323.94	324.96	18186117.0
2020-07-21 16:00:00	SPY	ETF	324.95	325.34	324.85	325.02	6512886.0
2020-07-21 17:00:00	SPY	ETF	325.01	325.09	324.8	324.95	151847.0
2020-07-21 18:00:00	SPY	ETF	324.96	325.85	324.91	325.77	215189.0
2020-07-21 19:00:00	SPY	ETF	325.7	325.84	325.41	325.69	68415.0
2020-07-21 04:00:00	QQQ	ETF	269.14	269.76	269.14	269.41	55276.0
2020-07-21 05:00:00	QQQ	ETF	269.42	269.69	269.19	269.5	42025.0
2020-07-21 06:00:00	QQQ	ETF	269.51	269.72	269.16	269.24	74561.0
2020-07-21 07:00:00	QQQ	ETF	269.2	269.56	268.91	269.35	219806.0
2020-07-21 08:00:00	QQQ	ETF	269.2801	269.78	268.54	268.82	260497.0
2020-07-21 09:00:00	QQQ	ETF	268.82	269.18	266.0514	267.0	7963846.0
2020-07-21 10:00:00	QQQ	ETF	266.99	267.23	264.97	265.892	6925270.0
2020-07-21 11:00:00	QQQ	ETF	265.88	266.22	264.24	264.67	3892556.0
2020-07-21 12:00:00	QQQ	ETF	264.6714	265.17	264.18	265.15	3192323.0
2020-07-21 13:00:00	QQQ	ETF	265.15	266.2192	264.271	265.88	3322300.0
2020-07-21 14:00:00	QQQ	ETF	265.92	266.75	265.64	265.92	3240457.0
2020-07-21 15:00:00	QQQ	ETF	265.93	266.02	263.125	264.05	8271264.0
2020-07-21 16:00:00	QQQ	ETF	264.05	264.96	263.98	264.6	1123891.0
2020-07-21 17:00:00	QQQ	ETF	264.64	264.68	264.41	264.58	29006.0
2020-07-21 18:00:00	QQQ	ETF	264.7	265.48	264.57	265.48	125701.0
2020-07-21 19:00:00	QQQ	ETF	265.44	265.48	265.15	265.24	90293.0
2020-07-21 04:00:00	IWM	ETF	147.05	147.8	147.0	147.8	12447.0
2020-07-21 05:00:00	IWM	ETF	147.76	147.89	147.49	147.74	11500.0
2020-07-21 06:00:00	IWM	ETF	147.72	148.02	147.72	147.8	89743.0
2020-07-21 07:00:00	IWM	ETF	147.8	147.94	147.59	147.66	94775.0
2020-07-21 08:00:00	IWM	ETF	147.8799	147.92	147.01	147.62	121301.0
2020-07-21 09:00:00	IWM	ETF	147.62	149.16	147.2	148.87	4644305.0
2020-07-21 10:00:00	IWM	ETF	148.88	148.995	147.43	148.42	3944817.0
2020-07-21 11:00:00	IWM	ETF	148.44	148.95	148.13	148.35	1858275.0
2020-07-21 12:00:00	IWM	ETF	148.35	148.64	148.02	148.54	1112834.0
2020-07-21 13:00:00	IWM	ETF	148.55	148.71	148.265	148.345	815778.0
2020-07-21 14:00:00	IWM	ETF	148.35	148.58	148.195	148.43	1400400.0
2020-07-21 15:00:00	IWM	ETF	148.43	148.45	147.37	148.0	5768942.0
2020-07-21 16:00:00	IWM	ETF	148.0	148.1684	147.85	147.96	1475429.0
2020-07-21 17:00:00	IWM	ETF	147.95	148.03	147.71	147.71	265296.0
2020-07-21 18:00:00	IWM	ETF	147.84	148.31	147.78	148.31	74666.0
2020-07-21 19:00:00	IWM	ETF	148.24	148.31	148.05	148.21	1678.0
2020-07-21 04:00:00	DIA	ETF	268.82	269.15	268.71	269.15	300.0
2020-07-21 05:00:00	DIA	ETF	269.15	269.17	269.02	269.11	2250.0

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

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