PREVIEW / etf_1hour / 2010-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-15.parquet
  size:    160 KB
  rows:    4,883

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-07-15 04:00:00	SPY	ETF	109.38	109.78	109.3	109.67	5883.0
2010-07-15 05:00:00	SPY	ETF	109.68	109.68	109.6	109.6	2200.0
2010-07-15 06:00:00	SPY	ETF	109.62	110.08	109.62	110.08	262250.0
2010-07-15 07:00:00	SPY	ETF	110.03	110.08	109.85	109.97	1359868.0
2010-07-15 08:00:00	SPY	ETF	110.25	110.44	109.66	109.7	6762411.0
2010-07-15 09:00:00	SPY	ETF	109.71	109.94	109.19	109.4	23323356.0
2010-07-15 10:00:00	SPY	ETF	109.4	109.47	108.17	108.6	47725755.0
2010-07-15 11:00:00	SPY	ETF	108.6	108.85	108.4	108.63	20861557.0
2010-07-15 12:00:00	SPY	ETF	108.63	108.73	108.44	108.63	11504360.0
2010-07-15 13:00:00	SPY	ETF	108.63	109.25	108.63	109.05	18818880.0
2010-07-15 14:00:00	SPY	ETF	109.04	109.6667	108.88	109.125	21426795.0
2010-07-15 15:00:00	SPY	ETF	109.125	110.06	108.64	109.72	65138346.0
2010-07-15 16:00:00	SPY	ETF	109.72	109.98	108.1757	109.82	13377068.0
2010-07-15 17:00:00	SPY	ETF	109.82	109.99	109.81	109.95	353427.0
2010-07-15 18:00:00	SPY	ETF	109.94	109.96	109.68	109.93	651272.0
2010-07-15 19:00:00	SPY	ETF	109.91	109.95	109.86	109.91	81783.0
2010-07-15 04:00:00	QQQ	ETF	45.64	45.64	45.64	45.64	2700.0
2010-07-15 06:00:00	QQQ	ETF	45.6	45.79	45.6	45.79	23682.0
2010-07-15 07:00:00	QQQ	ETF	45.75	45.78	45.7	45.71	224995.0
2010-07-15 08:00:00	QQQ	ETF	45.7	45.88	45.57	45.58	1239403.0
2010-07-15 09:00:00	QQQ	ETF	45.59	45.67	45.33	45.51	12175569.0
2010-07-15 10:00:00	QQQ	ETF	45.51	45.5199	44.99	45.17	19658333.0
2010-07-15 11:00:00	QQQ	ETF	45.18	45.33	45.07	45.24	6530686.0
2010-07-15 12:00:00	QQQ	ETF	45.2306	45.29	45.115	45.2	3471603.0
2010-07-15 13:00:00	QQQ	ETF	45.21	45.44	45.21	45.34	6248333.0
2010-07-15 14:00:00	QQQ	ETF	45.34	45.52	45.28	45.4	7735234.0
2010-07-15 15:00:00	QQQ	ETF	45.41	45.74	45.21	45.61	21041988.0
2010-07-15 16:00:00	QQQ	ETF	45.61	45.691	45.3528	45.57	13022760.0
2010-07-15 17:00:00	QQQ	ETF	45.58	45.64	45.58	45.61	426738.0
2010-07-15 18:00:00	QQQ	ETF	45.61	45.67	45.61	45.64	90430.0
2010-07-15 19:00:00	QQQ	ETF	45.65	45.67	45.62	45.62	43572.0
2010-07-15 06:00:00	IWM	ETF	64.17	64.37	64.17	64.34	13300.0
2010-07-15 07:00:00	IWM	ETF	64.38	64.41	64.25	64.33	213100.0
2010-07-15 08:00:00	IWM	ETF	64.4	64.51	64.08	64.13	454100.0
2010-07-15 09:00:00	IWM	ETF	64.14	64.29	63.63	63.82	7635094.0
2010-07-15 10:00:00	IWM	ETF	63.81	63.82	62.61	62.95	13151334.0
2010-07-15 11:00:00	IWM	ETF	62.95	63.15	62.73	62.94	7587441.0
2010-07-15 12:00:00	IWM	ETF	62.93	63.01	62.7	62.85	3803900.0
2010-07-15 13:00:00	IWM	ETF	62.85	63.32	62.85	63.1	7751913.0
2010-07-15 14:00:00	IWM	ETF	63.09	63.4	62.98	63.12	7604874.0
2010-07-15 15:00:00	IWM	ETF	63.11	63.64	62.74	63.38	17895019.0
2010-07-15 16:00:00	IWM	ETF	63.37	63.5369	63.0335	63.32	1608457.0
2010-07-15 17:00:00	IWM	ETF	63.38	63.48	63.36	63.47	27873.0
2010-07-15 18:00:00	IWM	ETF	63.44	63.5	63.44	63.5	7636.0
2010-07-15 19:00:00	IWM	ETF	63.49	63.54	63.43	63.46	1700.0
2010-07-15 06:00:00	DIA	ETF	103.93	103.99	103.93	103.99	1000.0
2010-07-15 07:00:00	DIA	ETF	104.0	104.0	104.0	104.0	100.0
2010-07-15 08:00:00	DIA	ETF	103.95	104.29	103.74	103.74	93482.0
2010-07-15 09:00:00	DIA	ETF	103.77	103.92	103.26	103.47	1528933.0
2010-07-15 10:00:00	DIA	ETF	103.47	103.47	102.49	102.82	3231244.0

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

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