PREVIEW / etf_1hour / 2010-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-28.parquet
  size:    154 KB
  rows:    4,782

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-06-28 04:00:00	SPY	ETF	108.1	108.34	108.1	108.34	3700.0
2010-06-28 05:00:00	SPY	ETF	108.36	108.39	108.27	108.3	6710.0
2010-06-28 06:00:00	SPY	ETF	108.39	108.39	108.19	108.19	15900.0
2010-06-28 07:00:00	SPY	ETF	108.19	108.35	108.19	108.26	1016165.0
2010-06-28 08:00:00	SPY	ETF	108.26	108.29	107.72	107.91	6426309.0
2010-06-28 09:00:00	SPY	ETF	107.92	108.12	107.14	107.35	25533924.0
2010-06-28 10:00:00	SPY	ETF	107.35	107.97	107.25	107.95	35335587.0
2010-06-28 11:00:00	SPY	ETF	107.95	108.32	107.89	108.0	19413203.0
2010-06-28 12:00:00	SPY	ETF	107.995	108.15	107.66	107.94	17850006.0
2010-06-28 13:00:00	SPY	ETF	107.95	107.95	107.49	107.82	11874229.0
2010-06-28 14:00:00	SPY	ETF	107.83	108.07	107.68	108.03	13436969.0
2010-06-28 15:00:00	SPY	ETF	108.0299	108.13	107.48	107.48	28773486.0
2010-06-28 16:00:00	SPY	ETF	107.49	108.19	107.4	107.52	6697163.0
2010-06-28 17:00:00	SPY	ETF	107.52	107.59	107.45	107.48	435488.0
2010-06-28 18:00:00	SPY	ETF	107.49	107.59	107.42	107.48	372861.0
2010-06-28 19:00:00	SPY	ETF	107.48	107.68	107.47	107.68	60288.0
2010-06-28 04:00:00	QQQ	ETF	45.32	45.39	45.32	45.39	1700.0
2010-06-28 05:00:00	QQQ	ETF	45.38	45.43	45.38	45.43	17795.0
2010-06-28 06:00:00	QQQ	ETF	45.38	45.43	45.35	45.35	5300.0
2010-06-28 07:00:00	QQQ	ETF	45.36	45.44	45.36	45.39	118880.0
2010-06-28 08:00:00	QQQ	ETF	45.39	45.4	45.14	45.23	3421331.0
2010-06-28 09:00:00	QQQ	ETF	45.22	45.34	44.94	45.04	11463955.0
2010-06-28 10:00:00	QQQ	ETF	45.04	45.33	44.81	45.31	16579594.0
2010-06-28 11:00:00	QQQ	ETF	45.32	45.55	45.315	45.4	6882582.0
2010-06-28 12:00:00	QQQ	ETF	45.4	45.42	45.21	45.33	7171837.0
2010-06-28 13:00:00	QQQ	ETF	45.33	45.335	45.12	45.28	4026784.0
2010-06-28 14:00:00	QQQ	ETF	45.28	45.38	45.19	45.34	5572074.0
2010-06-28 15:00:00	QQQ	ETF	45.34	45.41	45.11	45.11	11094912.0
2010-06-28 16:00:00	QQQ	ETF	45.1	45.3585	45.04	45.27	3346767.0
2010-06-28 17:00:00	QQQ	ETF	45.08	45.12	45.08	45.11	37849.0
2010-06-28 18:00:00	QQQ	ETF	45.1	45.1	45.05	45.06	10650.0
2010-06-28 19:00:00	QQQ	ETF	45.05	45.16	45.05	45.16	22950.0
2010-06-28 06:00:00	IWM	ETF	64.89	64.9	64.8	64.8	15500.0
2010-06-28 07:00:00	IWM	ETF	64.83	64.89	64.79	64.83	47800.0
2010-06-28 08:00:00	IWM	ETF	64.82	64.89	64.38	64.5	1011495.0
2010-06-28 09:00:00	IWM	ETF	64.48	64.7	63.95	64.08	8693496.0
2010-06-28 10:00:00	IWM	ETF	64.09	64.73	63.91	64.71	9232806.0
2010-06-28 11:00:00	IWM	ETF	64.72	65.24	64.72	64.82	7392657.0
2010-06-28 12:00:00	IWM	ETF	64.81	64.86	64.43	64.66	5435846.0
2010-06-28 13:00:00	IWM	ETF	64.66	64.66	64.2299	64.55	3598467.0
2010-06-28 14:00:00	IWM	ETF	64.55	64.76	64.42	64.76	3183344.0
2010-06-28 15:00:00	IWM	ETF	64.76	64.79	64.23	64.25	11801132.0
2010-06-28 16:00:00	IWM	ETF	64.25	64.7262	64.23	64.4	10351859.0
2010-06-28 17:00:00	IWM	ETF	64.39	64.39	64.34	64.36	700.0
2010-06-28 18:00:00	IWM	ETF	64.41	64.42	64.3	64.32	4500.0
2010-06-28 19:00:00	IWM	ETF	64.3	64.38	64.27	64.38	1947.0
2010-06-28 06:00:00	DIA	ETF	101.85	101.85	101.85	101.85	200.0
2010-06-28 07:00:00	DIA	ETF	101.87	101.89	101.85	101.89	8500.0
2010-06-28 08:00:00	DIA	ETF	101.87	101.87	101.41	101.58	48758.0
2010-06-28 09:00:00	DIA	ETF	101.55	101.78	101.04	101.2	1756160.0

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

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