PREVIEW / etf_1hour / 2010-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-14.parquet
  size:    149 KB
  rows:    4,653

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
2010-01-14 05:00:00	SPY	ETF	114.67	114.67	114.59	114.6	2900.0
2010-01-14 06:00:00	SPY	ETF	114.55	114.6	114.53	114.6	1300.0
2010-01-14 07:00:00	SPY	ETF	114.61	114.64	114.41	114.63	152990.0
2010-01-14 08:00:00	SPY	ETF	114.62	114.79	114.27	114.31	3478747.0
2010-01-14 09:00:00	SPY	ETF	114.32	114.71	114.31	114.62	14565659.0
2010-01-14 10:00:00	SPY	ETF	114.61	114.99	114.56	114.57	20709008.0
2010-01-14 11:00:00	SPY	ETF	114.58	114.78	114.44	114.63	14163144.0
2010-01-14 12:00:00	SPY	ETF	114.63	114.83	114.61	114.76	7389248.0
2010-01-14 13:00:00	SPY	ETF	114.76	114.92	114.71	114.85	8558570.0
2010-01-14 14:00:00	SPY	ETF	114.85	115.01	114.81	114.94	12546722.0
2010-01-14 15:00:00	SPY	ETF	114.9417	115.14	114.85	114.92	25422669.0
2010-01-14 16:00:00	SPY	ETF	114.92	115.25	114.49	115.13	8067522.0
2010-01-14 17:00:00	SPY	ETF	115.1	115.15	115.07	115.08	139572.0
2010-01-14 18:00:00	SPY	ETF	115.08	115.08	114.91	114.95	109385.0
2010-01-14 19:00:00	SPY	ETF	114.94	115.05	114.91	115.0	27414.0
2010-01-14 04:00:00	QQQ	ETF	46.35	46.35	46.35	46.35	160.0
2010-01-14 06:00:00	QQQ	ETF	46.26	46.28	46.26	46.28	21000.0
2010-01-14 07:00:00	QQQ	ETF	46.3	46.31	46.23	46.31	53657.0
2010-01-14 08:00:00	QQQ	ETF	46.31	46.38	46.17	46.2	1490011.0
2010-01-14 09:00:00	QQQ	ETF	46.2	46.41	46.19	46.322	11228629.0
2010-01-14 10:00:00	QQQ	ETF	46.33	46.5	46.26	46.28	13999974.0
2010-01-14 11:00:00	QQQ	ETF	46.27	46.38	46.22	46.29	7794483.0
2010-01-14 12:00:00	QQQ	ETF	46.3	46.43	46.29	46.375	5199243.0
2010-01-14 13:00:00	QQQ	ETF	46.38	46.41	46.32	46.3699	5264676.0
2010-01-14 14:00:00	QQQ	ETF	46.365	46.46	46.2898	46.44	6807425.0
2010-01-14 15:00:00	QQQ	ETF	46.44	46.52	46.37	46.38	13673536.0
2010-01-14 16:00:00	QQQ	ETF	46.38	46.78	46.2898	46.55	8021965.0
2010-01-14 17:00:00	QQQ	ETF	46.56	46.59	46.4	46.5	474662.0
2010-01-14 18:00:00	QQQ	ETF	46.49	46.53	46.26	46.4	930609.0
2010-01-14 19:00:00	QQQ	ETF	46.4	46.46	46.4	46.46	67506.0
2010-01-14 07:00:00	IWM	ETF	64.21	64.27	64.14	64.26	7400.0
2010-01-14 08:00:00	IWM	ETF	64.28	64.38	64.04	64.04	267197.0
2010-01-14 09:00:00	IWM	ETF	64.05	64.46	64.02	64.33	4521969.0
2010-01-14 10:00:00	IWM	ETF	64.33	64.71	64.27	64.33	8519307.0
2010-01-14 11:00:00	IWM	ETF	64.32	64.575	64.27	64.47	3816927.0
2010-01-14 12:00:00	IWM	ETF	64.47	64.58	64.38	64.445	2529895.0
2010-01-14 13:00:00	IWM	ETF	64.43	64.57	64.4	64.48	4681097.0
2010-01-14 14:00:00	IWM	ETF	64.48	64.7399	64.44	64.69	4479930.0
2010-01-14 15:00:00	IWM	ETF	64.7	64.82	64.59	64.6	7186998.0
2010-01-14 16:00:00	IWM	ETF	64.6	64.87	64.3175	64.3175	952401.0
2010-01-14 17:00:00	IWM	ETF	64.83	64.87	64.78	64.81	55852.0
2010-01-14 18:00:00	IWM	ETF	64.8	64.84	64.79	64.79	8321.0
2010-01-14 19:00:00	IWM	ETF	64.77	64.77	64.77	64.77	1000.0
2010-01-14 08:00:00	DIA	ETF	106.86	106.91	106.49	106.5	14225.0
2010-01-14 09:00:00	DIA	ETF	106.49	106.84	106.49	106.78	889530.0
2010-01-14 10:00:00	DIA	ETF	106.78	107.04	106.73	106.74	1483606.0
2010-01-14 11:00:00	DIA	ETF	106.75	106.94	106.66	106.83	1343236.0
2010-01-14 12:00:00	DIA	ETF	106.82	106.99	106.8	106.95	650942.0
2010-01-14 13:00:00	DIA	ETF	106.95	107.06	106.89	106.94	647322.0
2010-01-14 14:00:00	DIA	ETF	106.96	107.11	106.92	107.02	652368.0

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

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