PREVIEW / etf_1hour / 2007-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-16.parquet
  size:    78 KB
  rows:    2,607

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
2007-05-16 05:00:00	SPY	ETF	150.55	150.55	150.55	150.55	1000.0
2007-05-16 06:00:00	SPY	ETF	150.53	150.59	150.52	150.59	13000.0
2007-05-16 07:00:00	SPY	ETF	150.5	150.82	150.5	150.8	373800.0
2007-05-16 08:00:00	SPY	ETF	150.72	151.09	150.69	150.73	2526600.0
2007-05-16 09:00:00	SPY	ETF	150.73	151.1	150.72	150.9	17180644.0
2007-05-16 10:00:00	SPY	ETF	150.89	151.14	150.57	150.66	20835215.0
2007-05-16 11:00:00	SPY	ETF	150.67	151.0	150.38	150.9	18684798.0
2007-05-16 12:00:00	SPY	ETF	150.89	150.94	150.5	150.9	8871700.0
2007-05-16 13:00:00	SPY	ETF	150.91	151.2	150.69	151.0	11450997.0
2007-05-16 14:00:00	SPY	ETF	151.0	151.37	150.98	151.26	9958900.0
2007-05-16 15:00:00	SPY	ETF	151.25	151.63	151.11	151.61	19419473.0
2007-05-16 16:00:00	SPY	ETF	151.6	151.67	151.52	151.54	2647300.0
2007-05-16 17:00:00	SPY	ETF	151.52	151.54	151.36	151.44	207100.0
2007-05-16 18:00:00	SPY	ETF	151.44	151.47	151.42	151.47	345300.0
2007-05-16 19:00:00	SPY	ETF	151.47	151.47	151.43	151.43	1500.0
2007-05-16 07:00:00	QQQ	ETF	46.14	46.24	46.13	46.23	778049.0
2007-05-16 08:00:00	QQQ	ETF	46.2	46.31	46.18	46.19	1659696.0
2007-05-16 09:00:00	QQQ	ETF	46.19	46.33	46.16	46.25	21091641.0
2007-05-16 10:00:00	QQQ	ETF	46.24	46.32	46.04	46.1001	19550300.0
2007-05-16 11:00:00	QQQ	ETF	46.1	46.25	45.91	46.19	29750796.0
2007-05-16 12:00:00	QQQ	ETF	46.2	46.25	46.06	46.24	18985956.0
2007-05-16 13:00:00	QQQ	ETF	46.2386	46.31	46.116	46.25	17055304.0
2007-05-16 14:00:00	QQQ	ETF	46.25	46.39	46.23	46.33	11494811.0
2007-05-16 15:00:00	QQQ	ETF	46.34	46.55	46.27	46.54	17988425.0
2007-05-16 16:00:00	QQQ	ETF	46.53	46.6	46.52	46.55	1783466.0
2007-05-16 17:00:00	QQQ	ETF	46.55	46.57	46.52	46.53	425702.0
2007-05-16 18:00:00	QQQ	ETF	46.53	46.55	46.5	46.55	59953.0
2007-05-16 19:00:00	QQQ	ETF	46.52	46.53	46.52	46.52	4750.0
2007-05-16 07:00:00	IWM	ETF	81.11	81.17	81.11	81.17	3100.0
2007-05-16 08:00:00	IWM	ETF	81.03	81.25	81.03	81.1	544900.0
2007-05-16 09:00:00	IWM	ETF	81.11	81.23	80.9	80.99	13066527.0
2007-05-16 10:00:00	IWM	ETF	80.99	81.06	80.6	80.76	19957859.0
2007-05-16 11:00:00	IWM	ETF	80.76	81.0	80.46	80.78	17417783.0
2007-05-16 12:00:00	IWM	ETF	80.78	80.81	80.56	80.73	10829753.0
2007-05-16 13:00:00	IWM	ETF	80.73	81.07	80.65	80.94	6072000.0
2007-05-16 14:00:00	IWM	ETF	80.93	81.33	80.91	81.19	8653573.0
2007-05-16 15:00:00	IWM	ETF	81.19	81.5	81.0	81.5	11396971.0
2007-05-16 16:00:00	IWM	ETF	81.5	81.5	80.6506	81.41	1686700.0
2007-05-16 17:00:00	IWM	ETF	81.41	81.43	81.4	81.43	1306800.0
2007-05-16 18:00:00	IWM	ETF	81.37	81.37	81.37	81.37	100.0
2007-05-16 19:00:00	IWM	ETF	81.36	81.36	81.36	81.36	500.0
2007-05-16 07:00:00	DIA	ETF	134.23	134.39	134.23	134.39	6000.0
2007-05-16 08:00:00	DIA	ETF	134.37	134.5	134.23	134.31	54800.0
2007-05-16 09:00:00	DIA	ETF	134.31	134.62	134.29	134.48	2093449.0
2007-05-16 10:00:00	DIA	ETF	134.48	134.64	133.99	134.07	3480843.0
2007-05-16 11:00:00	DIA	ETF	134.08	134.5	133.85	134.45	2739596.0
2007-05-16 12:00:00	DIA	ETF	134.45	134.48	134.16	134.44	1300000.0
2007-05-16 13:00:00	DIA	ETF	134.42	134.7	134.3	134.55	1081650.0
2007-05-16 14:00:00	DIA	ETF	134.54	134.79	134.53	134.72	1335001.0
2007-05-16 15:00:00	DIA	ETF	134.71	135.12	134.6	135.11	2419600.0

> showing 50 of 2,607 rows — these rows as CSV

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