PREVIEW / etf_1hour / 2009-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-13.parquet
  size:    141 KB
  rows:    4,342

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-05-13 04:00:00	SPY	ETF	91.15	91.36	91.15	91.31	11100.0
2009-05-13 05:00:00	SPY	ETF	91.32	91.35	90.97	90.97	4000.0
2009-05-13 06:00:00	SPY	ETF	91.05	91.07	90.65	90.71	75095.0
2009-05-13 07:00:00	SPY	ETF	90.75	90.86	90.19	90.24	1089729.0
2009-05-13 08:00:00	SPY	ETF	90.25	91.25	89.38	89.64	7719455.0
2009-05-13 09:00:00	SPY	ETF	89.63	89.75	89.15	89.571	36241939.0
2009-05-13 10:00:00	SPY	ETF	89.58	90.01	89.25	89.2899	43304574.0
2009-05-13 11:00:00	SPY	ETF	89.2899	89.49	89.02	89.16	31633200.0
2009-05-13 12:00:00	SPY	ETF	89.16	89.53	88.8	88.82	21005874.0
2009-05-13 13:00:00	SPY	ETF	88.81	89.09	88.5	89.08	32301267.0
2009-05-13 14:00:00	SPY	ETF	89.08	89.14	88.59	89.09	27273823.0
2009-05-13 15:00:00	SPY	ETF	89.08	89.36	88.55	88.7	57360178.0
2009-05-13 16:00:00	SPY	ETF	88.73	89.2997	86.6322	88.95	8765671.0
2009-05-13 17:00:00	SPY	ETF	88.98	88.98	88.86	88.86	190246.0
2009-05-13 18:00:00	SPY	ETF	88.88	88.88	88.62	88.68	132410.0
2009-05-13 19:00:00	SPY	ETF	88.74	88.9	88.68	88.88	97628.0
2009-05-13 04:00:00	QQQ	ETF	34.0	34.08	34.0	34.08	200.0
2009-05-13 06:00:00	QQQ	ETF	33.97	33.97	33.81	33.83	35121.0
2009-05-13 07:00:00	QQQ	ETF	33.86	33.87	33.63	33.69	320471.0
2009-05-13 08:00:00	QQQ	ETF	33.71	33.93	33.55	33.6	2453631.0
2009-05-13 09:00:00	QQQ	ETF	33.62	33.65	33.39	33.48	20716471.0
2009-05-13 10:00:00	QQQ	ETF	33.48	33.48	33.14	33.1599	26766167.0
2009-05-13 11:00:00	QQQ	ETF	33.155	33.28	33.11	33.16	16342567.0
2009-05-13 12:00:00	QQQ	ETF	33.16	33.28	33.07	33.08	11703485.0
2009-05-13 13:00:00	QQQ	ETF	33.08	33.23	33.01	33.23	22991537.0
2009-05-13 14:00:00	QQQ	ETF	33.23	33.25	32.96	33.17	25680788.0
2009-05-13 15:00:00	QQQ	ETF	33.17	33.19	32.99	33.01	31069802.0
2009-05-13 16:00:00	QQQ	ETF	33.01	33.13	32.97	33.1	8095050.0
2009-05-13 17:00:00	QQQ	ETF	33.09	33.1	33.06	33.08	69694.0
2009-05-13 18:00:00	QQQ	ETF	33.06	33.06	33.0	33.02	72453.0
2009-05-13 19:00:00	QQQ	ETF	33.03	33.1	33.01	33.07	41960.0
2009-05-13 05:00:00	IWM	ETF	49.79	49.79	49.59	49.59	2600.0
2009-05-13 06:00:00	IWM	ETF	49.51	49.51	49.34	49.39	3100.0
2009-05-13 07:00:00	IWM	ETF	49.41	49.48	49.0	49.02	153096.0
2009-05-13 08:00:00	IWM	ETF	49.03	49.61	48.59	48.63	709171.0
2009-05-13 09:00:00	IWM	ETF	48.65	48.81	48.24	48.348	8415316.0
2009-05-13 10:00:00	IWM	ETF	48.35	48.49	48.06	48.115	8191890.0
2009-05-13 11:00:00	IWM	ETF	48.12	48.16	47.83	47.86	5696732.0
2009-05-13 12:00:00	IWM	ETF	47.85	48.05	47.59	47.6	4326843.0
2009-05-13 13:00:00	IWM	ETF	47.59	47.66	47.27	47.66	9136169.0
2009-05-13 14:00:00	IWM	ETF	47.65	47.68	47.21	47.62	10463247.0
2009-05-13 15:00:00	IWM	ETF	47.62	48.4	47.25	47.27	15168094.0
2009-05-13 16:00:00	IWM	ETF	47.27	47.9063	47.25	47.41	1553428.0
2009-05-13 17:00:00	IWM	ETF	47.49	47.49	47.41	47.41	19403.0
2009-05-13 18:00:00	IWM	ETF	47.33	47.4	47.24	47.28	9950.0
2009-05-13 19:00:00	IWM	ETF	47.28	47.35	47.24	47.35	18550.0
2009-05-13 05:00:00	DIA	ETF	84.97	84.97	84.9	84.9	2400.0
2009-05-13 06:00:00	DIA	ETF	84.45	84.45	84.45	84.45	100.0
2009-05-13 07:00:00	DIA	ETF	84.59	84.59	84.07	84.1	27769.0
2009-05-13 08:00:00	DIA	ETF	84.1	84.64	83.29	83.63	202468.0

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

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