PREVIEW / etf_1hour / 2009-06-03

all etf 1-hour files

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

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-03 04:00:00	SPY	ETF	94.32	94.39	94.19	94.19	3705.0
2009-06-03 05:00:00	SPY	ETF	94.2	94.31	94.11	94.14	3000.0
2009-06-03 06:00:00	SPY	ETF	94.22	94.31	94.14	94.23	24200.0
2009-06-03 07:00:00	SPY	ETF	94.23	94.34	94.1	94.3	606415.0
2009-06-03 08:00:00	SPY	ETF	94.3	94.88	93.91	93.99	3032373.0
2009-06-03 09:00:00	SPY	ETF	93.99	95.05	93.5	93.69	30249067.0
2009-06-03 10:00:00	SPY	ETF	93.68	93.71	93.28	93.7	34257287.0
2009-06-03 11:00:00	SPY	ETF	93.7	93.79	93.42	93.48	19701358.0
2009-06-03 12:00:00	SPY	ETF	93.48	93.55	93.12	93.162	20701142.0
2009-06-03 13:00:00	SPY	ETF	93.16	93.17	92.79	92.95	25213141.0
2009-06-03 14:00:00	SPY	ETF	92.95	93.22	92.82	93.12	28839480.0
2009-06-03 15:00:00	SPY	ETF	93.11	93.66	92.76	93.65	55671902.0
2009-06-03 16:00:00	SPY	ETF	93.65	93.7	92.9141	93.59	14947697.0
2009-06-03 17:00:00	SPY	ETF	93.59	94.8598	93.46	93.5	1258688.0
2009-06-03 18:00:00	SPY	ETF	93.51	93.64	93.46	93.52	74377.0
2009-06-03 19:00:00	SPY	ETF	93.51	93.51	93.45	93.46	40314.0
2009-06-03 04:00:00	QQQ	ETF	36.33	36.33	36.33	36.33	1500.0
2009-06-03 05:00:00	QQQ	ETF	36.32	36.32	36.32	36.32	100.0
2009-06-03 07:00:00	QQQ	ETF	36.25	36.32	36.21	36.3	134090.0
2009-06-03 08:00:00	QQQ	ETF	36.31	36.36	36.16	36.2	752144.0
2009-06-03 09:00:00	QQQ	ETF	36.21	36.33	36.1	36.16	14061395.0
2009-06-03 10:00:00	QQQ	ETF	36.16	36.29	36.04	36.29	15748695.0
2009-06-03 11:00:00	QQQ	ETF	36.29	36.37	36.16	36.26	8825831.0
2009-06-03 12:00:00	QQQ	ETF	36.26	36.29	36.06	36.0712	10259702.0
2009-06-03 13:00:00	QQQ	ETF	36.07	36.11	35.93	36.03	12238429.0
2009-06-03 14:00:00	QQQ	ETF	36.04	36.17	35.97	36.1199	9185632.0
2009-06-03 15:00:00	QQQ	ETF	36.12	36.35	36.01	36.35	15360851.0
2009-06-03 16:00:00	QQQ	ETF	36.35	36.4527	36.1267	36.37	5292983.0
2009-06-03 17:00:00	QQQ	ETF	36.35	36.35	36.32	36.35	86006.0
2009-06-03 18:00:00	QQQ	ETF	36.34	36.35	36.33	36.33	93100.0
2009-06-03 19:00:00	QQQ	ETF	36.33	36.34	36.31	36.31	12800.0
2009-06-03 06:00:00	IWM	ETF	52.56	52.56	52.56	52.56	100.0
2009-06-03 07:00:00	IWM	ETF	52.45	52.56	52.39	52.51	59016.0
2009-06-03 08:00:00	IWM	ETF	52.52	52.62	52.25	52.3	304949.0
2009-06-03 09:00:00	IWM	ETF	52.3	52.51	52.16	52.29	6501209.0
2009-06-03 10:00:00	IWM	ETF	52.29	52.35	52.02	52.32	7010855.0
2009-06-03 11:00:00	IWM	ETF	52.32	52.33	52.06	52.11	4259706.0
2009-06-03 12:00:00	IWM	ETF	52.1	52.17	51.91	51.945	3049885.0
2009-06-03 13:00:00	IWM	ETF	51.94	51.96	51.74	51.88	3961959.0
2009-06-03 14:00:00	IWM	ETF	51.89	52.155	51.8	52.09	4362013.0
2009-06-03 15:00:00	IWM	ETF	52.09	52.44	51.8698	52.42	8442211.0
2009-06-03 16:00:00	IWM	ETF	52.43	52.7506	52.3461	52.5	4670428.0
2009-06-03 17:00:00	IWM	ETF	52.49	52.53	52.45	52.48	161610.0
2009-06-03 18:00:00	IWM	ETF	52.45	52.46	52.43	52.43	600.0
2009-06-03 19:00:00	IWM	ETF	52.44	52.44	52.44	52.44	2000.0
2009-06-03 06:00:00	DIA	ETF	87.04	87.04	87.04	87.04	100.0
2009-06-03 07:00:00	DIA	ETF	87.04	87.09	86.95	87.06	22199.0
2009-06-03 08:00:00	DIA	ETF	87.07	87.18	86.79	86.88	96832.0
2009-06-03 09:00:00	DIA	ETF	86.89	87.11	86.54	86.7	1604172.0
2009-06-03 10:00:00	DIA	ETF	86.7097	86.78	86.378	86.752	1424431.0

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

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