PREVIEW / etf_1hour / 2009-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-13.parquet
  size:    143 KB
  rows:    4,391

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-13 04:00:00	SPY	ETF	109.56	109.6	109.52	109.55	2550.0
2009-11-13 05:00:00	SPY	ETF	109.45	109.49	109.45	109.47	900.0
2009-11-13 06:00:00	SPY	ETF	109.57	109.7	109.57	109.6	9050.0
2009-11-13 07:00:00	SPY	ETF	109.66	109.66	109.35	109.42	838726.0
2009-11-13 08:00:00	SPY	ETF	109.58	109.58	108.99	109.52	2301261.0
2009-11-13 09:00:00	SPY	ETF	109.52	109.57	108.75	108.89	30426010.0
2009-11-13 10:00:00	SPY	ETF	108.89	109.84	108.78	109.63	29988170.0
2009-11-13 11:00:00	SPY	ETF	109.63	109.83	109.51	109.51	12564656.0
2009-11-13 12:00:00	SPY	ETF	109.52	110.09	109.52	109.94	15804223.0
2009-11-13 13:00:00	SPY	ETF	109.95	109.99	109.69	109.74	8880701.0
2009-11-13 14:00:00	SPY	ETF	109.74	109.85	109.17	109.21	17901022.0
2009-11-13 15:00:00	SPY	ETF	109.21	109.73	109.1	109.63	25556862.0
2009-11-13 16:00:00	SPY	ETF	109.63	109.9	108.94	109.76	6091279.0
2009-11-13 17:00:00	SPY	ETF	109.72	109.8	109.67	109.69	70081.0
2009-11-13 18:00:00	SPY	ETF	109.71	109.8	109.7	109.78	13930.0
2009-11-13 19:00:00	SPY	ETF	109.78	109.83	109.77	109.81	12782.0
2009-11-13 04:00:00	QQQ	ETF	43.79	43.79	43.79	43.79	400.0
2009-11-13 06:00:00	QQQ	ETF	43.8	43.86	43.8	43.84	4176.0
2009-11-13 07:00:00	QQQ	ETF	43.82	43.84	43.75	43.78	374262.0
2009-11-13 08:00:00	QQQ	ETF	43.79	43.84	43.73	43.81	1287958.0
2009-11-13 09:00:00	QQQ	ETF	43.82	43.87	43.63	43.69	15280281.0
2009-11-13 10:00:00	QQQ	ETF	43.685	43.99	43.65	43.92	18782168.0
2009-11-13 11:00:00	QQQ	ETF	43.92	44.01	43.89	43.9	7377508.0
2009-11-13 12:00:00	QQQ	ETF	43.9	44.14	43.89	44.07	7999043.0
2009-11-13 13:00:00	QQQ	ETF	44.06	44.095	43.98	44.0025	5016811.0
2009-11-13 14:00:00	QQQ	ETF	44.0001	44.06	43.82	43.82	10802380.0
2009-11-13 15:00:00	QQQ	ETF	43.82	44.03	43.79	44.01	11831108.0
2009-11-13 16:00:00	QQQ	ETF	44.01	44.08	43.6335	44.08	3352786.0
2009-11-13 17:00:00	QQQ	ETF	44.06	44.08	44.05	44.07	9002.0
2009-11-13 18:00:00	QQQ	ETF	44.07	44.1	44.06	44.06	13050.0
2009-11-13 19:00:00	QQQ	ETF	44.08	44.14	44.08	44.14	11524.0
2009-11-13 07:00:00	IWM	ETF	58.49	58.52	58.3	58.42	186374.0
2009-11-13 08:00:00	IWM	ETF	58.45	58.47	58.11	58.41	1174402.0
2009-11-13 09:00:00	IWM	ETF	58.44	58.45	57.63	57.74	9408240.0
2009-11-13 10:00:00	IWM	ETF	57.73	58.45	57.64	58.3	10831537.0
2009-11-13 11:00:00	IWM	ETF	58.3	58.41	58.171	58.18	4488605.0
2009-11-13 12:00:00	IWM	ETF	58.18	58.96	58.18	58.85	7830977.0
2009-11-13 13:00:00	IWM	ETF	58.85	58.9	58.67	58.69	2948541.0
2009-11-13 14:00:00	IWM	ETF	58.69	58.8	58.11	58.12	10259907.0
2009-11-13 15:00:00	IWM	ETF	58.13	58.73	58.04	58.71	10911304.0
2009-11-13 16:00:00	IWM	ETF	58.71	58.8	58.3456	58.8	5389727.0
2009-11-13 17:00:00	IWM	ETF	58.75	58.75	58.75	58.75	1239.0
2009-11-13 18:00:00	IWM	ETF	58.72	58.74	58.72	58.74	3227.0
2009-11-13 19:00:00	IWM	ETF	58.8	58.85	58.78	58.85	3100.0
2009-11-13 04:00:00	DIA	ETF	102.56	102.56	102.56	102.56	200.0
2009-11-13 07:00:00	DIA	ETF	102.7	102.7	102.7	102.7	100.0
2009-11-13 08:00:00	DIA	ETF	102.53	102.62	102.49	102.56	11764.0
2009-11-13 09:00:00	DIA	ETF	102.6	102.65	102.1	102.23	2767442.0
2009-11-13 10:00:00	DIA	ETF	102.23	103.09	102.14	102.94	2386194.0
2009-11-13 11:00:00	DIA	ETF	102.93	103.09	102.84	102.84	1118945.0

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

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