PREVIEW / etf_1hour / 2009-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-03.parquet
  size:    144 KB
  rows:    4,486

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-08-03 04:00:00	SPY	ETF	99.22	99.77	99.22	99.77	27392.0
2009-08-03 05:00:00	SPY	ETF	99.72	100.08	99.68	100.0	40500.0
2009-08-03 06:00:00	SPY	ETF	100.05	100.09	99.84	99.86	72425.0
2009-08-03 07:00:00	SPY	ETF	99.87	99.91	99.79	99.89	254346.0
2009-08-03 08:00:00	SPY	ETF	99.87	100.19	98.82	99.82	2070338.0
2009-08-03 09:00:00	SPY	ETF	99.82	100.01	99.31	99.64	28983775.0
2009-08-03 10:00:00	SPY	ETF	99.65	100.35	99.61	99.86	41015457.0
2009-08-03 11:00:00	SPY	ETF	99.86	100.07	99.67	100.06	17940188.0
2009-08-03 12:00:00	SPY	ETF	100.06	100.15	99.78	100.06	10063540.0
2009-08-03 13:00:00	SPY	ETF	100.06	100.31	100.06	100.23	10351697.0
2009-08-03 14:00:00	SPY	ETF	100.2201	100.53	100.19	100.2	18278781.0
2009-08-03 15:00:00	SPY	ETF	100.2	100.47	100.04	100.39	28919618.0
2009-08-03 16:00:00	SPY	ETF	100.4	100.6	98.81	100.5	11947831.0
2009-08-03 17:00:00	SPY	ETF	100.17	100.55	99.83	100.5	369177.0
2009-08-03 18:00:00	SPY	ETF	100.32	100.56	100.3	100.49	32250.0
2009-08-03 19:00:00	SPY	ETF	100.45	100.52	100.45	100.49	101460.0
2009-08-03 04:00:00	QQQ	ETF	39.66	39.85	39.66	39.83	12652.0
2009-08-03 05:00:00	QQQ	ETF	39.88	39.98	39.88	39.98	300.0
2009-08-03 06:00:00	QQQ	ETF	39.98	40.0	39.91	39.91	2373.0
2009-08-03 07:00:00	QQQ	ETF	39.96	39.96	39.86	39.9	329446.0
2009-08-03 08:00:00	QQQ	ETF	39.88	40.04	39.61	39.83	618511.0
2009-08-03 09:00:00	QQQ	ETF	39.83	39.97	39.64	39.77	14146945.0
2009-08-03 10:00:00	QQQ	ETF	39.78	39.97	39.73	39.75	24776190.0
2009-08-03 11:00:00	QQQ	ETF	39.75	39.9	39.66	39.889	16724868.0
2009-08-03 12:00:00	QQQ	ETF	39.89	39.95	39.81	39.8942	7922996.0
2009-08-03 13:00:00	QQQ	ETF	39.9	40.0	39.83	39.9567	7152672.0
2009-08-03 14:00:00	QQQ	ETF	39.959	40.06	39.94	39.95	8879139.0
2009-08-03 15:00:00	QQQ	ETF	39.9499	40.06	39.88	40.04	15883462.0
2009-08-03 16:00:00	QQQ	ETF	40.03	40.09	39.4422	40.04	8301443.0
2009-08-03 17:00:00	QQQ	ETF	40.07	40.08	40.02	40.05	81161.0
2009-08-03 18:00:00	QQQ	ETF	40.06	40.08	40.05	40.06	40613.0
2009-08-03 19:00:00	QQQ	ETF	40.06	40.06	40.04	40.04	32250.0
2009-08-03 06:00:00	IWM	ETF	56.34	56.34	56.34	56.34	5000.0
2009-08-03 07:00:00	IWM	ETF	56.18	56.24	56.18	56.2	76274.0
2009-08-03 08:00:00	IWM	ETF	56.29	56.45	56.14	56.15	171647.0
2009-08-03 09:00:00	IWM	ETF	56.15	56.29	55.62	55.82	6892502.0
2009-08-03 10:00:00	IWM	ETF	55.82	56.2	55.7	55.9574	5748142.0
2009-08-03 11:00:00	IWM	ETF	55.96	56.2	55.8	56.17	3462497.0
2009-08-03 12:00:00	IWM	ETF	56.175	56.25	56.03	56.19	2411659.0
2009-08-03 13:00:00	IWM	ETF	56.2	56.42	56.19	56.399	1774317.0
2009-08-03 14:00:00	IWM	ETF	56.395	56.58	56.38	56.38	2423435.0
2009-08-03 15:00:00	IWM	ETF	56.385	56.58	56.15	56.57	5558641.0
2009-08-03 16:00:00	IWM	ETF	56.57	56.6	56.05	56.49	2224508.0
2009-08-03 17:00:00	IWM	ETF	56.08	56.56	56.08	56.56	12091.0
2009-08-03 18:00:00	IWM	ETF	56.53	56.54	56.46	56.47	4500.0
2009-08-03 19:00:00	IWM	ETF	56.47	56.6	56.43	56.5	1600.0
2009-08-03 06:00:00	DIA	ETF	92.74	92.74	92.61	92.61	200.0
2009-08-03 07:00:00	DIA	ETF	92.56	92.64	92.51	92.56	3921.0
2009-08-03 08:00:00	DIA	ETF	92.53	92.56	92.41	92.44	68970.0
2009-08-03 09:00:00	DIA	ETF	92.45	92.62	91.97	92.28	2096145.0

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

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