PREVIEW / etf_1hour / 2021-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-06.parquet
  size:    446 KB
  rows:    15,848

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
2021-12-06 04:00:00	SPY	ETF	455.5	456.81	454.3	454.4	99047.0
2021-12-06 05:00:00	SPY	ETF	454.51	454.76	453.0	453.04	111945.0
2021-12-06 06:00:00	SPY	ETF	453.24	455.3	453.24	455.29	135188.0
2021-12-06 07:00:00	SPY	ETF	455.34	455.5	454.36	454.61	238756.0
2021-12-06 08:00:00	SPY	ETF	454.68	456.4004	453.4204	455.59	459359.0
2021-12-06 09:00:00	SPY	ETF	455.57	456.71	453.56	456.25	11323711.0
2021-12-06 10:00:00	SPY	ETF	456.24	458.4	454.85	458.318	12260161.0
2021-12-06 11:00:00	SPY	ETF	458.32	458.47	456.52	457.37	6259528.0
2021-12-06 12:00:00	SPY	ETF	457.37	459.65	457.25	459.63	6089371.0
2021-12-06 13:00:00	SPY	ETF	459.63	460.64	459.29	460.355	7481837.0
2021-12-06 14:00:00	SPY	ETF	460.36	460.79	458.76	458.87	7183930.0
2021-12-06 15:00:00	SPY	ETF	458.86	459.62	458.32	458.78	16212788.0
2021-12-06 16:00:00	SPY	ETF	458.78	459.14	458.44	459.12	6503630.0
2021-12-06 17:00:00	SPY	ETF	459.02	459.11	458.99	459.1	112896.0
2021-12-06 18:00:00	SPY	ETF	459.1	459.36	458.66	459.04	101435.0
2021-12-06 19:00:00	SPY	ETF	459.03	459.1	458.45	458.96	59994.0
2021-12-06 04:00:00	QQQ	ETF	384.13	385.4	382.28	382.3	102584.0
2021-12-06 05:00:00	QQQ	ETF	382.48	382.84	380.23	380.33	89949.0
2021-12-06 06:00:00	QQQ	ETF	380.27	382.53	380.27	382.48	68321.0
2021-12-06 07:00:00	QQQ	ETF	382.48	382.6	381.25	381.71	249431.0
2021-12-06 08:00:00	QQQ	ETF	382.09	385.1796	381.1696	383.09	392276.0
2021-12-06 09:00:00	QQQ	ETF	383.01	384.25	379.3	381.98	10506886.0
2021-12-06 10:00:00	QQQ	ETF	381.97	384.92	380.37	383.58	13587451.0
2021-12-06 11:00:00	QQQ	ETF	383.57	384.45	381.78	383.2174	7216594.0
2021-12-06 12:00:00	QQQ	ETF	383.22	385.93	382.9	385.92	4372627.0
2021-12-06 13:00:00	QQQ	ETF	385.9301	387.25	385.5	386.98	4276960.0
2021-12-06 14:00:00	QQQ	ETF	387.0101	387.6	385.96	386.1536	3950052.0
2021-12-06 15:00:00	QQQ	ETF	386.14	387.27	385.82	386.3	7539762.0
2021-12-06 16:00:00	QQQ	ETF	386.29	386.39	384.442	386.38	1989648.0
2021-12-06 17:00:00	QQQ	ETF	386.32	386.5	386.2	386.35	120029.0
2021-12-06 18:00:00	QQQ	ETF	386.35	386.66	385.92	386.29	61802.0
2021-12-06 19:00:00	QQQ	ETF	386.27	386.2996	385.9	386.25	60409.0
2021-12-06 04:00:00	IWM	ETF	216.89	217.68	215.89	215.89	46818.0
2021-12-06 05:00:00	IWM	ETF	215.92	216.28	215.17	215.44	17822.0
2021-12-06 06:00:00	IWM	ETF	215.51	216.9	215.51	216.9	76683.0
2021-12-06 07:00:00	IWM	ETF	216.85	216.99	216.03	216.03	94357.0
2021-12-06 08:00:00	IWM	ETF	216.35	217.33	214.71	216.74	127706.0
2021-12-06 09:00:00	IWM	ETF	216.72	217.13	213.71	216.85	4850454.0
2021-12-06 10:00:00	IWM	ETF	216.85	218.46	216.06	218.43	6145617.0
2021-12-06 11:00:00	IWM	ETF	218.42	218.51	216.78	217.6	4614175.0
2021-12-06 12:00:00	IWM	ETF	217.6	218.84	217.36	218.84	2944254.0
2021-12-06 13:00:00	IWM	ETF	218.83	220.48	218.55	220.25	3454057.0
2021-12-06 14:00:00	IWM	ETF	220.25	220.69	219.26	219.49	3465819.0
2021-12-06 15:00:00	IWM	ETF	219.48	220.165	218.835	219.03	5106038.0
2021-12-06 16:00:00	IWM	ETF	219.02	219.44	218.8	219.36	1586989.0
2021-12-06 17:00:00	IWM	ETF	219.49	219.5	219.02	219.25	76212.0
2021-12-06 18:00:00	IWM	ETF	219.33	219.58	219.11	219.24	19302.0
2021-12-06 19:00:00	IWM	ETF	219.18	219.49	218.85	219.44	32023.0
2021-12-06 04:00:00	DIA	ETF	346.21	348.96	346.21	348.0	5617.0
2021-12-06 05:00:00	DIA	ETF	347.7	347.7	346.94	346.94	391.0

> showing 50 of 15,848 rows — these rows as CSV

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