PREVIEW / etf_1hour / 2009-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-13.parquet
  size:    143 KB
  rows:    4,396

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
2009-10-13 04:00:00	SPY	ETF	107.44	107.54	107.42	107.54	6400.0
2009-10-13 05:00:00	SPY	ETF	107.44	107.48	107.3	107.45	15744.0
2009-10-13 06:00:00	SPY	ETF	107.5	107.62	107.5	107.61	52000.0
2009-10-13 07:00:00	SPY	ETF	107.62	107.89	107.61	107.69	460255.0
2009-10-13 08:00:00	SPY	ETF	107.69	107.8	107.42	107.43	2018255.0
2009-10-13 09:00:00	SPY	ETF	107.44	107.56	106.97	107.0317	26478206.0
2009-10-13 10:00:00	SPY	ETF	107.03	107.2	106.76	107.15	28300296.0
2009-10-13 11:00:00	SPY	ETF	107.1551	107.63	106.96	107.58	22189107.0
2009-10-13 12:00:00	SPY	ETF	107.57	107.65	107.34	107.395	13600802.0
2009-10-13 13:00:00	SPY	ETF	107.39	107.7132	107.27	107.43	11168781.0
2009-10-13 14:00:00	SPY	ETF	107.455	107.48	107.09	107.34	15605119.0
2009-10-13 15:00:00	SPY	ETF	107.34	107.65	107.3	107.5	23314669.0
2009-10-13 16:00:00	SPY	ETF	107.52	108.05	106.88	107.92	9757579.0
2009-10-13 17:00:00	SPY	ETF	107.92	108.52	107.7131	108.3	4336690.0
2009-10-13 18:00:00	SPY	ETF	108.3	108.35	108.14	108.15	239932.0
2009-10-13 19:00:00	SPY	ETF	108.12	108.22	108.1	108.18	34225.0
2009-10-13 05:00:00	QQQ	ETF	42.5	42.5	42.45	42.5	4100.0
2009-10-13 06:00:00	QQQ	ETF	42.55	42.57	42.55	42.57	1300.0
2009-10-13 07:00:00	QQQ	ETF	42.58	42.68	42.58	42.63	75687.0
2009-10-13 08:00:00	QQQ	ETF	42.62	42.62	42.46	42.54	381836.0
2009-10-13 09:00:00	QQQ	ETF	42.54	42.69	42.45	42.49	10588914.0
2009-10-13 10:00:00	QQQ	ETF	42.48	42.56	42.37	42.52	11143311.0
2009-10-13 11:00:00	QQQ	ETF	42.511	42.75	42.43	42.7097	7521407.0
2009-10-13 12:00:00	QQQ	ETF	42.71	42.74	42.57	42.6	4906163.0
2009-10-13 13:00:00	QQQ	ETF	42.59	42.62	42.52	42.5774	5061207.0
2009-10-13 14:00:00	QQQ	ETF	42.57	42.59	42.44	42.53	6959475.0
2009-10-13 15:00:00	QQQ	ETF	42.5374	42.66	42.51	42.5876	11340456.0
2009-10-13 16:00:00	QQQ	ETF	42.58	42.99	42.41	42.88	10680966.0
2009-10-13 17:00:00	QQQ	ETF	42.88	42.99	42.86	42.95	1104248.0
2009-10-13 18:00:00	QQQ	ETF	42.95	42.98	42.92	42.94	279264.0
2009-10-13 19:00:00	QQQ	ETF	42.94	42.95	42.92	42.93	55150.0
2009-10-13 07:00:00	IWM	ETF	61.52	61.62	61.47	61.47	33700.0
2009-10-13 08:00:00	IWM	ETF	61.49	61.53	61.19	61.33	66006.0
2009-10-13 09:00:00	IWM	ETF	61.32	61.49	60.871	60.92	4874670.0
2009-10-13 10:00:00	IWM	ETF	60.91	60.99	60.6	60.94	6876592.0
2009-10-13 11:00:00	IWM	ETF	60.94	61.35	60.72	61.28	4046763.0
2009-10-13 12:00:00	IWM	ETF	61.28	61.37	61.1	61.1301	2054872.0
2009-10-13 13:00:00	IWM	ETF	61.135	61.23	60.9	61.03	3689646.0
2009-10-13 14:00:00	IWM	ETF	61.03	61.06	60.78	60.93	5308821.0
2009-10-13 15:00:00	IWM	ETF	60.92	61.19	60.91	61.19	5498271.0
2009-10-13 16:00:00	IWM	ETF	61.19	61.64	61.04	61.6	2702279.0
2009-10-13 17:00:00	IWM	ETF	61.59	61.96	61.56	61.82	135316.0
2009-10-13 18:00:00	IWM	ETF	61.84	61.85	61.73	61.85	3356.0
2009-10-13 19:00:00	IWM	ETF	61.78	61.89	61.73	61.8	8500.0
2009-10-13 07:00:00	DIA	ETF	99.02	99.07	99.02	99.07	4000.0
2009-10-13 08:00:00	DIA	ETF	98.92	98.95	98.67	98.69	13076.0
2009-10-13 09:00:00	DIA	ETF	98.67	98.78	98.3804	98.42	1005578.0
2009-10-13 10:00:00	DIA	ETF	98.41	98.61	98.22	98.58	1080167.0
2009-10-13 11:00:00	DIA	ETF	98.57	99.02	98.44	98.97	920728.0
2009-10-13 12:00:00	DIA	ETF	98.96	99.02	98.77	98.8	490723.0

> showing 50 of 4,396 rows — these rows as CSV

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