PREVIEW / etf_1hour / 2010-02-03

all etf 1-hour files

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

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-03 04:00:00	SPY	ETF	110.38	110.44	110.28	110.34	4800.0
2010-02-03 05:00:00	SPY	ETF	110.38	110.41	110.18	110.29	6600.0
2010-02-03 06:00:00	SPY	ETF	110.27	110.42	110.27	110.37	34350.0
2010-02-03 07:00:00	SPY	ETF	110.38	110.38	110.11	110.11	393464.0
2010-02-03 08:00:00	SPY	ETF	110.15	110.37	109.73	109.84	4730403.0
2010-02-03 09:00:00	SPY	ETF	109.84	110.42	109.77	110.36	22345043.0
2010-02-03 10:00:00	SPY	ETF	110.36	110.3617	109.61	109.9	34150740.0
2010-02-03 11:00:00	SPY	ETF	109.9	110.23	109.53	109.54	19925149.0
2010-02-03 12:00:00	SPY	ETF	109.55	110.4815	109.51	109.83	16140274.0
2010-02-03 13:00:00	SPY	ETF	109.83	110.18	109.75	109.9401	16971664.0
2010-02-03 14:00:00	SPY	ETF	109.95	110.02	109.68	109.89	13805967.0
2010-02-03 15:00:00	SPY	ETF	109.89	110.16	109.73	109.86	30029749.0
2010-02-03 16:00:00	SPY	ETF	109.85	110.4815	109.82	110.2	13419205.0
2010-02-03 17:00:00	SPY	ETF	110.19	110.31	110.17	110.24	219984.0
2010-02-03 18:00:00	SPY	ETF	110.24	110.31	109.82	110.2	79418.0
2010-02-03 19:00:00	SPY	ETF	110.17	110.22	110.03	110.05	109257.0
2010-02-03 04:00:00	QQQ	ETF	43.63	43.64	43.59	43.59	700.0
2010-02-03 06:00:00	QQQ	ETF	43.64	43.64	43.63	43.63	5500.0
2010-02-03 07:00:00	QQQ	ETF	43.65	43.65	43.54	43.55	16372.0
2010-02-03 08:00:00	QQQ	ETF	43.55	43.66	43.41	43.44	1568397.0
2010-02-03 09:00:00	QQQ	ETF	43.44	43.75	43.42	43.73	12134513.0
2010-02-03 10:00:00	QQQ	ETF	43.73	43.77	43.47	43.64	15530220.0
2010-02-03 11:00:00	QQQ	ETF	43.6397	43.81	43.61	43.61	9696741.0
2010-02-03 12:00:00	QQQ	ETF	43.61	43.83	43.59	43.78	8120273.0
2010-02-03 13:00:00	QQQ	ETF	43.78	43.94	43.76	43.88	6354882.0
2010-02-03 14:00:00	QQQ	ETF	43.88	43.91	43.79	43.88	9450965.0
2010-02-03 15:00:00	QQQ	ETF	43.88	43.97	43.84	43.89	14317319.0
2010-02-03 16:00:00	QQQ	ETF	43.9	44.1	43.6961	44.05	8034883.0
2010-02-03 17:00:00	QQQ	ETF	44.05	44.14	43.6961	44.09	3263353.0
2010-02-03 18:00:00	QQQ	ETF	44.1	44.12	44.07	44.08	351057.0
2010-02-03 19:00:00	QQQ	ETF	44.08	44.1	44.03	44.04	269454.0
2010-02-03 07:00:00	IWM	ETF	61.4	61.4	61.27	61.27	8195.0
2010-02-03 08:00:00	IWM	ETF	61.27	61.36	61.06	61.09	208862.0
2010-02-03 09:00:00	IWM	ETF	61.11	61.63	61.08	61.53	4396754.0
2010-02-03 10:00:00	IWM	ETF	61.52	61.61	60.81	60.93	10599279.0
2010-02-03 11:00:00	IWM	ETF	60.935	61.15	60.59	60.62	6213306.0
2010-02-03 12:00:00	IWM	ETF	60.61	60.89	60.59	60.75	4641864.0
2010-02-03 13:00:00	IWM	ETF	60.75	61.1	60.75	60.93	3579707.0
2010-02-03 14:00:00	IWM	ETF	60.93	61.02	60.81	60.91	4102743.0
2010-02-03 15:00:00	IWM	ETF	60.9	61.16	60.86	61.1	7911230.0
2010-02-03 16:00:00	IWM	ETF	61.09	61.45	61.07	61.4046	6012425.0
2010-02-03 17:00:00	IWM	ETF	61.4046	61.45	61.38	61.38	1011783.0
2010-02-03 18:00:00	IWM	ETF	61.37	61.42	61.34	61.35	3377.0
2010-02-03 19:00:00	IWM	ETF	61.3	61.32	61.23	61.32	8200.0
2010-02-03 08:00:00	DIA	ETF	102.6	102.78	102.47	102.49	93450.0
2010-02-03 09:00:00	DIA	ETF	102.51	103.06	102.49	103.03	1102464.0
2010-02-03 10:00:00	DIA	ETF	103.02	103.02	102.4	102.68	1303057.0
2010-02-03 11:00:00	DIA	ETF	102.67	102.8178	102.3599	102.37	995188.0
2010-02-03 12:00:00	DIA	ETF	102.37	102.73	102.34	102.66	666813.0
2010-02-03 13:00:00	DIA	ETF	102.67	103.01	102.65	102.83	611280.0

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

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