PREVIEW / etf_1hour / 2010-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-24.parquet
  size:    150 KB
  rows:    4,667

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-02-24 04:00:00	SPY	ETF	109.86	109.91	109.77	109.91	15845.0
2010-02-24 05:00:00	SPY	ETF	109.99	110.08	109.94	110.08	27600.0
2010-02-24 06:00:00	SPY	ETF	110.04	110.31	109.95	110.29	113530.0
2010-02-24 07:00:00	SPY	ETF	110.21	110.42	110.17	110.34	311821.0
2010-02-24 08:00:00	SPY	ETF	110.33	110.35	109.84	110.27	1135221.0
2010-02-24 09:00:00	SPY	ETF	110.28	110.66	110.11	110.51	19101772.0
2010-02-24 10:00:00	SPY	ETF	110.51	110.91	109.86	110.75	53660313.0
2010-02-24 11:00:00	SPY	ETF	110.75	110.96	110.53	110.7	20635249.0
2010-02-24 12:00:00	SPY	ETF	110.7	110.86	110.58	110.68	10918392.0
2010-02-24 13:00:00	SPY	ETF	110.68	111.0	110.595	110.86	12668452.0
2010-02-24 14:00:00	SPY	ETF	110.86	110.87	110.37	110.5	18767823.0
2010-02-24 15:00:00	SPY	ETF	110.49	110.89	110.47	110.82	27544289.0
2010-02-24 16:00:00	SPY	ETF	110.82	110.86	109.7966	110.73	10366821.0
2010-02-24 17:00:00	SPY	ETF	110.73	110.77	109.7965	110.74	535069.0
2010-02-24 18:00:00	SPY	ETF	110.75	110.8	110.71	110.74	72995.0
2010-02-24 19:00:00	SPY	ETF	110.73	110.8	110.72	110.79	106850.0
2010-02-24 04:00:00	QQQ	ETF	44.26	44.28	44.26	44.28	8000.0
2010-02-24 05:00:00	QQQ	ETF	44.3	44.36	44.3	44.3	16100.0
2010-02-24 06:00:00	QQQ	ETF	44.32	44.44	44.32	44.44	6300.0
2010-02-24 07:00:00	QQQ	ETF	44.43	44.48	44.41	44.45	247224.0
2010-02-24 08:00:00	QQQ	ETF	44.45	44.46	44.39	44.44	522564.0
2010-02-24 09:00:00	QQQ	ETF	44.44	44.65	44.38	44.59	11898754.0
2010-02-24 10:00:00	QQQ	ETF	44.58	44.79	44.32	44.7577	27133941.0
2010-02-24 11:00:00	QQQ	ETF	44.7	44.75	44.56	44.63	8238135.0
2010-02-24 12:00:00	QQQ	ETF	44.6325	44.71	44.59	44.64	3703841.0
2010-02-24 13:00:00	QQQ	ETF	44.642	44.75	44.62	44.7	4755029.0
2010-02-24 14:00:00	QQQ	ETF	44.7007	44.71	44.46	44.4701	7392462.0
2010-02-24 15:00:00	QQQ	ETF	44.47	44.63	44.42	44.6	9028393.0
2010-02-24 16:00:00	QQQ	ETF	44.6	44.65	44.151	44.62	12678498.0
2010-02-24 17:00:00	QQQ	ETF	44.62	44.63	44.452	44.6	221262.0
2010-02-24 18:00:00	QQQ	ETF	44.6	44.63	44.6	44.62	110054.0
2010-02-24 19:00:00	QQQ	ETF	44.63	44.63	44.58	44.58	73225.0
2010-02-24 05:00:00	IWM	ETF	62.56	62.56	62.56	62.56	1000.0
2010-02-24 06:00:00	IWM	ETF	62.61	62.61	62.61	62.61	2000.0
2010-02-24 07:00:00	IWM	ETF	62.75	62.83	62.7	62.8	35829.0
2010-02-24 08:00:00	IWM	ETF	62.46	62.89	62.46	62.82	63734.0
2010-02-24 09:00:00	IWM	ETF	62.8	63.11	62.66	63.01	6336761.0
2010-02-24 10:00:00	IWM	ETF	63.02	63.35	62.55	63.17	12635427.0
2010-02-24 11:00:00	IWM	ETF	63.17	63.27	63.0	63.08	4482387.0
2010-02-24 12:00:00	IWM	ETF	63.08	63.15	62.95	63.12	2449149.0
2010-02-24 13:00:00	IWM	ETF	63.12	63.25	63.08	63.23	5105529.0
2010-02-24 14:00:00	IWM	ETF	63.23	63.24	62.88	62.92	5303246.0
2010-02-24 15:00:00	IWM	ETF	62.9201	63.1	62.8599	63.03	8760702.0
2010-02-24 16:00:00	IWM	ETF	63.03	63.07	62.87	62.87	3056892.0
2010-02-24 17:00:00	IWM	ETF	62.91	62.95	62.91	62.91	4914.0
2010-02-24 06:00:00	DIA	ETF	103.21	103.21	103.21	103.21	100.0
2010-02-24 07:00:00	DIA	ETF	103.2	103.34	103.2	103.34	400.0
2010-02-24 08:00:00	DIA	ETF	103.36	103.36	103.25	103.33	54375.0
2010-02-24 09:00:00	DIA	ETF	103.26	103.61	103.17	103.5	1146899.0
2010-02-24 10:00:00	DIA	ETF	103.5	103.95	102.99	103.83	3478536.0

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

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