PREVIEW / etf_1hour / 2022-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-07.parquet
  size:    485 KB
  rows:    17,687

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
2022-03-07 04:00:00	SPY	ETF	425.95	427.85	424.98	425.85	133989.0
2022-03-07 05:00:00	SPY	ETF	425.98	426.49	425.22	425.22	65639.0
2022-03-07 06:00:00	SPY	ETF	425.29	427.34	424.25	427.16	156094.0
2022-03-07 07:00:00	SPY	ETF	427.24	430.57	427.18	428.76	968778.0
2022-03-07 08:00:00	SPY	ETF	427.955	432.424	423.54	430.88	1408347.0
2022-03-07 09:00:00	SPY	ETF	430.91	432.2	427.81	427.8267	9761421.0
2022-03-07 10:00:00	SPY	ETF	427.8	428.72	425.05	425.5501	12650441.0
2022-03-07 11:00:00	SPY	ETF	425.56	427.22	424.05	424.17	10302531.0
2022-03-07 12:00:00	SPY	ETF	424.16	424.46	422.2	423.02	12482151.0
2022-03-07 13:00:00	SPY	ETF	423.01	424.34	422.04	422.6602	9124273.0
2022-03-07 14:00:00	SPY	ETF	422.66	423.93	421.32	421.7599	9934604.0
2022-03-07 15:00:00	SPY	ETF	421.74	422.06	419.36	419.46	25914579.0
2022-03-07 16:00:00	SPY	ETF	419.47	419.77	418.2	418.34	6850847.0
2022-03-07 17:00:00	SPY	ETF	418.35	418.45	418.0	418.39	160880.0
2022-03-07 18:00:00	SPY	ETF	418.16	418.9	417.89	418.3	157892.0
2022-03-07 19:00:00	SPY	ETF	418.5	419.35	418.25	419.04	296955.0
2022-03-07 04:00:00	QQQ	ETF	332.92	332.92	331.03	331.57	199059.0
2022-03-07 05:00:00	QQQ	ETF	331.8	332.41	331.44	331.44	50510.0
2022-03-07 06:00:00	QQQ	ETF	331.46	332.96	330.97	332.94	128062.0
2022-03-07 07:00:00	QQQ	ETF	332.91	335.92	332.91	334.33	909198.0
2022-03-07 08:00:00	QQQ	ETF	332.96	336.5	330.8	336.2	687039.0
2022-03-07 09:00:00	QQQ	ETF	336.26	338.48	333.42	333.43	9412991.0
2022-03-07 10:00:00	QQQ	ETF	333.44	333.92	330.19	330.75	11912336.0
2022-03-07 11:00:00	QQQ	ETF	330.75	332.72	330.45	330.6	8229348.0
2022-03-07 12:00:00	QQQ	ETF	330.61	331.36	329.08	329.7	8328992.0
2022-03-07 13:00:00	QQQ	ETF	329.68	330.74	328.27	328.66	7153754.0
2022-03-07 14:00:00	QQQ	ETF	328.6325	329.76	326.971	327.25	6710122.0
2022-03-07 15:00:00	QQQ	ETF	327.26	327.575	324.65	324.83	13792148.0
2022-03-07 16:00:00	QQQ	ETF	324.82	325.03	323.5	323.65	2510181.0
2022-03-07 17:00:00	QQQ	ETF	323.79	323.8	323.49	323.55	104695.0
2022-03-07 18:00:00	QQQ	ETF	323.58	324.04	323.25	323.61	197798.0
2022-03-07 19:00:00	QQQ	ETF	323.7	324.6	323.5	324.05	258484.0
2022-03-07 04:00:00	IWM	ETF	195.0	195.56	194.5	195.1	39825.0
2022-03-07 05:00:00	IWM	ETF	195.12	195.42	194.72	195.0	52092.0
2022-03-07 06:00:00	IWM	ETF	194.69	195.62	194.42	195.62	106653.0
2022-03-07 07:00:00	IWM	ETF	195.74	198.11	195.73	197.31	707819.0
2022-03-07 08:00:00	IWM	ETF	197.73	198.67	194.6196	198.4	628510.0
2022-03-07 09:00:00	IWM	ETF	198.38	199.9	197.52	198.25	4633526.0
2022-03-07 10:00:00	IWM	ETF	198.23	199.41	196.69	196.93	4406755.0
2022-03-07 11:00:00	IWM	ETF	196.93	198.19	195.93	196.03	3450404.0
2022-03-07 12:00:00	IWM	ETF	196.02	196.6	195.18	195.76	3756060.0
2022-03-07 13:00:00	IWM	ETF	195.72	196.33	195.03	195.03	2830852.0
2022-03-07 14:00:00	IWM	ETF	195.04	195.9	194.57	194.71	3078690.0
2022-03-07 15:00:00	IWM	ETF	194.7	195.2925	193.68	193.81	5867184.0
2022-03-07 16:00:00	IWM	ETF	193.72	193.95	193.16	193.42	2183682.0
2022-03-07 17:00:00	IWM	ETF	193.45	193.63	193.12	193.33	25312.0
2022-03-07 18:00:00	IWM	ETF	193.33	193.79	192.96	193.41	94011.0
2022-03-07 19:00:00	IWM	ETF	193.41	193.98	193.37	193.71	104042.0
2022-03-07 04:00:00	DIA	ETF	332.16	332.32	331.69	331.73	2245.0
2022-03-07 05:00:00	DIA	ETF	331.82	331.9	331.29	331.9	1600.0

> showing 50 of 17,687 rows — these rows as CSV

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