PREVIEW / etf_1hour / 2010-05-28

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-28.parquet
  size:    160 KB
  rows:    4,867

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-28 04:00:00	SPY	ETF	110.59	110.88	110.49	110.88	1650.0
2010-05-28 05:00:00	SPY	ETF	110.7	110.85	110.7	110.85	55423.0
2010-05-28 06:00:00	SPY	ETF	110.85	110.9	110.66	110.7	11800.0
2010-05-28 07:00:00	SPY	ETF	110.77	111.18	110.66	111.01	697751.0
2010-05-28 08:00:00	SPY	ETF	111.05	111.14	110.61	110.7	3178756.0
2010-05-28 09:00:00	SPY	ETF	110.71	110.99	109.92	110.4	34090806.0
2010-05-28 10:00:00	SPY	ETF	110.39	110.724	109.8	110.02	40545782.0
2010-05-28 11:00:00	SPY	ETF	110.01	110.25	109.565	110.07	30102850.0
2010-05-28 12:00:00	SPY	ETF	110.0699	110.6693	108.97	109.53	52656694.0
2010-05-28 13:00:00	SPY	ETF	109.53	109.77	109.15	109.2	21471965.0
2010-05-28 14:00:00	SPY	ETF	109.2	110.16	108.85	109.84	32965915.0
2010-05-28 15:00:00	SPY	ETF	109.83	110.46	109.24	109.35	54184372.0
2010-05-28 16:00:00	SPY	ETF	109.39	110.7232	108.94	109.01	16436668.0
2010-05-28 17:00:00	SPY	ETF	109.04	110.7235	108.91	108.98	2392204.0
2010-05-28 18:00:00	SPY	ETF	108.99	109.5	108.94	109.34	339542.0
2010-05-28 19:00:00	SPY	ETF	109.34	109.44	109.24	109.37	59861.0
2010-05-28 06:00:00	QQQ	ETF	45.98	45.98	45.9	45.9	1222.0
2010-05-28 07:00:00	QQQ	ETF	45.97	46.17	45.93	46.08	591592.0
2010-05-28 08:00:00	QQQ	ETF	46.08	46.15	45.92	45.94	1001016.0
2010-05-28 09:00:00	QQQ	ETF	45.94	46.0	45.65	45.85	13977660.0
2010-05-28 10:00:00	QQQ	ETF	45.85	45.98	45.58	45.67	16508596.0
2010-05-28 11:00:00	QQQ	ETF	45.66	45.71	45.38	45.61	12294808.0
2010-05-28 12:00:00	QQQ	ETF	45.62	45.78	45.22	45.42	28337507.0
2010-05-28 13:00:00	QQQ	ETF	45.42	45.52	45.31	45.355	12039999.0
2010-05-28 14:00:00	QQQ	ETF	45.34	45.8	45.2	45.705	10288601.0
2010-05-28 15:00:00	QQQ	ETF	45.7	45.99	45.57	45.61	19786510.0
2010-05-28 16:00:00	QQQ	ETF	45.62	45.7108	45.3176	45.59	3763639.0
2010-05-28 17:00:00	QQQ	ETF	45.58	45.59	45.45	45.48	70800.0
2010-05-28 18:00:00	QQQ	ETF	45.55	45.73	45.55	45.69	133642.0
2010-05-28 19:00:00	QQQ	ETF	45.62	45.7	45.62	45.69	4800.0
2010-05-28 06:00:00	IWM	ETF	67.19	67.19	67.0	67.0	630.0
2010-05-28 07:00:00	IWM	ETF	67.07	67.34	66.98	67.21	84630.0
2010-05-28 08:00:00	IWM	ETF	67.21	67.34	66.99	67.01	560550.0
2010-05-28 09:00:00	IWM	ETF	67.0	67.1	66.25	66.77	10402150.0
2010-05-28 10:00:00	IWM	ETF	66.77	67.17	66.43	66.59	12749856.0
2010-05-28 11:00:00	IWM	ETF	66.58	66.7	66.1	66.52	10088166.0
2010-05-28 12:00:00	IWM	ETF	66.5285	66.75	65.94	66.17	14323511.0
2010-05-28 13:00:00	IWM	ETF	66.18	66.34	65.95	65.98	5890721.0
2010-05-28 14:00:00	IWM	ETF	65.98	66.7	65.73	66.41	7648468.0
2010-05-28 15:00:00	IWM	ETF	66.41	66.9912	66.19	66.25	16024484.0
2010-05-28 16:00:00	IWM	ETF	66.25	67.1476	65.9933	66.05	4811132.0
2010-05-28 17:00:00	IWM	ETF	66.05	66.16	66.05	66.13	8607.0
2010-05-28 18:00:00	IWM	ETF	66.15	66.23	66.15	66.21	5630.0
2010-05-28 19:00:00	IWM	ETF	66.24	66.24	66.24	66.24	100.0
2010-05-28 07:00:00	DIA	ETF	102.7	102.82	102.7	102.82	3200.0
2010-05-28 08:00:00	DIA	ETF	102.82	102.9	102.55	102.6	43481.0
2010-05-28 09:00:00	DIA	ETF	102.6	102.74	101.97	102.32	2765432.0
2010-05-28 10:00:00	DIA	ETF	102.32	102.5	101.88	102.03	3455330.0
2010-05-28 11:00:00	DIA	ETF	102.02	102.27	101.72	102.09	1892780.0
2010-05-28 12:00:00	DIA	ETF	102.08	102.29	101.1	101.54	3735003.0

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

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