PREVIEW / etf_1hour / 2010-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-30.parquet
  size:    157 KB
  rows:    4,836

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-07-30 04:00:00	SPY	ETF	109.94	109.97	109.86	109.88	2100.0
2010-07-30 05:00:00	SPY	ETF	109.89	109.89	109.6	109.6	4644.0
2010-07-30 06:00:00	SPY	ETF	109.6	109.86	109.6	109.81	27100.0
2010-07-30 07:00:00	SPY	ETF	109.85	109.85	109.68	109.75	144924.0
2010-07-30 08:00:00	SPY	ETF	109.75	109.76	108.89	109.1	6556139.0
2010-07-30 09:00:00	SPY	ETF	109.1	109.84	108.98	109.66	43472953.0
2010-07-30 10:00:00	SPY	ETF	109.67	110.64	109.64	110.37	36087931.0
2010-07-30 11:00:00	SPY	ETF	110.37	110.56	109.97	110.27	17745381.0
2010-07-30 12:00:00	SPY	ETF	110.27	110.34	110.01	110.2499	10230643.0
2010-07-30 13:00:00	SPY	ETF	110.245	110.31	109.56	109.61	16773466.0
2010-07-30 14:00:00	SPY	ETF	109.6	110.3	109.57	110.04	23917231.0
2010-07-30 15:00:00	SPY	ETF	110.04	110.86	109.96	110.32	49223193.0
2010-07-30 16:00:00	SPY	ETF	110.32	110.56	109.1096	110.48	13321685.0
2010-07-30 17:00:00	SPY	ETF	110.45	110.61	110.42	110.55	312021.0
2010-07-30 18:00:00	SPY	ETF	110.55	110.55	110.27	110.41	157345.0
2010-07-30 19:00:00	SPY	ETF	110.43	110.46	110.4	110.43	29762.0
2010-07-30 04:00:00	QQQ	ETF	45.59	45.59	45.5	45.5	1188.0
2010-07-30 05:00:00	QQQ	ETF	45.5	45.5	45.5	45.5	100.0
2010-07-30 06:00:00	QQQ	ETF	45.58	45.58	45.57	45.57	366.0
2010-07-30 07:00:00	QQQ	ETF	45.58	45.58	45.5	45.54	19277.0
2010-07-30 08:00:00	QQQ	ETF	45.54	45.87	45.14	45.25	785531.0
2010-07-30 09:00:00	QQQ	ETF	45.25	45.39	45.07	45.32	22207517.0
2010-07-30 10:00:00	QQQ	ETF	45.32	45.9	45.3	45.77	19802190.0
2010-07-30 11:00:00	QQQ	ETF	45.77	45.83	45.61	45.77	8307303.0
2010-07-30 12:00:00	QQQ	ETF	45.77	45.84	45.66	45.81	4030801.0
2010-07-30 13:00:00	QQQ	ETF	45.82	45.85	45.5	45.52	3770476.0
2010-07-30 14:00:00	QQQ	ETF	45.51	45.81	45.48	45.71	6968659.0
2010-07-30 15:00:00	QQQ	ETF	45.71	46.09	45.67	45.83	19814210.0
2010-07-30 16:00:00	QQQ	ETF	45.83	46.0099	45.7288	45.84	5123549.0
2010-07-30 17:00:00	QQQ	ETF	45.88	45.94	45.85	45.92	317285.0
2010-07-30 18:00:00	QQQ	ETF	45.92	45.92	45.84	45.84	4550.0
2010-07-30 19:00:00	QQQ	ETF	45.87	45.9	45.85	45.88	8714.0
2010-07-30 04:00:00	IWM	ETF	64.94	64.94	64.77	64.77	200.0
2010-07-30 05:00:00	IWM	ETF	64.59	64.59	64.59	64.59	100.0
2010-07-30 06:00:00	IWM	ETF	64.69	64.79	64.69	64.79	1000.0
2010-07-30 07:00:00	IWM	ETF	64.73	64.73	64.6	64.65	11421.0
2010-07-30 08:00:00	IWM	ETF	64.66	65.1	63.9	63.99	740671.0
2010-07-30 09:00:00	IWM	ETF	64.0	64.66	63.82	64.53	10333282.0
2010-07-30 10:00:00	IWM	ETF	64.53	65.61	64.5	65.448	11382915.0
2010-07-30 11:00:00	IWM	ETF	65.44	65.54	65.04	65.3401	5778677.0
2010-07-30 12:00:00	IWM	ETF	65.35	65.41	65.15	65.25	3260068.0
2010-07-30 13:00:00	IWM	ETF	65.24	65.28	64.73	64.77	4801156.0
2010-07-30 14:00:00	IWM	ETF	64.78	65.19	64.74	65.05	4076883.0
2010-07-30 15:00:00	IWM	ETF	65.05	65.49	64.93	65.04	16272607.0
2010-07-30 16:00:00	IWM	ETF	65.04	65.3603	64.96	65.08	4363126.0
2010-07-30 17:00:00	IWM	ETF	65.06	65.11	65.06	65.07	3700.0
2010-07-30 18:00:00	IWM	ETF	65.07	65.07	65.03	65.05	2300.0
2010-07-30 19:00:00	IWM	ETF	65.0	65.0	65.0	65.0	184.0
2010-07-30 06:00:00	DIA	ETF	104.41	104.41	104.41	104.41	400.0
2010-07-30 07:00:00	DIA	ETF	104.32	104.32	104.29	104.29	1600.0

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

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