PREVIEW / etf_1hour / 2010-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-14.parquet
  size:    163 KB
  rows:    4,937

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-14 04:00:00	SPY	ETF	110.06	110.46	110.06	110.46	9100.0
2010-06-14 05:00:00	SPY	ETF	110.42	110.52	110.35	110.48	14400.0
2010-06-14 06:00:00	SPY	ETF	110.32	110.38	110.25	110.25	83237.0
2010-06-14 07:00:00	SPY	ETF	110.25	110.36	110.12	110.35	276960.0
2010-06-14 08:00:00	SPY	ETF	110.32	110.52	110.27	110.4	1221483.0
2010-06-14 09:00:00	SPY	ETF	110.39	110.59	110.11	110.27	24759451.0
2010-06-14 10:00:00	SPY	ETF	110.27	110.75	110.21	110.72	25968952.0
2010-06-14 11:00:00	SPY	ETF	110.72	111.12	110.62	110.76	25238301.0
2010-06-14 12:00:00	SPY	ETF	110.76	110.92	110.4	110.4	13852778.0
2010-06-14 13:00:00	SPY	ETF	110.4	110.68	110.03	110.04	25395141.0
2010-06-14 14:00:00	SPY	ETF	110.04	110.28	109.77	110.2226	29922634.0
2010-06-14 15:00:00	SPY	ETF	110.22	110.38	109.4	109.52	45427547.0
2010-06-14 16:00:00	SPY	ETF	109.54	111.0307	109.43	109.52	14612571.0
2010-06-14 17:00:00	SPY	ETF	109.56	109.62	109.52	109.54	131992.0
2010-06-14 18:00:00	SPY	ETF	109.54	109.66	109.48	109.52	197568.0
2010-06-14 19:00:00	SPY	ETF	109.5	109.6	109.49	109.55	44884.0
2010-06-14 04:00:00	QQQ	ETF	45.72	45.78	45.7	45.78	390.0
2010-06-14 05:00:00	QQQ	ETF	45.8	45.82	45.8	45.81	2300.0
2010-06-14 06:00:00	QQQ	ETF	45.74	45.74	45.73	45.73	300.0
2010-06-14 07:00:00	QQQ	ETF	45.71	45.79	45.67	45.77	55459.0
2010-06-14 08:00:00	QQQ	ETF	45.77	45.88	45.48	45.85	527576.0
2010-06-14 09:00:00	QQQ	ETF	45.85	46.04	45.8	45.93	8187621.0
2010-06-14 10:00:00	QQQ	ETF	45.93	46.16	45.92	46.1	7949491.0
2010-06-14 11:00:00	QQQ	ETF	46.1	46.24	46.06	46.07	7294462.0
2010-06-14 12:00:00	QQQ	ETF	46.08	46.155	45.92	45.92	4220230.0
2010-06-14 13:00:00	QQQ	ETF	45.92	46.03	45.72	45.72	10380943.0
2010-06-14 14:00:00	QQQ	ETF	45.72	45.8	45.57	45.77	10080509.0
2010-06-14 15:00:00	QQQ	ETF	45.77	45.86	45.41	45.48	13712445.0
2010-06-14 16:00:00	QQQ	ETF	45.48	46.008	45.414	45.49	2458764.0
2010-06-14 17:00:00	QQQ	ETF	45.52	45.53	45.49	45.51	13228.0
2010-06-14 18:00:00	QQQ	ETF	45.52	45.55	45.51	45.52	47030.0
2010-06-14 19:00:00	QQQ	ETF	45.51	45.55	45.51	45.54	23845.0
2010-06-14 06:00:00	IWM	ETF	65.56	65.59	65.56	65.59	563.0
2010-06-14 07:00:00	IWM	ETF	65.58	65.6	65.5	65.6	21200.0
2010-06-14 08:00:00	IWM	ETF	65.6	65.74	65.56	65.7	511764.0
2010-06-14 09:00:00	IWM	ETF	65.68	65.91	65.52	65.78	7190175.0
2010-06-14 10:00:00	IWM	ETF	65.77	66.23	65.65	66.195	7868363.0
2010-06-14 11:00:00	IWM	ETF	66.2	66.5	66.15	66.29	6535082.0
2010-06-14 12:00:00	IWM	ETF	66.3	66.4	65.97	65.97	3996781.0
2010-06-14 13:00:00	IWM	ETF	65.97	66.23	65.76	65.77	7178472.0
2010-06-14 14:00:00	IWM	ETF	65.76	65.84	65.34	65.788	10259897.0
2010-06-14 15:00:00	IWM	ETF	65.79	65.9675	65.16	65.33	13544603.0
2010-06-14 16:00:00	IWM	ETF	65.33	66.1	65.022	65.39	9052126.0
2010-06-14 17:00:00	IWM	ETF	65.42	65.43	65.41	65.43	1300.0
2010-06-14 18:00:00	IWM	ETF	65.4	65.46	65.37	65.46	4000.0
2010-06-14 19:00:00	IWM	ETF	65.4	65.49	65.36	65.48	2600.0
2010-06-14 05:00:00	DIA	ETF	102.95	103.05	102.95	103.05	2800.0
2010-06-14 07:00:00	DIA	ETF	102.82	102.82	102.79	102.79	1600.0
2010-06-14 08:00:00	DIA	ETF	102.87	103.0	102.87	102.92	22575.0
2010-06-14 09:00:00	DIA	ETF	102.92	103.05	102.66	102.79	1259546.0

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

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