PREVIEW / etf_1hour / 2010-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-02.parquet
  size:    153 KB
  rows:    4,752

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-02 04:00:00	SPY	ETF	108.93	109.22	108.87	109.22	2300.0
2010-02-02 05:00:00	SPY	ETF	109.24	109.61	109.24	109.61	6700.0
2010-02-02 06:00:00	SPY	ETF	109.53	109.53	109.3	109.34	58100.0
2010-02-02 07:00:00	SPY	ETF	109.34	109.56	109.33	109.41	399594.0
2010-02-02 08:00:00	SPY	ETF	109.39	109.5	109.11	109.17	3439896.0
2010-02-02 09:00:00	SPY	ETF	109.15	109.38	108.93	109.07	25244699.0
2010-02-02 10:00:00	SPY	ETF	109.07	109.99	108.88	109.85	40437023.0
2010-02-02 11:00:00	SPY	ETF	109.86	109.94	109.57	109.83	20431663.0
2010-02-02 12:00:00	SPY	ETF	109.83	110.15	109.74	110.15	18918458.0
2010-02-02 13:00:00	SPY	ETF	110.14	110.42	109.95	110.34	20319777.0
2010-02-02 14:00:00	SPY	ETF	110.35	110.38	110.01	110.24	23322284.0
2010-02-02 15:00:00	SPY	ETF	110.24	110.59	110.11	110.4	43352670.0
2010-02-02 16:00:00	SPY	ETF	110.4	110.51	109.032	110.34	18357716.0
2010-02-02 17:00:00	SPY	ETF	110.31	110.33	109.0321	110.3	1064892.0
2010-02-02 18:00:00	SPY	ETF	110.28	110.41	110.28	110.33	75581.0
2010-02-02 19:00:00	SPY	ETF	110.33	110.34	110.21	110.21	50270.0
2010-02-02 04:00:00	QQQ	ETF	43.24	43.24	43.24	43.24	200.0
2010-02-02 05:00:00	QQQ	ETF	43.33	43.39	43.33	43.39	395.0
2010-02-02 06:00:00	QQQ	ETF	43.34	43.36	43.29	43.31	48187.0
2010-02-02 07:00:00	QQQ	ETF	43.36	43.4	43.32	43.35	76244.0
2010-02-02 08:00:00	QQQ	ETF	43.36	43.36	43.22	43.24	483505.0
2010-02-02 09:00:00	QQQ	ETF	43.23	43.3902	43.15	43.18	13817152.0
2010-02-02 10:00:00	QQQ	ETF	43.18	43.52	43.03	43.375	25890264.0
2010-02-02 11:00:00	QQQ	ETF	43.38	43.51	43.28	43.4697	10666801.0
2010-02-02 12:00:00	QQQ	ETF	43.4699	43.56	43.42	43.5501	7561649.0
2010-02-02 13:00:00	QQQ	ETF	43.56	43.66	43.42	43.585	10807693.0
2010-02-02 14:00:00	QQQ	ETF	43.6	43.64	43.5	43.625	9064222.0
2010-02-02 15:00:00	QQQ	ETF	43.63	43.78	43.59	43.65	19235107.0
2010-02-02 16:00:00	QQQ	ETF	43.65	43.7028	43.2897	43.62	5816696.0
2010-02-02 17:00:00	QQQ	ETF	43.61	43.61	43.58	43.61	20966.0
2010-02-02 18:00:00	QQQ	ETF	43.6	43.63	43.59	43.61	28050.0
2010-02-02 19:00:00	QQQ	ETF	43.6	43.61	43.56	43.56	61237.0
2010-02-02 07:00:00	IWM	ETF	61.07	61.13	61.05	61.06	16330.0
2010-02-02 08:00:00	IWM	ETF	61.04	61.09	60.93	60.94	981899.0
2010-02-02 09:00:00	IWM	ETF	60.93	61.05	60.66	60.85	7025586.0
2010-02-02 10:00:00	IWM	ETF	60.85	61.42	60.62	61.23	12471448.0
2010-02-02 11:00:00	IWM	ETF	61.23	61.25	60.98	61.15	5237213.0
2010-02-02 12:00:00	IWM	ETF	61.15	61.37	61.095	61.3294	3894921.0
2010-02-02 13:00:00	IWM	ETF	61.32	61.47	61.16	61.32	7587453.0
2010-02-02 14:00:00	IWM	ETF	61.32	61.36	61.11	61.36	9003969.0
2010-02-02 15:00:00	IWM	ETF	61.36	61.56	61.26	61.48	11956151.0
2010-02-02 16:00:00	IWM	ETF	61.49	61.51	60.9215	61.45	10781066.0
2010-02-02 17:00:00	IWM	ETF	61.46	61.46	61.43	61.43	1300.0
2010-02-02 18:00:00	IWM	ETF	61.42	61.48	61.42	61.48	771.0
2010-02-02 19:00:00	IWM	ETF	61.43	61.43	61.43	61.43	1100.0
2010-02-02 07:00:00	DIA	ETF	102.04	102.22	102.04	102.19	700.0
2010-02-02 08:00:00	DIA	ETF	102.12	102.14	101.84	101.84	60936.0
2010-02-02 09:00:00	DIA	ETF	101.85	102.1	101.73	101.8201	1490907.0
2010-02-02 10:00:00	DIA	ETF	101.84	102.61	101.6801	102.504	2174547.0
2010-02-02 11:00:00	DIA	ETF	102.53	102.54	102.28	102.45	1043505.0

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

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