PREVIEW / etf_1hour / 2009-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-19.parquet
  size:    147 KB
  rows:    4,547

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-11-19 04:00:00	SPY	ETF	110.76	110.76	110.56	110.64	3395.0
2009-11-19 05:00:00	SPY	ETF	110.59	110.74	110.57	110.7	800.0
2009-11-19 06:00:00	SPY	ETF	110.71	110.71	110.32	110.33	148653.0
2009-11-19 07:00:00	SPY	ETF	110.36	110.5	110.25	110.5	490584.0
2009-11-19 08:00:00	SPY	ETF	110.48	110.92	110.32	110.54	3432763.0
2009-11-19 09:00:00	SPY	ETF	110.54	110.63	109.27	109.5	39877014.0
2009-11-19 10:00:00	SPY	ETF	109.5	109.75	109.2	109.26	40685637.0
2009-11-19 11:00:00	SPY	ETF	109.26	109.55	109.13	109.5184	17993259.0
2009-11-19 12:00:00	SPY	ETF	109.52	111.3059	109.4101	109.52	16153485.0
2009-11-19 13:00:00	SPY	ETF	109.52	109.65	109.31	109.58	11349378.0
2009-11-19 14:00:00	SPY	ETF	109.57	109.82	109.34	109.675	17029999.0
2009-11-19 15:00:00	SPY	ETF	109.67	110.0	109.51	109.8	31833862.0
2009-11-19 16:00:00	SPY	ETF	109.8	111.306	109.42	109.74	26921436.0
2009-11-19 17:00:00	SPY	ETF	109.72	109.78	109.71	109.71	25956.0
2009-11-19 18:00:00	SPY	ETF	109.7	109.73	109.61	109.65	52212.0
2009-11-19 19:00:00	SPY	ETF	109.65	109.88	109.65	109.82	42330.0
2009-11-19 04:00:00	QQQ	ETF	44.15	44.15	44.15	44.15	150.0
2009-11-19 05:00:00	QQQ	ETF	44.12	44.12	44.11	44.11	7000.0
2009-11-19 06:00:00	QQQ	ETF	44.13	44.13	43.96	44.0	16413.0
2009-11-19 07:00:00	QQQ	ETF	44.0	44.04	43.97	44.04	177965.0
2009-11-19 08:00:00	QQQ	ETF	44.02	44.12	44.01	44.04	1867430.0
2009-11-19 09:00:00	QQQ	ETF	44.04	44.11	43.45	43.55	24451791.0
2009-11-19 10:00:00	QQQ	ETF	43.55	43.64	43.4	43.412	25024354.0
2009-11-19 11:00:00	QQQ	ETF	43.41	43.53	43.35	43.53	10957101.0
2009-11-19 12:00:00	QQQ	ETF	43.5201	43.62	43.47	43.52	7661875.0
2009-11-19 13:00:00	QQQ	ETF	43.51	43.61	43.45	43.58	5881179.0
2009-11-19 14:00:00	QQQ	ETF	43.58	43.67	43.48	43.61	8478888.0
2009-11-19 15:00:00	QQQ	ETF	43.61	43.73	43.58	43.669	14655631.0
2009-11-19 16:00:00	QQQ	ETF	43.66	43.69	43.55	43.57	7648011.0
2009-11-19 17:00:00	QQQ	ETF	43.58	43.6	43.57	43.58	37131.0
2009-11-19 18:00:00	QQQ	ETF	43.57	43.57	43.53	43.55	100879.0
2009-11-19 19:00:00	QQQ	ETF	43.54	43.62	43.54	43.6	39589.0
2009-11-19 06:00:00	IWM	ETF	59.43	59.52	59.43	59.52	525.0
2009-11-19 07:00:00	IWM	ETF	59.49	59.6	59.4	59.56	40109.0
2009-11-19 08:00:00	IWM	ETF	59.54	59.66	59.47	59.57	510819.0
2009-11-19 09:00:00	IWM	ETF	59.57	59.66	58.591	58.62	19275386.0
2009-11-19 10:00:00	IWM	ETF	58.62	58.81	58.26	58.36	17879078.0
2009-11-19 11:00:00	IWM	ETF	58.35	58.59	58.19	58.58	6892828.0
2009-11-19 12:00:00	IWM	ETF	58.58	58.73	58.45	58.56	4181277.0
2009-11-19 13:00:00	IWM	ETF	58.56	58.66	58.44	58.57	3211800.0
2009-11-19 14:00:00	IWM	ETF	58.57	58.72	58.4	58.65	3795386.0
2009-11-19 15:00:00	IWM	ETF	58.65	58.85	58.55	58.61	8817433.0
2009-11-19 16:00:00	IWM	ETF	58.61	60.1061	58.5	58.61	2819947.0
2009-11-19 17:00:00	IWM	ETF	58.6	58.63	58.54	58.56	11536.0
2009-11-19 18:00:00	IWM	ETF	58.52	58.58	58.46	58.46	5600.0
2009-11-19 19:00:00	IWM	ETF	58.53	58.53	58.51	58.52	3300.0
2009-11-19 07:00:00	DIA	ETF	103.8	103.99	103.8	103.99	4900.0
2009-11-19 08:00:00	DIA	ETF	103.9	104.09	103.88	104.07	77809.0
2009-11-19 09:00:00	DIA	ETF	104.08	104.14	102.99	103.19	3081770.0
2009-11-19 10:00:00	DIA	ETF	103.22	103.36	102.9	102.9601	2804002.0

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

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