PREVIEW / etf_1hour / 2009-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-09.parquet
  size:    128 KB
  rows:    4,030

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-03-09 06:00:00	SPY	ETF	67.74	68.57	67.74	68.17	113900.0
2009-03-09 07:00:00	SPY	ETF	68.17	68.63	67.87	68.29	926762.0
2009-03-09 08:00:00	SPY	ETF	68.31	69.3	67.83	68.25	4837598.0
2009-03-09 09:00:00	SPY	ETF	68.25	69.46	67.89	68.95	42769523.0
2009-03-09 10:00:00	SPY	ETF	68.95	70.0	68.82	68.9	57387220.0
2009-03-09 11:00:00	SPY	ETF	68.9	69.24	68.6	68.95	40242754.0
2009-03-09 12:00:00	SPY	ETF	68.94	69.45	68.65	68.79	30211525.0
2009-03-09 13:00:00	SPY	ETF	68.79	68.791	68.13	68.48	36808052.0
2009-03-09 14:00:00	SPY	ETF	68.47	68.98	67.95	68.43	50409658.0
2009-03-09 15:00:00	SPY	ETF	68.43	68.7	67.73	68.07	72652997.0
2009-03-09 16:00:00	SPY	ETF	68.07	69.75	67.87	67.99	17301276.0
2009-03-09 17:00:00	SPY	ETF	67.95	68.01	67.89	67.96	3509471.0
2009-03-09 18:00:00	SPY	ETF	67.98	68.02	67.92	68.01	32820.0
2009-03-09 19:00:00	SPY	ETF	68.01	68.14	68.0	68.14	162706.0
2009-03-09 04:00:00	QQQ	ETF	26.25	26.28	26.2	26.28	400.0
2009-03-09 05:00:00	QQQ	ETF	26.2	26.2	26.01	26.1	1900.0
2009-03-09 06:00:00	QQQ	ETF	26.21	26.21	26.21	26.21	1100.0
2009-03-09 07:00:00	QQQ	ETF	26.15	26.35	26.15	26.28	303815.0
2009-03-09 08:00:00	QQQ	ETF	26.28	26.4	26.1	26.16	934048.0
2009-03-09 09:00:00	QQQ	ETF	26.14	26.68	26.02	26.43	19118815.0
2009-03-09 10:00:00	QQQ	ETF	26.4299	26.81	26.15	26.16	34234795.0
2009-03-09 11:00:00	QQQ	ETF	26.16	26.33	26.02	26.11	23971583.0
2009-03-09 12:00:00	QQQ	ETF	26.12	26.29	25.98	26.02	15018599.0
2009-03-09 13:00:00	QQQ	ETF	26.02	26.02	25.77	25.86	16342449.0
2009-03-09 14:00:00	QQQ	ETF	25.87	26.03	25.73	25.82	24396829.0
2009-03-09 15:00:00	QQQ	ETF	25.81	26.13	25.6301	25.72	31691752.0
2009-03-09 16:00:00	QQQ	ETF	25.72	26.2339	25.66	25.75	9311749.0
2009-03-09 17:00:00	QQQ	ETF	25.76	25.78	25.7	25.72	123323.0
2009-03-09 18:00:00	QQQ	ETF	25.74	25.77	25.72	25.77	42523.0
2009-03-09 19:00:00	QQQ	ETF	25.75	25.8	25.75	25.78	40305.0
2009-03-09 07:00:00	IWM	ETF	34.81	35.13	34.81	35.13	10100.0
2009-03-09 08:00:00	IWM	ETF	34.96	35.2	34.79	34.87	312932.0
2009-03-09 09:00:00	IWM	ETF	34.87	35.5	34.69	35.02	7959215.0
2009-03-09 10:00:00	IWM	ETF	35.03	35.64	35.01	35.01	10572577.0
2009-03-09 11:00:00	IWM	ETF	35.02	35.2	34.76	34.85	10060857.0
2009-03-09 12:00:00	IWM	ETF	34.88	35.135	34.65	34.83	7406019.0
2009-03-09 13:00:00	IWM	ETF	34.82	34.82	34.47	34.59	6589782.0
2009-03-09 14:00:00	IWM	ETF	34.59	34.82	34.36	34.52	11558926.0
2009-03-09 15:00:00	IWM	ETF	34.52	34.64	34.26	34.41	12706563.0
2009-03-09 16:00:00	IWM	ETF	34.41	35.2847	34.28	34.35	2143469.0
2009-03-09 17:00:00	IWM	ETF	34.35	34.4	34.35	34.37	4583.0
2009-03-09 18:00:00	IWM	ETF	34.27	34.45	34.27	34.42	2949.0
2009-03-09 19:00:00	IWM	ETF	34.39	34.39	34.32	34.32	1200.0
2009-03-09 06:00:00	DIA	ETF	65.72	66.0	65.72	65.79	11100.0
2009-03-09 07:00:00	DIA	ETF	65.85	66.2	65.69	65.91	12600.0
2009-03-09 08:00:00	DIA	ETF	65.99	66.0	65.62	65.79	56000.0
2009-03-09 09:00:00	DIA	ETF	65.79	66.62	65.47	66.18	4134843.0
2009-03-09 10:00:00	DIA	ETF	66.19	67.17	66.13	66.29	5192818.0
2009-03-09 11:00:00	DIA	ETF	66.29	66.54	65.95	66.21	3267543.0
2009-03-09 12:00:00	DIA	ETF	66.25	66.7	66.0	66.13	1984851.0

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

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