PREVIEW / etf_1hour / 2010-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-13.parquet
  size:    164 KB
  rows:    5,011

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
2010-05-13 04:00:00	SPY	ETF	117.38	117.38	117.15	117.15	3134.0
2010-05-13 05:00:00	SPY	ETF	117.15	117.3	117.09	117.22	35900.0
2010-05-13 06:00:00	SPY	ETF	117.23	117.46	117.23	117.45	21600.0
2010-05-13 07:00:00	SPY	ETF	117.41	117.71	117.36	117.55	602847.0
2010-05-13 08:00:00	SPY	ETF	117.56	117.79	116.96	117.23	3473834.0
2010-05-13 09:00:00	SPY	ETF	117.22	117.45	116.67	117.08	32683664.0
2010-05-13 10:00:00	SPY	ETF	117.08	117.68	116.94	117.3	32591268.0
2010-05-13 11:00:00	SPY	ETF	117.3	117.44	116.85	116.9	26276179.0
2010-05-13 12:00:00	SPY	ETF	116.9	117.3566	116.85	117.06	16438988.0
2010-05-13 13:00:00	SPY	ETF	117.06	117.45	116.96	117.23	19139629.0
2010-05-13 14:00:00	SPY	ETF	117.24	117.44	116.74	116.85	17694506.0
2010-05-13 15:00:00	SPY	ETF	116.84	117.4	115.89	116.0	70502017.0
2010-05-13 16:00:00	SPY	ETF	115.99	117.62	115.961	116.04	14042522.0
2010-05-13 17:00:00	SPY	ETF	116.04	116.13	115.95	116.0	282956.0
2010-05-13 18:00:00	SPY	ETF	116.02	116.16	115.99	116.04	109338.0
2010-05-13 19:00:00	SPY	ETF	116.03	116.04	115.96	116.0	35400.0
2010-05-13 05:00:00	QQQ	ETF	48.42	48.43	48.42	48.43	300.0
2010-05-13 06:00:00	QQQ	ETF	48.52	48.52	48.45	48.45	4500.0
2010-05-13 07:00:00	QQQ	ETF	48.51	48.65	48.47	48.58	72535.0
2010-05-13 08:00:00	QQQ	ETF	48.6	48.66	48.43	48.43	1069355.0
2010-05-13 09:00:00	QQQ	ETF	48.44	48.72	48.32	48.629	16364048.0
2010-05-13 10:00:00	QQQ	ETF	48.62	48.79	48.53	48.61	15685399.0
2010-05-13 11:00:00	QQQ	ETF	48.61	48.66	48.3	48.31	10258250.0
2010-05-13 12:00:00	QQQ	ETF	48.31	48.63	48.26	48.3338	7038515.0
2010-05-13 13:00:00	QQQ	ETF	48.34	48.52	48.27	48.37	10026523.0
2010-05-13 14:00:00	QQQ	ETF	48.37	48.49	48.2	48.24	7941096.0
2010-05-13 15:00:00	QQQ	ETF	48.24	48.31	47.7301	47.84	23586957.0
2010-05-13 16:00:00	QQQ	ETF	47.84	48.725	47.83	47.86	6106789.0
2010-05-13 17:00:00	QQQ	ETF	47.88	47.88	47.84	47.87	37675.0
2010-05-13 18:00:00	QQQ	ETF	47.87	47.9	47.82	47.84	24024.0
2010-05-13 19:00:00	QQQ	ETF	47.86	47.87	47.85	47.87	6636.0
2010-05-13 06:00:00	IWM	ETF	71.4	71.4	71.4	71.4	400.0
2010-05-13 07:00:00	IWM	ETF	71.4	71.78	71.4	71.72	43090.0
2010-05-13 08:00:00	IWM	ETF	71.73	71.91	71.17	71.51	557144.0
2010-05-13 09:00:00	IWM	ETF	71.52	71.62	71.025	71.36	9692875.0
2010-05-13 10:00:00	IWM	ETF	71.36	72.1	71.25	71.758	14798644.0
2010-05-13 11:00:00	IWM	ETF	71.76	71.83	71.28	71.36	10262707.0
2010-05-13 12:00:00	IWM	ETF	71.35	71.48	71.29	71.4	5975294.0
2010-05-13 13:00:00	IWM	ETF	71.4	71.74	71.27	71.57	5416034.0
2010-05-13 14:00:00	IWM	ETF	71.56	71.66	71.11	71.18	4969816.0
2010-05-13 15:00:00	IWM	ETF	71.18	71.45	70.59	70.93	18020065.0
2010-05-13 16:00:00	IWM	ETF	70.93	71.659	70.895	71.11	6157229.0
2010-05-13 17:00:00	IWM	ETF	71.1	71.11	71.03	71.05	70385.0
2010-05-13 18:00:00	IWM	ETF	70.92	71.06	70.91	70.92	2200.0
2010-05-13 19:00:00	IWM	ETF	71.0	71.0	70.97	70.97	1000.0
2010-05-13 05:00:00	DIA	ETF	109.03	109.03	109.03	109.03	2500.0
2010-05-13 07:00:00	DIA	ETF	109.46	109.5	109.46	109.47	21100.0
2010-05-13 08:00:00	DIA	ETF	109.39	109.56	109.04	109.04	29720.0
2010-05-13 09:00:00	DIA	ETF	109.03	109.21	108.54	108.95	1948446.0
2010-05-13 10:00:00	DIA	ETF	108.95	109.46	108.76	109.19	1690628.0

> showing 50 of 5,011 rows — these rows as CSV

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