PREVIEW / etf_1hour / 2009-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-09.parquet
  size:    136 KB
  rows:    4,196

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-07-09 04:00:00	SPY	ETF	88.52	88.63	88.52	88.62	1800.0
2009-07-09 05:00:00	SPY	ETF	88.56	88.75	88.56	88.74	46825.0
2009-07-09 06:00:00	SPY	ETF	88.7	88.75	88.53	88.53	120100.0
2009-07-09 07:00:00	SPY	ETF	88.52	88.59	88.36	88.57	360439.0
2009-07-09 08:00:00	SPY	ETF	88.57	88.9	88.3	88.72	6381802.0
2009-07-09 09:00:00	SPY	ETF	88.71	88.72	88.03	88.26	22753526.0
2009-07-09 10:00:00	SPY	ETF	88.27	88.57	88.0	88.34	29478988.0
2009-07-09 11:00:00	SPY	ETF	88.33	88.59	87.91	88.34	21193326.0
2009-07-09 12:00:00	SPY	ETF	88.34	88.65	88.25	88.6	12896370.0
2009-07-09 13:00:00	SPY	ETF	88.59	88.77	88.3	88.6	18370510.0
2009-07-09 14:00:00	SPY	ETF	88.61	88.9	88.52	88.55	15761835.0
2009-07-09 15:00:00	SPY	ETF	88.56	88.6	88.14	88.23	27713388.0
2009-07-09 16:00:00	SPY	ETF	88.22	88.38	88.0416	88.3	8119739.0
2009-07-09 17:00:00	SPY	ETF	88.3	88.33	88.26	88.32	102032.0
2009-07-09 18:00:00	SPY	ETF	88.32	88.37	88.2	88.32	14044.0
2009-07-09 19:00:00	SPY	ETF	88.3	88.36	88.29	88.3	23745.0
2009-07-09 04:00:00	QQQ	ETF	34.83	34.88	34.82	34.88	1974.0
2009-07-09 05:00:00	QQQ	ETF	34.87	34.89	34.87	34.89	20650.0
2009-07-09 06:00:00	QQQ	ETF	34.87	34.91	34.85	34.85	700.0
2009-07-09 07:00:00	QQQ	ETF	34.85	34.89	34.79	34.88	264302.0
2009-07-09 08:00:00	QQQ	ETF	34.88	34.97	34.81	34.92	1239305.0
2009-07-09 09:00:00	QQQ	ETF	34.92	34.95	34.65	34.76	16810643.0
2009-07-09 10:00:00	QQQ	ETF	34.75	34.88	34.66	34.79	14182615.0
2009-07-09 11:00:00	QQQ	ETF	34.79	34.93	34.66	34.85	11046390.0
2009-07-09 12:00:00	QQQ	ETF	34.85	34.95	34.82	34.91	5906962.0
2009-07-09 13:00:00	QQQ	ETF	34.91	35.0	34.8	34.9	9531864.0
2009-07-09 14:00:00	QQQ	ETF	34.9005	35.01	34.87	34.92	9526831.0
2009-07-09 15:00:00	QQQ	ETF	34.92	34.95	34.73	34.77	15427381.0
2009-07-09 16:00:00	QQQ	ETF	34.77	34.83	34.7183	34.81	9838800.0
2009-07-09 17:00:00	QQQ	ETF	34.81	34.84	34.8	34.8	106201.0
2009-07-09 18:00:00	QQQ	ETF	34.8	34.83	34.8	34.83	16532.0
2009-07-09 19:00:00	QQQ	ETF	34.83	34.85	34.82	34.84	65450.0
2009-07-09 06:00:00	IWM	ETF	48.29	48.29	48.29	48.29	2000.0
2009-07-09 07:00:00	IWM	ETF	48.19	48.35	48.12	48.32	97946.0
2009-07-09 08:00:00	IWM	ETF	48.3	48.61	48.24	48.49	643110.0
2009-07-09 09:00:00	IWM	ETF	48.44	48.53	47.79	48.04	7419061.0
2009-07-09 10:00:00	IWM	ETF	48.04	48.26	47.89	48.15	7373830.0
2009-07-09 11:00:00	IWM	ETF	48.1512	48.29	47.895	48.16	4740129.0
2009-07-09 12:00:00	IWM	ETF	48.16	48.35	48.11	48.31	1220994.0
2009-07-09 13:00:00	IWM	ETF	48.31	48.38	48.1	48.26	4126253.0
2009-07-09 14:00:00	IWM	ETF	48.26	48.42	48.19	48.21	3019050.0
2009-07-09 15:00:00	IWM	ETF	48.2	48.26	47.87	47.9	8661787.0
2009-07-09 16:00:00	IWM	ETF	47.89	48.3	47.82	47.97	1118865.0
2009-07-09 17:00:00	IWM	ETF	47.97	47.97	47.94	47.96	5523.0
2009-07-09 18:00:00	IWM	ETF	47.94	47.98	47.94	47.98	1104.0
2009-07-09 05:00:00	DIA	ETF	82.31	82.35	82.31	82.35	200.0
2009-07-09 06:00:00	DIA	ETF	82.32	82.32	82.32	82.32	100.0
2009-07-09 07:00:00	DIA	ETF	82.25	82.27	82.14	82.27	25090.0
2009-07-09 08:00:00	DIA	ETF	82.27	82.47	82.21	82.35	148438.0
2009-07-09 09:00:00	DIA	ETF	82.32	82.41	81.76	81.95	1496408.0

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

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