PREVIEW / etf_1hour / 2010-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-14.parquet
  size:    158 KB
  rows:    4,839

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-14 04:00:00	SPY	ETF	110.2	110.2	110.16	110.16	1200.0
2010-07-14 05:00:00	SPY	ETF	110.18	110.18	109.85	109.85	20450.0
2010-07-14 06:00:00	SPY	ETF	109.8	109.98	109.8	109.82	59800.0
2010-07-14 07:00:00	SPY	ETF	109.83	109.89	109.65	109.77	413774.0
2010-07-14 08:00:00	SPY	ETF	109.78	109.835	109.39	109.4	3393815.0
2010-07-14 09:00:00	SPY	ETF	109.4	109.47	109.09	109.19	23564009.0
2010-07-14 10:00:00	SPY	ETF	109.2	109.67	108.96	109.6	26258405.0
2010-07-14 11:00:00	SPY	ETF	109.59	110.08	109.5	109.89	19645806.0
2010-07-14 12:00:00	SPY	ETF	109.89	110.0	109.67	109.7201	11195311.0
2010-07-14 13:00:00	SPY	ETF	109.7272	109.83	109.35	109.44	13487607.0
2010-07-14 14:00:00	SPY	ETF	109.45	109.46	108.86	109.29	33308296.0
2010-07-14 15:00:00	SPY	ETF	109.29	109.69	109.1	109.66	40776196.0
2010-07-14 16:00:00	SPY	ETF	109.66	109.945	109.035	109.68	10301957.0
2010-07-14 17:00:00	SPY	ETF	109.65	109.71	109.62	109.63	119015.0
2010-07-14 18:00:00	SPY	ETF	109.65	109.75	109.65	109.7	81621.0
2010-07-14 19:00:00	SPY	ETF	109.69	109.7	109.64	109.64	22870.0
2010-07-14 04:00:00	QQQ	ETF	45.81	45.83	45.77	45.78	20560.0
2010-07-14 05:00:00	QQQ	ETF	45.7	45.7	45.7	45.7	2800.0
2010-07-14 06:00:00	QQQ	ETF	45.7	45.71	45.68	45.71	1200.0
2010-07-14 07:00:00	QQQ	ETF	45.71	45.75	45.62	45.68	470894.0
2010-07-14 08:00:00	QQQ	ETF	45.69	45.71	45.47	45.47	851205.0
2010-07-14 09:00:00	QQQ	ETF	45.47	45.58	45.36	45.399	12609509.0
2010-07-14 10:00:00	QQQ	ETF	45.4	45.61	45.29	45.52	16736501.0
2010-07-14 11:00:00	QQQ	ETF	45.52	45.81	45.46	45.76	10911031.0
2010-07-14 12:00:00	QQQ	ETF	45.76	45.78	45.66	45.6799	5242231.0
2010-07-14 13:00:00	QQQ	ETF	45.67	45.7	45.4	45.47	7665477.0
2010-07-14 14:00:00	QQQ	ETF	45.46	45.5	45.24	45.49	15050681.0
2010-07-14 15:00:00	QQQ	ETF	45.49	45.6	45.34	45.55	12563530.0
2010-07-14 16:00:00	QQQ	ETF	45.54	45.7467	45.3094	45.58	2030322.0
2010-07-14 17:00:00	QQQ	ETF	45.57	45.61	45.56	45.6	21903.0
2010-07-14 18:00:00	QQQ	ETF	45.6	45.62	45.59	45.6	9724.0
2010-07-14 19:00:00	QQQ	ETF	45.6	45.6	45.55	45.55	10090.0
2010-07-14 04:00:00	IWM	ETF	64.51	64.51	64.51	64.51	450.0
2010-07-14 05:00:00	IWM	ETF	64.44	64.44	64.3	64.3	8300.0
2010-07-14 06:00:00	IWM	ETF	64.37	64.37	64.26	64.27	17100.0
2010-07-14 07:00:00	IWM	ETF	64.25	64.33	64.19	64.26	56000.0
2010-07-14 08:00:00	IWM	ETF	64.25	64.33	63.97	63.98	532827.0
2010-07-14 09:00:00	IWM	ETF	63.98	64.12	63.65	63.74	5855939.0
2010-07-14 10:00:00	IWM	ETF	63.75	64.07	63.56	63.98	6681806.0
2010-07-14 11:00:00	IWM	ETF	63.98	64.39	63.93	64.27	5454014.0
2010-07-14 12:00:00	IWM	ETF	64.26	64.369	64.14	64.175	3224550.0
2010-07-14 13:00:00	IWM	ETF	64.18	64.26	63.87	63.95	4298367.0
2010-07-14 14:00:00	IWM	ETF	63.94	63.97	63.47	63.77	8602546.0
2010-07-14 15:00:00	IWM	ETF	63.77	64.05	63.64	63.98	10002303.0
2010-07-14 16:00:00	IWM	ETF	63.97	64.1	63.635	64.09	5876641.0
2010-07-14 17:00:00	IWM	ETF	64.07	64.12	63.99	63.99	11848.0
2010-07-14 18:00:00	IWM	ETF	64.05	64.08	63.95	64.08	2900.0
2010-07-14 19:00:00	IWM	ETF	63.95	64.04	63.95	63.96	1400.0
2010-07-14 05:00:00	DIA	ETF	103.68	103.68	103.68	103.68	300.0
2010-07-14 06:00:00	DIA	ETF	103.69	103.89	103.69	103.76	20500.0

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

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