PREVIEW / etf_1hour / 2009-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-10.parquet
  size:    140 KB
  rows:    4,309

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-06-10 04:00:00	SPY	ETF	95.42	95.55	95.38	95.55	8583.0
2009-06-10 05:00:00	SPY	ETF	95.58	95.67	95.51	95.51	4975.0
2009-06-10 06:00:00	SPY	ETF	95.72	95.87	95.7	95.76	47162.0
2009-06-10 07:00:00	SPY	ETF	95.72	95.94	95.55	95.57	1294401.0
2009-06-10 08:00:00	SPY	ETF	95.56	95.8	94.63	95.36	1615978.0
2009-06-10 09:00:00	SPY	ETF	95.35	95.815	94.89	95.13	28761405.0
2009-06-10 10:00:00	SPY	ETF	95.13	95.15	94.27	94.45	46498816.0
2009-06-10 11:00:00	SPY	ETF	94.45	94.4501	94.07	94.32	25173428.0
2009-06-10 12:00:00	SPY	ETF	94.32	94.56	94.16	94.26	26076213.0
2009-06-10 13:00:00	SPY	ETF	94.26	94.3	93.26	93.48	46602629.0
2009-06-10 14:00:00	SPY	ETF	93.48	94.24	93.19	93.9	43477694.0
2009-06-10 15:00:00	SPY	ETF	93.9	94.4	93.4	94.355	56967588.0
2009-06-10 16:00:00	SPY	ETF	94.36	94.6799	93.9452	94.49	16940471.0
2009-06-10 17:00:00	SPY	ETF	94.49	94.62	94.46	94.58	464497.0
2009-06-10 18:00:00	SPY	ETF	94.57	94.64	94.34	94.6	258782.0
2009-06-10 19:00:00	SPY	ETF	94.6	94.64	94.56	94.6	153097.0
2009-06-10 04:00:00	QQQ	ETF	37.3	37.36	37.27	37.27	1141.0
2009-06-10 05:00:00	QQQ	ETF	37.35	37.35	37.26	37.26	300.0
2009-06-10 06:00:00	QQQ	ETF	37.36	37.36	37.32	37.32	9953.0
2009-06-10 07:00:00	QQQ	ETF	37.32	37.37	37.25	37.26	574702.0
2009-06-10 08:00:00	QQQ	ETF	37.25	37.29	37.17	37.18	685314.0
2009-06-10 09:00:00	QQQ	ETF	37.18	37.24	36.8	36.9	17054750.0
2009-06-10 10:00:00	QQQ	ETF	36.91	36.93	36.56	36.59	20526367.0
2009-06-10 11:00:00	QQQ	ETF	36.59	36.6	36.42	36.52	16565602.0
2009-06-10 12:00:00	QQQ	ETF	36.52	36.73	36.5	36.63	11729917.0
2009-06-10 13:00:00	QQQ	ETF	36.62	36.64	36.3111	36.4	13590723.0
2009-06-10 14:00:00	QQQ	ETF	36.39	36.64	36.29	36.59	14598589.0
2009-06-10 15:00:00	QQQ	ETF	36.59	36.84	36.43	36.81	26416247.0
2009-06-10 16:00:00	QQQ	ETF	36.81	36.86	36.415	36.86	6237835.0
2009-06-10 17:00:00	QQQ	ETF	36.84	36.9	36.83	36.86	420173.0
2009-06-10 18:00:00	QQQ	ETF	36.86	36.89	36.85	36.86	23637.0
2009-06-10 19:00:00	QQQ	ETF	36.86	36.95	36.85	36.88	21440.0
2009-06-10 07:00:00	IWM	ETF	53.62	53.62	53.41	53.42	173789.0
2009-06-10 08:00:00	IWM	ETF	53.43	53.69	53.15	53.33	130919.0
2009-06-10 09:00:00	IWM	ETF	53.33	53.41	52.44	52.6	8172594.0
2009-06-10 10:00:00	IWM	ETF	52.6	52.6001	51.99	52.15	7150048.0
2009-06-10 11:00:00	IWM	ETF	52.14	52.29	51.94	52.23	4400683.0
2009-06-10 12:00:00	IWM	ETF	52.23	52.57	52.19	52.34	4564079.0
2009-06-10 13:00:00	IWM	ETF	52.33	52.35	51.6201	51.8	7260843.0
2009-06-10 14:00:00	IWM	ETF	51.8	52.36	51.61	52.245	8617513.0
2009-06-10 15:00:00	IWM	ETF	52.25	52.59	51.95	52.58	12140047.0
2009-06-10 16:00:00	IWM	ETF	52.58	52.67	52.3586	52.6	1489577.0
2009-06-10 17:00:00	IWM	ETF	52.6	52.69	52.59	52.59	33598.0
2009-06-10 18:00:00	IWM	ETF	52.54	52.54	52.53	52.53	200.0
2009-06-10 19:00:00	IWM	ETF	51.98	51.98	51.98	51.98	200.0
2009-06-10 04:00:00	DIA	ETF	88.48	88.48	88.48	88.48	100.0
2009-06-10 06:00:00	DIA	ETF	88.64	88.77	88.64	88.77	700.0
2009-06-10 07:00:00	DIA	ETF	88.68	88.87	88.54	88.54	13475.0
2009-06-10 08:00:00	DIA	ETF	88.57	88.63	88.42	88.42	31970.0
2009-06-10 09:00:00	DIA	ETF	88.42	88.58	88.14	88.3275	1741942.0

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

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