PREVIEW / etf_1hour / 2010-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-16.parquet
  size:    162 KB
  rows:    4,933

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-16 04:00:00	SPY	ETF	109.37	109.42	109.34	109.34	5200.0
2010-07-16 05:00:00	SPY	ETF	109.37	109.75	109.37	109.75	8873.0
2010-07-16 06:00:00	SPY	ETF	109.77	109.96	109.72	109.88	52100.0
2010-07-16 07:00:00	SPY	ETF	109.8	109.99	109.53	109.61	1059929.0
2010-07-16 08:00:00	SPY	ETF	109.86	109.86	109.12	109.33	4182296.0
2010-07-16 09:00:00	SPY	ETF	109.34	109.59	107.9	108.05	38513425.0
2010-07-16 10:00:00	SPY	ETF	108.05	108.124	107.57	108.06	42644862.0
2010-07-16 11:00:00	SPY	ETF	108.06	108.12	107.32	107.36	29905624.0
2010-07-16 12:00:00	SPY	ETF	107.37	107.58	107.11	107.17	21553942.0
2010-07-16 13:00:00	SPY	ETF	107.1726	107.43	106.92	107.03	26954485.0
2010-07-16 14:00:00	SPY	ETF	107.03	107.22	106.85	106.9	21467654.0
2010-07-16 15:00:00	SPY	ETF	106.9	107.03	106.45	106.66	75417861.0
2010-07-16 16:00:00	SPY	ETF	106.66	109.7908	106.485	106.85	18708678.0
2010-07-16 17:00:00	SPY	ETF	106.84	109.7907	106.62	106.68	1292420.0
2010-07-16 18:00:00	SPY	ETF	106.67	106.76	106.63	106.74	38373.0
2010-07-16 19:00:00	SPY	ETF	106.74	106.78	106.62	106.62	47785.0
2010-07-16 05:00:00	QQQ	ETF	45.45	45.56	45.45	45.56	1000.0
2010-07-16 06:00:00	QQQ	ETF	45.56	45.59	45.56	45.59	7000.0
2010-07-16 07:00:00	QQQ	ETF	45.62	45.65	45.54	45.56	119863.0
2010-07-16 08:00:00	QQQ	ETF	45.56	45.6	45.47	45.49	663010.0
2010-07-16 09:00:00	QQQ	ETF	45.49	45.51	45.02	45.0734	17103841.0
2010-07-16 10:00:00	QQQ	ETF	45.07	45.09	44.77	44.94	14363278.0
2010-07-16 11:00:00	QQQ	ETF	44.93	44.97	44.59	44.61	8451645.0
2010-07-16 12:00:00	QQQ	ETF	44.6	45.6281	44.52	44.56	8158721.0
2010-07-16 13:00:00	QQQ	ETF	44.56	45.6281	44.46	44.52	15689293.0
2010-07-16 14:00:00	QQQ	ETF	44.52	44.62	44.47	44.51	10249315.0
2010-07-16 15:00:00	QQQ	ETF	44.52	44.58	44.3	44.35	14076691.0
2010-07-16 16:00:00	QQQ	ETF	44.35	45.6281	44.31	44.4	4441413.0
2010-07-16 17:00:00	QQQ	ETF	44.4	44.42	44.25	44.38	204425.0
2010-07-16 18:00:00	QQQ	ETF	44.37	44.41	44.36	44.4	11061.0
2010-07-16 19:00:00	QQQ	ETF	44.39	44.4	44.35	44.36	23366.0
2010-07-16 05:00:00	IWM	ETF	63.38	63.38	63.33	63.33	700.0
2010-07-16 06:00:00	IWM	ETF	63.39	63.53	63.39	63.5	8900.0
2010-07-16 07:00:00	IWM	ETF	63.47	63.52	63.2	63.23	93900.0
2010-07-16 08:00:00	IWM	ETF	63.23	63.25	63.0	63.09	819733.0
2010-07-16 09:00:00	IWM	ETF	63.12	63.17	61.99	62.11	14237201.0
2010-07-16 10:00:00	IWM	ETF	62.11	62.22	61.67	62.15	11638958.0
2010-07-16 11:00:00	IWM	ETF	62.15	62.19	61.74	61.75	6736762.0
2010-07-16 12:00:00	IWM	ETF	61.75	61.86	61.48	61.54	7091991.0
2010-07-16 13:00:00	IWM	ETF	61.54	61.735	61.36	61.45	8692582.0
2010-07-16 14:00:00	IWM	ETF	61.44	61.51	61.18	61.21	6445897.0
2010-07-16 15:00:00	IWM	ETF	61.22	61.5157	60.89	61.09	24790553.0
2010-07-16 16:00:00	IWM	ETF	61.1	63.4488	60.94	61.01	4746060.0
2010-07-16 17:00:00	IWM	ETF	61.01	63.4488	60.99	60.99	4061090.0
2010-07-16 18:00:00	IWM	ETF	60.98	61.04	60.98	61.0	4700.0
2010-07-16 19:00:00	IWM	ETF	60.98	61.01	60.97	61.01	2400.0
2010-07-16 07:00:00	DIA	ETF	103.65	103.65	103.39	103.39	8595.0
2010-07-16 08:00:00	DIA	ETF	103.44	103.51	103.19	103.25	194726.0
2010-07-16 09:00:00	DIA	ETF	103.3	103.3	101.9805	102.13	2194666.0
2010-07-16 10:00:00	DIA	ETF	102.13	102.18	101.72	102.13	2077653.0

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

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