PREVIEW / etf_1hour / 2009-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-20.parquet
  size:    145 KB
  rows:    4,482

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-20 04:00:00	SPY	ETF	109.89	110.0	109.89	110.0	5290.0
2009-11-20 05:00:00	SPY	ETF	109.95	109.95	109.59	109.59	9579.0
2009-11-20 06:00:00	SPY	ETF	109.6	109.65	109.31	109.36	32009.0
2009-11-20 07:00:00	SPY	ETF	109.35	109.39	108.88	109.13	923752.0
2009-11-20 08:00:00	SPY	ETF	109.15	109.95	109.09	109.29	2231144.0
2009-11-20 09:00:00	SPY	ETF	109.29	109.76	109.2	109.43	23007206.0
2009-11-20 10:00:00	SPY	ETF	109.43	109.65	109.13	109.17	21758910.0
2009-11-20 11:00:00	SPY	ETF	109.16	109.35	109.01	109.22	18809375.0
2009-11-20 12:00:00	SPY	ETF	109.22	109.25	109.05	109.12	8956906.0
2009-11-20 13:00:00	SPY	ETF	109.12	109.44	109.1	109.37	9722059.0
2009-11-20 14:00:00	SPY	ETF	109.38	109.57	109.32	109.37	11967695.0
2009-11-20 15:00:00	SPY	ETF	109.36	109.76	109.31	109.52	27083138.0
2009-11-20 16:00:00	SPY	ETF	109.53	109.62	109.11	109.5	9332207.0
2009-11-20 17:00:00	SPY	ETF	109.49	109.53	109.47	109.52	92522.0
2009-11-20 18:00:00	SPY	ETF	109.52	109.52	109.47	109.5	17849.0
2009-11-20 19:00:00	SPY	ETF	109.5	109.53	109.47	109.53	10305.0
2009-11-20 04:00:00	QQQ	ETF	43.66	43.66	43.65	43.65	200.0
2009-11-20 05:00:00	QQQ	ETF	43.59	43.59	43.52	43.52	2500.0
2009-11-20 06:00:00	QQQ	ETF	43.49	43.49	43.41	43.42	18000.0
2009-11-20 07:00:00	QQQ	ETF	43.42	43.42	43.26	43.37	91817.0
2009-11-20 08:00:00	QQQ	ETF	43.38	43.52	43.33	43.45	1149896.0
2009-11-20 09:00:00	QQQ	ETF	43.44	43.55	43.33	43.35	12203915.0
2009-11-20 10:00:00	QQQ	ETF	43.36	43.435	43.28	43.33	12530374.0
2009-11-20 11:00:00	QQQ	ETF	43.3201	43.43	43.28	43.34	6809611.0
2009-11-20 12:00:00	QQQ	ETF	43.35	43.36	43.31	43.33	4388406.0
2009-11-20 13:00:00	QQQ	ETF	43.33	43.46	43.3106	43.45	8491182.0
2009-11-20 14:00:00	QQQ	ETF	43.4499	43.5	43.3913	43.418	6369586.0
2009-11-20 15:00:00	QQQ	ETF	43.41	43.54	43.4	43.45	11772670.0
2009-11-20 16:00:00	QQQ	ETF	43.45	43.47	43.38	43.46	2742716.0
2009-11-20 17:00:00	QQQ	ETF	43.46	43.46	43.38	43.42	68100.0
2009-11-20 18:00:00	QQQ	ETF	43.42	43.44	43.42	43.44	7200.0
2009-11-20 19:00:00	QQQ	ETF	43.42	43.44	43.41	43.43	11920.0
2009-11-20 05:00:00	IWM	ETF	58.45	58.45	58.45	58.45	950.0
2009-11-20 06:00:00	IWM	ETF	58.35	58.35	58.22	58.27	8765.0
2009-11-20 07:00:00	IWM	ETF	58.27	58.27	57.92	58.1	69853.0
2009-11-20 08:00:00	IWM	ETF	58.11	58.39	58.02	58.21	382087.0
2009-11-20 09:00:00	IWM	ETF	58.22	58.8	58.16	58.4099	7927387.0
2009-11-20 10:00:00	IWM	ETF	58.4	58.57	58.18	58.295	6918968.0
2009-11-20 11:00:00	IWM	ETF	58.29	58.435	58.14	58.24	5987901.0
2009-11-20 12:00:00	IWM	ETF	58.249	58.7272	58.09	58.134	3277847.0
2009-11-20 13:00:00	IWM	ETF	58.13	58.35	58.12	58.31	2505816.0
2009-11-20 14:00:00	IWM	ETF	58.31	58.45	58.28	58.36	3431697.0
2009-11-20 15:00:00	IWM	ETF	58.35	58.67	58.25	58.57	7561884.0
2009-11-20 16:00:00	IWM	ETF	58.58	58.62	58.45	58.61	897145.0
2009-11-20 17:00:00	IWM	ETF	58.58	58.58	58.55	58.56	3101.0
2009-11-20 18:00:00	IWM	ETF	58.6	58.63	58.57	58.57	700.0
2009-11-20 06:00:00	DIA	ETF	103.5	103.5	103.5	103.5	100.0
2009-11-20 07:00:00	DIA	ETF	103.1	103.5	102.71	102.9	23934.0
2009-11-20 08:00:00	DIA	ETF	102.8	102.95	102.75	102.88	24563.0
2009-11-20 09:00:00	DIA	ETF	102.89	103.41	102.86	103.22	1671295.0

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

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