PREVIEW / etf_1hour / 2009-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-06.parquet
  size:    132 KB
  rows:    4,110

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-06 04:00:00	SPY	ETF	69.41	69.41	69.41	69.41	300.0
2009-03-06 05:00:00	SPY	ETF	69.28	69.28	68.89	68.89	400.0
2009-03-06 06:00:00	SPY	ETF	68.86	68.9	68.38	68.85	374522.0
2009-03-06 07:00:00	SPY	ETF	68.9	69.03	68.6	68.77	2683684.0
2009-03-06 08:00:00	SPY	ETF	68.85	69.95	68.65	69.69	20861950.0
2009-03-06 09:00:00	SPY	ETF	69.67	70.45	68.69	69.54	70031293.0
2009-03-06 10:00:00	SPY	ETF	69.55	69.73	67.97	68.09	93568921.0
2009-03-06 11:00:00	SPY	ETF	68.09	68.63	67.91	68.32	48405548.0
2009-03-06 12:00:00	SPY	ETF	68.3206	68.79	67.7	68.07	39257872.0
2009-03-06 13:00:00	SPY	ETF	68.07	68.09	67.4	67.7	39188744.0
2009-03-06 14:00:00	SPY	ETF	67.6938	68.17	67.19	67.27	50851305.0
2009-03-06 15:00:00	SPY	ETF	67.27	69.8	67.1	68.84	95988569.0
2009-03-06 16:00:00	SPY	ETF	68.83	70.19	67.5	69.45	18372191.0
2009-03-06 17:00:00	SPY	ETF	69.47	69.49	69.27	69.43	155666.0
2009-03-06 18:00:00	SPY	ETF	69.43	69.45	69.35	69.38	51007.0
2009-03-06 19:00:00	SPY	ETF	69.4	69.46	69.36	69.43	39396.0
2009-03-06 04:00:00	QQQ	ETF	26.73	26.73	26.73	26.73	100.0
2009-03-06 05:00:00	QQQ	ETF	26.51	26.51	26.51	26.51	100.0
2009-03-06 06:00:00	QQQ	ETF	26.51	26.65	26.41	26.65	76100.0
2009-03-06 07:00:00	QQQ	ETF	26.65	26.71	26.44	26.51	984578.0
2009-03-06 08:00:00	QQQ	ETF	26.52	26.84	26.46	26.74	8199892.0
2009-03-06 09:00:00	QQQ	ETF	26.75	26.81	26.47	26.49	21054483.0
2009-03-06 10:00:00	QQQ	ETF	26.49	26.6	25.79	25.84	47774515.0
2009-03-06 11:00:00	QQQ	ETF	25.86	26.02	25.73	25.95	24913662.0
2009-03-06 12:00:00	QQQ	ETF	25.95	26.13	25.84	26.0199	20442292.0
2009-03-06 13:00:00	QQQ	ETF	26.02	26.02	25.76	25.93	18092114.0
2009-03-06 14:00:00	QQQ	ETF	25.93	26.08	25.74	25.77	27547313.0
2009-03-06 15:00:00	QQQ	ETF	25.77	26.28	25.71	26.28	37469518.0
2009-03-06 16:00:00	QQQ	ETF	26.28	26.7	25.9901	26.45	5226681.0
2009-03-06 17:00:00	QQQ	ETF	26.45	26.55	26.43	26.5	114618.0
2009-03-06 18:00:00	QQQ	ETF	26.5	26.54	26.45	26.49	35007.0
2009-03-06 19:00:00	QQQ	ETF	26.5	26.52	26.48	26.5	17340.0
2009-03-06 05:00:00	IWM	ETF	35.12	35.12	35.12	35.12	100.0
2009-03-06 06:00:00	IWM	ETF	34.91	35.11	34.82	35.11	2800.0
2009-03-06 07:00:00	IWM	ETF	35.21	35.21	35.12	35.21	15980.0
2009-03-06 08:00:00	IWM	ETF	35.17	35.74	35.16	35.61	1286215.0
2009-03-06 09:00:00	IWM	ETF	35.61	35.88	35.13	35.4	7427797.0
2009-03-06 10:00:00	IWM	ETF	35.39	35.49	34.58	34.64	11409868.0
2009-03-06 11:00:00	IWM	ETF	34.64	35.0	34.51	34.882	9418908.0
2009-03-06 12:00:00	IWM	ETF	34.86	35.08	34.63	34.84	6107033.0
2009-03-06 13:00:00	IWM	ETF	34.83	34.85	34.43	34.59	6760590.0
2009-03-06 14:00:00	IWM	ETF	34.59	34.82	34.36	34.38	8021861.0
2009-03-06 15:00:00	IWM	ETF	34.38	35.25	34.32	35.22	17971767.0
2009-03-06 16:00:00	IWM	ETF	35.22	35.57	34.5	35.53	6457611.0
2009-03-06 06:00:00	DIA	ETF	65.96	65.96	65.96	65.96	200.0
2009-03-06 07:00:00	DIA	ETF	66.2	66.23	65.92	65.92	4473.0
2009-03-06 08:00:00	DIA	ETF	66.07	67.05	66.04	66.85	178195.0
2009-03-06 09:00:00	DIA	ETF	66.89	67.63	66.41	66.8	4957622.0
2009-03-06 10:00:00	DIA	ETF	66.81	66.97	65.54	65.64	6704705.0
2009-03-06 11:00:00	DIA	ETF	65.67	66.06	65.5	65.82	3738824.0

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

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