PREVIEW / etf_1hour / 2009-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-06.parquet
  size:    139 KB
  rows:    4,340

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-06 04:00:00	SPY	ETF	90.12	90.38	90.12	90.34	4100.0
2009-05-06 05:00:00	SPY	ETF	90.46	90.52	90.39	90.4	12130.0
2009-05-06 06:00:00	SPY	ETF	90.4	90.4	90.1	90.29	39330.0
2009-05-06 07:00:00	SPY	ETF	90.29	90.35	89.96	90.24	1069771.0
2009-05-06 08:00:00	SPY	ETF	90.24	91.64	89.6	91.44	10532908.0
2009-05-06 09:00:00	SPY	ETF	91.45	91.74	91.26	91.55	30606134.0
2009-05-06 10:00:00	SPY	ETF	91.5462	91.63	90.61	91.09	48732471.0
2009-05-06 11:00:00	SPY	ETF	91.09	91.28	90.72	91.28	28000533.0
2009-05-06 12:00:00	SPY	ETF	91.28	91.59	91.0	91.219	23148762.0
2009-05-06 13:00:00	SPY	ETF	91.21	91.76	90.9	91.73	35806139.0
2009-05-06 14:00:00	SPY	ETF	91.74	92.2	91.16	91.96	37994344.0
2009-05-06 15:00:00	SPY	ETF	91.96	92.16	91.26	92.14	64867334.0
2009-05-06 16:00:00	SPY	ETF	92.14	92.27	89.8757	91.92	8545354.0
2009-05-06 17:00:00	SPY	ETF	91.95	92.17	91.94	92.16	1345917.0
2009-05-06 18:00:00	SPY	ETF	92.16	92.24	92.08	92.15	325151.0
2009-05-06 19:00:00	SPY	ETF	92.18	92.21	92.01	92.04	128611.0
2009-05-06 04:00:00	QQQ	ETF	34.98	34.98	34.98	34.98	100.0
2009-05-06 05:00:00	QQQ	ETF	35.02	35.05	34.98	34.98	6000.0
2009-05-06 06:00:00	QQQ	ETF	34.96	34.98	34.91	34.96	2740.0
2009-05-06 07:00:00	QQQ	ETF	35.0	35.02	34.86	35.0	554684.0
2009-05-06 08:00:00	QQQ	ETF	35.01	35.32	34.72	35.24	6795297.0
2009-05-06 09:00:00	QQQ	ETF	35.24	35.34	35.05	35.15	13673623.0
2009-05-06 10:00:00	QQQ	ETF	35.16	35.17	34.46	34.725	33610715.0
2009-05-06 11:00:00	QQQ	ETF	34.72	34.89	34.59	34.89	15438671.0
2009-05-06 12:00:00	QQQ	ETF	34.8899	35.0	34.74	34.76	15542864.0
2009-05-06 13:00:00	QQQ	ETF	34.77	34.94	34.64	34.9169	22727666.0
2009-05-06 14:00:00	QQQ	ETF	34.91	35.185	34.88	35.02	21225600.0
2009-05-06 15:00:00	QQQ	ETF	35.02	35.065	34.75	35.03	26655388.0
2009-05-06 16:00:00	QQQ	ETF	35.03	35.27	34.85	35.01	16116770.0
2009-05-06 17:00:00	QQQ	ETF	34.97	35.06	34.96	35.0	271877.0
2009-05-06 18:00:00	QQQ	ETF	35.01	35.09	35.0	35.07	78025.0
2009-05-06 19:00:00	QQQ	ETF	35.06	35.07	35.02	35.05	32801.0
2009-05-06 06:00:00	IWM	ETF	50.17	50.17	50.1	50.1	300.0
2009-05-06 07:00:00	IWM	ETF	50.17	50.18	49.96	50.15	46700.0
2009-05-06 08:00:00	IWM	ETF	50.15	50.89	49.7	50.78	937901.0
2009-05-06 09:00:00	IWM	ETF	50.78	51.22	50.42	50.59	9171001.0
2009-05-06 10:00:00	IWM	ETF	50.59	50.67	49.5	50.02	15228749.0
2009-05-06 11:00:00	IWM	ETF	50.02	50.1	49.73	50.1	6436920.0
2009-05-06 12:00:00	IWM	ETF	50.1	50.4	49.75	50.081	6542036.0
2009-05-06 13:00:00	IWM	ETF	50.08	50.249	49.65	50.23	10930661.0
2009-05-06 14:00:00	IWM	ETF	50.24	50.77	50.19	50.4978	7981427.0
2009-05-06 15:00:00	IWM	ETF	50.5	50.57	49.97	50.48	14241915.0
2009-05-06 16:00:00	IWM	ETF	50.47	50.73	50.2811	50.59	8982479.0
2009-05-06 17:00:00	IWM	ETF	50.55	50.64	50.55	50.64	16379.0
2009-05-06 18:00:00	IWM	ETF	50.59	50.59	50.59	50.59	100.0
2009-05-06 04:00:00	DIA	ETF	84.04	84.04	84.04	84.04	500.0
2009-05-06 06:00:00	DIA	ETF	83.89	84.03	83.89	84.03	200.0
2009-05-06 07:00:00	DIA	ETF	84.11	84.11	83.77	84.04	8999.0
2009-05-06 08:00:00	DIA	ETF	84.02	85.04	83.99	84.87	197007.0
2009-05-06 09:00:00	DIA	ETF	84.95	85.13	84.6594	84.9	2336543.0

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

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