PREVIEW / etf_1hour / 2012-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-12.parquet
  size:    181 KB
  rows:    5,564

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
2012-10-12 04:00:00	SPY	ETF	143.84	143.86	143.67	143.68	700.0
2012-10-12 05:00:00	SPY	ETF	143.77	143.8	143.58	143.72	39075.0
2012-10-12 06:00:00	SPY	ETF	143.68	143.94	143.68	143.89	272033.0
2012-10-12 07:00:00	SPY	ETF	143.89	144.02	143.74	144.01	372494.0
2012-10-12 08:00:00	SPY	ETF	144.01	144.01	143.63	143.71	1434447.0
2012-10-12 09:00:00	SPY	ETF	143.69	143.82	143.25	143.779	17048181.0
2012-10-12 10:00:00	SPY	ETF	143.78	143.95	143.35	143.44	17998986.0
2012-10-12 11:00:00	SPY	ETF	143.45	143.472	142.58	142.839	23600282.0
2012-10-12 12:00:00	SPY	ETF	142.84	142.99	142.72	142.855	11150777.0
2012-10-12 13:00:00	SPY	ETF	142.85	142.92	142.63	142.9	9211607.0
2012-10-12 14:00:00	SPY	ETF	142.9	143.47	142.79	143.052	10809757.0
2012-10-12 15:00:00	SPY	ETF	143.05	143.1	142.8	142.89	18049280.0
2012-10-12 16:00:00	SPY	ETF	142.88	143.5981	142.65	142.75	10627782.0
2012-10-12 17:00:00	SPY	ETF	142.76	142.85	142.74	142.84	645928.0
2012-10-12 18:00:00	SPY	ETF	142.87	142.88	142.82	142.82	95452.0
2012-10-12 19:00:00	SPY	ETF	142.85	142.85	142.8	142.8	22734.0
2012-10-12 04:00:00	QQQ	ETF	66.73	66.73	66.73	66.73	100.0
2012-10-12 06:00:00	QQQ	ETF	66.78	66.78	66.78	66.78	600.0
2012-10-12 07:00:00	QQQ	ETF	66.82	66.85	66.76	66.85	36320.0
2012-10-12 08:00:00	QQQ	ETF	66.84	66.9	66.76	66.82	215282.0
2012-10-12 09:00:00	QQQ	ETF	66.8	66.99	66.6117	66.99	3727757.0
2012-10-12 10:00:00	QQQ	ETF	66.99	67.06	66.84	66.96	3932966.0
2012-10-12 11:00:00	QQQ	ETF	66.97	66.97	66.55	66.7485	3854576.0
2012-10-12 12:00:00	QQQ	ETF	66.74	66.81	66.67	66.721	2018013.0
2012-10-12 13:00:00	QQQ	ETF	66.72	66.77	66.6	66.76	2501363.0
2012-10-12 14:00:00	QQQ	ETF	66.76	66.91	66.7	66.85	1979321.0
2012-10-12 15:00:00	QQQ	ETF	66.85	66.85	66.68	66.69	5066823.0
2012-10-12 16:00:00	QQQ	ETF	66.69	66.724	66.62	66.67	974645.0
2012-10-12 17:00:00	QQQ	ETF	66.62	66.65	66.62	66.62	3400.0
2012-10-12 18:00:00	QQQ	ETF	66.65	66.68	66.65	66.67	2185.0
2012-10-12 19:00:00	QQQ	ETF	66.66	66.66	66.65	66.65	2171.0
2012-10-12 07:00:00	IWM	ETF	82.94	83.09	82.94	83.09	2929.0
2012-10-12 08:00:00	IWM	ETF	83.04	83.05	82.85	82.92	93307.0
2012-10-12 09:00:00	IWM	ETF	82.86	82.88	82.5	82.8699	3857413.0
2012-10-12 10:00:00	IWM	ETF	82.87	83.02	82.46	82.61	4345952.0
2012-10-12 11:00:00	IWM	ETF	82.61	82.63	82.04	82.18	4833086.0
2012-10-12 12:00:00	IWM	ETF	82.18	82.27	82.07	82.13	2130849.0
2012-10-12 13:00:00	IWM	ETF	82.13	82.13	81.91	82.09	1995757.0
2012-10-12 14:00:00	IWM	ETF	82.09	82.35	82.01	82.25	3118157.0
2012-10-12 15:00:00	IWM	ETF	82.25	82.26	82.02	82.07	5017164.0
2012-10-12 16:00:00	IWM	ETF	82.07	82.314	81.96	82.02	4085040.0
2012-10-12 17:00:00	IWM	ETF	82.03	82.07	82.03	82.07	6592.0
2012-10-12 06:00:00	DIA	ETF	133.36	133.36	133.36	133.36	500.0
2012-10-12 07:00:00	DIA	ETF	133.4	133.48	133.39	133.48	1900.0
2012-10-12 08:00:00	DIA	ETF	133.53	133.53	132.17	133.43	29530.0
2012-10-12 09:00:00	DIA	ETF	133.33	133.72	133.19	133.69	473588.0
2012-10-12 10:00:00	DIA	ETF	133.68	133.83	133.35	133.45	365561.0
2012-10-12 11:00:00	DIA	ETF	133.46	133.48	132.79	132.99	627314.0
2012-10-12 12:00:00	DIA	ETF	132.98	133.09	132.85	132.96	244484.0
2012-10-12 13:00:00	DIA	ETF	132.95	133.01	132.75	133.01	278493.0

> showing 50 of 5,564 rows — these rows as CSV

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