PREVIEW / etf_1hour / 2009-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-05.parquet
  size:    131 KB
  rows:    4,095

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-03-05 04:00:00	SPY	ETF	70.73	70.82	70.6	70.82	4924.0
2009-03-05 05:00:00	SPY	ETF	70.88	70.88	70.49	70.49	13513.0
2009-03-05 06:00:00	SPY	ETF	70.43	70.5	69.91	70.27	124445.0
2009-03-05 07:00:00	SPY	ETF	70.27	70.36	69.85	70.1	1778864.0
2009-03-05 08:00:00	SPY	ETF	70.1	70.8	69.68	69.79	8777945.0
2009-03-05 09:00:00	SPY	ETF	69.77	70.75	69.76	70.48	46690930.0
2009-03-05 10:00:00	SPY	ETF	70.49	70.87	69.71	69.76	69266085.0
2009-03-05 11:00:00	SPY	ETF	69.75	69.95	69.01	69.19	57661308.0
2009-03-05 12:00:00	SPY	ETF	69.18	70.11	68.8	69.07	41264318.0
2009-03-05 13:00:00	SPY	ETF	69.07	69.77	68.88	69.1701	55637459.0
2009-03-05 14:00:00	SPY	ETF	69.18	71.73	68.58	68.69	59414425.0
2009-03-05 15:00:00	SPY	ETF	68.69	71.73	68.17	68.77	111411441.0
2009-03-05 16:00:00	SPY	ETF	68.79	71.7308	68.7137	69.2	25645421.0
2009-03-05 17:00:00	SPY	ETF	69.2	69.3	69.17	69.21	388245.0
2009-03-05 18:00:00	SPY	ETF	69.22	69.3	69.05	69.05	187917.0
2009-03-05 19:00:00	SPY	ETF	69.05	69.15	69.03	69.08	192106.0
2009-03-05 04:00:00	QQQ	ETF	27.05	27.09	26.98	27.09	1800.0
2009-03-05 05:00:00	QQQ	ETF	27.05	27.05	27.01	27.01	2365.0
2009-03-05 06:00:00	QQQ	ETF	27.01	27.01	26.84	26.92	7300.0
2009-03-05 07:00:00	QQQ	ETF	26.93	26.96	26.78	26.83	614656.0
2009-03-05 08:00:00	QQQ	ETF	26.91	27.06	26.83	26.92	3611902.0
2009-03-05 09:00:00	QQQ	ETF	26.93	27.24	26.86	27.1	21359862.0
2009-03-05 10:00:00	QQQ	ETF	27.1	27.23	26.79	26.81	26577800.0
2009-03-05 11:00:00	QQQ	ETF	26.8	26.89	26.5801	26.66	18562033.0
2009-03-05 12:00:00	QQQ	ETF	26.66	26.78	26.52	26.63	16432882.0
2009-03-05 13:00:00	QQQ	ETF	26.63	26.84	26.58	26.67	17058623.0
2009-03-05 14:00:00	QQQ	ETF	26.67	26.68	26.46	26.54	24226116.0
2009-03-05 15:00:00	QQQ	ETF	26.54	26.88	26.42	26.511	48989865.0
2009-03-05 16:00:00	QQQ	ETF	26.51	27.3538	26.48	26.65	13197510.0
2009-03-05 17:00:00	QQQ	ETF	26.65	26.73	26.65	26.67	369639.0
2009-03-05 18:00:00	QQQ	ETF	26.68	26.71	26.64	26.65	95158.0
2009-03-05 19:00:00	QQQ	ETF	26.64	26.65	26.58	26.59	83993.0
2009-03-05 06:00:00	IWM	ETF	36.36	36.36	36.18	36.27	4770.0
2009-03-05 07:00:00	IWM	ETF	36.28	36.34	36.1	36.2	33900.0
2009-03-05 08:00:00	IWM	ETF	36.19	36.43	36.11	36.18	486475.0
2009-03-05 09:00:00	IWM	ETF	36.18	36.689	36.16	36.42	7344160.0
2009-03-05 10:00:00	IWM	ETF	36.42	36.57	35.75	35.78	12153954.0
2009-03-05 11:00:00	IWM	ETF	35.79	35.92	35.4	35.54	10947721.0
2009-03-05 12:00:00	IWM	ETF	35.54	35.67	35.4	35.49	4665490.0
2009-03-05 13:00:00	IWM	ETF	35.49	35.76	35.33	35.53	6787720.0
2009-03-05 14:00:00	IWM	ETF	35.53	35.53	35.12	35.15	9438460.0
2009-03-05 15:00:00	IWM	ETF	35.15	35.59	34.92	35.03	25615029.0
2009-03-05 16:00:00	IWM	ETF	35.03	36.4	34.95	35.23	9077137.0
2009-03-05 17:00:00	IWM	ETF	35.24	37.1693	35.2	35.25	1153568.0
2009-03-05 18:00:00	IWM	ETF	35.19	35.19	35.19	35.19	600.0
2009-03-05 19:00:00	IWM	ETF	35.11	35.19	35.1	35.12	1900.0
2009-03-05 04:00:00	DIA	ETF	67.99	67.99	67.99	67.99	435.0
2009-03-05 05:00:00	DIA	ETF	67.99	67.99	67.99	67.99	100.0
2009-03-05 06:00:00	DIA	ETF	67.69	67.69	67.38	67.62	1879.0
2009-03-05 07:00:00	DIA	ETF	67.64	67.7	67.35	67.56	23202.0

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

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