PREVIEW / etf_1hour / 2009-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-30.parquet
  size:    148 KB
  rows:    4,559

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-11-30 04:00:00	SPY	ETF	109.67	109.67	109.22	109.22	5500.0
2009-11-30 05:00:00	SPY	ETF	109.22	109.54	109.22	109.5	3574.0
2009-11-30 06:00:00	SPY	ETF	109.42	109.42	109.0	109.35	58566.0
2009-11-30 07:00:00	SPY	ETF	109.3	109.51	109.1	109.51	810254.0
2009-11-30 08:00:00	SPY	ETF	109.48	109.81	109.22	109.55	1987252.0
2009-11-30 09:00:00	SPY	ETF	109.56	110.2	109.12	109.61	28104440.0
2009-11-30 10:00:00	SPY	ETF	109.61	110.15	109.59	109.73	20380671.0
2009-11-30 11:00:00	SPY	ETF	109.73	109.73	109.02	109.14	22192673.0
2009-11-30 12:00:00	SPY	ETF	109.14	110.2	109.07	109.12	11575887.0
2009-11-30 13:00:00	SPY	ETF	109.13	110.05	109.09	109.49	13816948.0
2009-11-30 14:00:00	SPY	ETF	109.5	109.53	109.28	109.33	10440431.0
2009-11-30 15:00:00	SPY	ETF	109.33	110.14	109.33	109.97	36914430.0
2009-11-30 16:00:00	SPY	ETF	109.97	110.08	109.1238	109.84	9055888.0
2009-11-30 17:00:00	SPY	ETF	109.85	109.86	109.7	109.76	218347.0
2009-11-30 18:00:00	SPY	ETF	109.78	109.85	109.73	109.79	124715.0
2009-11-30 19:00:00	SPY	ETF	109.75	110.01	109.74	109.84	87657.0
2009-11-30 05:00:00	QQQ	ETF	43.25	43.35	43.19	43.35	800.0
2009-11-30 06:00:00	QQQ	ETF	43.3	43.36	43.18	43.27	600.0
2009-11-30 07:00:00	QQQ	ETF	43.24	43.38	43.24	43.38	485553.0
2009-11-30 08:00:00	QQQ	ETF	43.39	43.49	43.31	43.41	960061.0
2009-11-30 09:00:00	QQQ	ETF	43.41	43.48	43.24	43.395	15394266.0
2009-11-30 10:00:00	QQQ	ETF	43.39	43.62	43.39	43.4105	11097855.0
2009-11-30 11:00:00	QQQ	ETF	43.42	43.42	43.11	43.19	10258965.0
2009-11-30 12:00:00	QQQ	ETF	43.18	43.3	43.18	43.21	6586731.0
2009-11-30 13:00:00	QQQ	ETF	43.205	43.39	43.19	43.3599	7688953.0
2009-11-30 14:00:00	QQQ	ETF	43.36	43.37	43.29	43.3	5892929.0
2009-11-30 15:00:00	QQQ	ETF	43.31	43.59	43.31	43.55	15798306.0
2009-11-30 16:00:00	QQQ	ETF	43.55	43.57	43.3894	43.54	9858302.0
2009-11-30 17:00:00	QQQ	ETF	43.54	43.55	43.49	43.54	58247.0
2009-11-30 18:00:00	QQQ	ETF	43.51	43.52	43.5	43.52	7486.0
2009-11-30 19:00:00	QQQ	ETF	43.49	43.57	43.49	43.52	27017.0
2009-11-30 07:00:00	IWM	ETF	57.5	57.68	57.45	57.68	129586.0
2009-11-30 08:00:00	IWM	ETF	57.7	57.88	57.63	57.75	309735.0
2009-11-30 09:00:00	IWM	ETF	57.74	57.76	57.1	57.29	14957597.0
2009-11-30 10:00:00	IWM	ETF	57.29	57.5475	57.24	57.2601	10945889.0
2009-11-30 11:00:00	IWM	ETF	57.26	57.27	56.86	56.94	12960824.0
2009-11-30 12:00:00	IWM	ETF	56.94	57.17	56.94	57.13	3995420.0
2009-11-30 13:00:00	IWM	ETF	57.13	57.47	57.1	57.37	6789680.0
2009-11-30 14:00:00	IWM	ETF	57.37	57.45	57.27	57.33	5837061.0
2009-11-30 15:00:00	IWM	ETF	57.34	58.18	57.315	58.08	15606293.0
2009-11-30 16:00:00	IWM	ETF	58.08	58.12	57.25	58.0	4612398.0
2009-11-30 17:00:00	IWM	ETF	58.03	58.03	57.93	57.94	10198.0
2009-11-30 18:00:00	IWM	ETF	57.1142	57.95	57.1142	57.91	8349.0
2009-11-30 19:00:00	IWM	ETF	57.98	57.99	57.91	57.91	2355.0
2009-11-30 07:00:00	DIA	ETF	103.1	103.1	103.1	103.1	4100.0
2009-11-30 08:00:00	DIA	ETF	103.1	103.33	103.08	103.19	172690.0
2009-11-30 09:00:00	DIA	ETF	103.18	103.32	102.81	103.25	2471368.0
2009-11-30 10:00:00	DIA	ETF	103.26	103.74	103.258	103.33	1668150.0
2009-11-30 11:00:00	DIA	ETF	103.33	103.33	102.71	102.77	1366751.0
2009-11-30 12:00:00	DIA	ETF	102.78	103.08	102.76	102.83	1058473.0

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

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