PREVIEW / etf_1hour / 2009-11-11

all etf 1-hour files

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

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-11 04:00:00	SPY	ETF	110.29	110.66	110.24	110.66	3400.0
2009-11-11 05:00:00	SPY	ETF	110.58	110.58	110.42	110.43	2315.0
2009-11-11 06:00:00	SPY	ETF	110.48	110.6	110.41	110.52	23819.0
2009-11-11 07:00:00	SPY	ETF	110.52	110.62	110.39	110.4	551046.0
2009-11-11 08:00:00	SPY	ETF	110.57	110.57	110.33	110.35	1485202.0
2009-11-11 09:00:00	SPY	ETF	110.35	110.46	110.03	110.41	19507036.0
2009-11-11 10:00:00	SPY	ETF	110.4	110.82	109.865	110.06	42332791.0
2009-11-11 11:00:00	SPY	ETF	110.06	110.14	109.63	109.82	30940667.0
2009-11-11 12:00:00	SPY	ETF	109.82	110.24	109.75	109.9601	16124020.0
2009-11-11 13:00:00	SPY	ETF	109.97	110.16	109.62	109.79	16002839.0
2009-11-11 14:00:00	SPY	ETF	109.79	110.15	109.74	110.07	13873012.0
2009-11-11 15:00:00	SPY	ETF	110.07	110.18	109.83	110.13	24004751.0
2009-11-11 16:00:00	SPY	ETF	110.14	110.75	109.8	110.07	3768169.0
2009-11-11 17:00:00	SPY	ETF	110.08	110.18	110.04	110.17	279868.0
2009-11-11 18:00:00	SPY	ETF	110.13	110.17	110.06	110.13	109423.0
2009-11-11 19:00:00	SPY	ETF	110.16	110.28	110.15	110.25	40536.0
2009-11-11 04:00:00	QQQ	ETF	43.84	43.99	43.84	43.99	1220.0
2009-11-11 05:00:00	QQQ	ETF	43.92	43.95	43.92	43.95	5000.0
2009-11-11 06:00:00	QQQ	ETF	43.95	44.0	43.95	44.0	6800.0
2009-11-11 07:00:00	QQQ	ETF	44.0	44.05	43.96	43.97	330147.0
2009-11-11 08:00:00	QQQ	ETF	43.97	43.98	43.93	43.94	906903.0
2009-11-11 09:00:00	QQQ	ETF	43.93	44.03	43.85	44.0	12568171.0
2009-11-11 10:00:00	QQQ	ETF	44.01	44.14	43.78	43.8	17029009.0
2009-11-11 11:00:00	QQQ	ETF	43.8	43.87	43.65	43.73	12681265.0
2009-11-11 12:00:00	QQQ	ETF	43.73	43.88	43.71	43.76	7544876.0
2009-11-11 13:00:00	QQQ	ETF	43.76	43.835	43.61	43.6712	6548686.0
2009-11-11 14:00:00	QQQ	ETF	43.67	43.87	43.6676	43.8276	7313965.0
2009-11-11 15:00:00	QQQ	ETF	43.82	43.9	43.74	43.891	13254688.0
2009-11-11 16:00:00	QQQ	ETF	43.89	44.014	43.82	43.91	5811410.0
2009-11-11 17:00:00	QQQ	ETF	43.91	43.94	43.9	43.92	72281.0
2009-11-11 18:00:00	QQQ	ETF	43.93	43.94	43.9	43.9	14785.0
2009-11-11 19:00:00	QQQ	ETF	43.94	43.97	43.93	43.96	106825.0
2009-11-11 07:00:00	IWM	ETF	59.45	59.51	59.37	59.44	79300.0
2009-11-11 08:00:00	IWM	ETF	59.41	59.47	59.33	59.35	169752.0
2009-11-11 09:00:00	IWM	ETF	59.35	59.44	59.11	59.34	5513492.0
2009-11-11 10:00:00	IWM	ETF	59.34	59.84	59.16	59.23	9553472.0
2009-11-11 11:00:00	IWM	ETF	59.23	59.29	58.89	59.04	9014946.0
2009-11-11 12:00:00	IWM	ETF	59.02	59.32	58.98	59.07	4529067.0
2009-11-11 13:00:00	IWM	ETF	59.08	59.148	58.8	58.91	4836936.0
2009-11-11 14:00:00	IWM	ETF	58.92	59.24	58.89	59.15	4325412.0
2009-11-11 15:00:00	IWM	ETF	59.16	59.37	58.98	59.27	8657754.0
2009-11-11 16:00:00	IWM	ETF	59.27	59.441	58.85	59.26	778531.0
2009-11-11 17:00:00	IWM	ETF	59.28	59.32	59.28	59.32	4183.0
2009-11-11 18:00:00	IWM	ETF	59.23	59.32	59.23	59.26	1300.0
2009-11-11 19:00:00	IWM	ETF	59.26	59.3	59.26	59.3	1500.0
2009-11-11 06:00:00	DIA	ETF	103.37	103.37	103.37	103.37	100.0
2009-11-11 07:00:00	DIA	ETF	103.55	103.59	103.35	103.35	18285.0
2009-11-11 08:00:00	DIA	ETF	103.38	103.43	103.22	103.25	61631.0
2009-11-11 09:00:00	DIA	ETF	103.24	103.34	102.95	103.2885	1128210.0
2009-11-11 10:00:00	DIA	ETF	103.3	103.62	102.85	103.02	2638747.0

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

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