PREVIEW / etf_1hour / 2012-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-15.parquet
  size:    184 KB
  rows:    5,672

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-15 04:00:00	SPY	ETF	143.35	143.37	143.35	143.37	2650.0
2012-10-15 05:00:00	SPY	ETF	143.29	143.45	143.29	143.37	4160.0
2012-10-15 06:00:00	SPY	ETF	143.38	143.41	143.3	143.33	14720.0
2012-10-15 07:00:00	SPY	ETF	143.39	143.46	143.32	143.42	275289.0
2012-10-15 08:00:00	SPY	ETF	143.44	143.64	143.23	143.29	1232243.0
2012-10-15 09:00:00	SPY	ETF	143.29	143.4	142.95	143.11	13546072.0
2012-10-15 10:00:00	SPY	ETF	143.11	143.28	142.77	143.02	14853328.0
2012-10-15 11:00:00	SPY	ETF	143.02	143.7	142.93	143.508	13086543.0
2012-10-15 12:00:00	SPY	ETF	143.51	143.96	143.47	143.8	9433133.0
2012-10-15 13:00:00	SPY	ETF	143.81	143.99	143.69	143.802	6514204.0
2012-10-15 14:00:00	SPY	ETF	143.8	143.9	143.49	143.61	10286873.0
2012-10-15 15:00:00	SPY	ETF	143.615	144.23	143.57	144.08	22930464.0
2012-10-15 16:00:00	SPY	ETF	144.06	144.2	143.203	144.17	6078034.0
2012-10-15 17:00:00	SPY	ETF	144.17	144.18	144.1	144.14	71239.0
2012-10-15 18:00:00	SPY	ETF	144.15	144.28	144.12	144.27	94365.0
2012-10-15 19:00:00	SPY	ETF	144.27	144.37	144.19	144.35	146479.0
2012-10-15 04:00:00	QQQ	ETF	67.01	67.01	66.98	66.98	700.0
2012-10-15 05:00:00	QQQ	ETF	67.06	67.06	67.06	67.06	500.0
2012-10-15 06:00:00	QQQ	ETF	66.99	67.0	66.99	67.0	700.0
2012-10-15 07:00:00	QQQ	ETF	67.04	67.06	67.02	67.05	28900.0
2012-10-15 08:00:00	QQQ	ETF	67.04	67.11	66.96	66.96	243581.0
2012-10-15 09:00:00	QQQ	ETF	66.97	67.06	66.76	66.8401	3343323.0
2012-10-15 10:00:00	QQQ	ETF	66.84	66.91	66.53	66.62	4349045.0
2012-10-15 11:00:00	QQQ	ETF	66.61	67.03	66.56	66.88	2733605.0
2012-10-15 12:00:00	QQQ	ETF	66.89	67.08	66.82	66.98	2294523.0
2012-10-15 13:00:00	QQQ	ETF	66.98	67.08	66.865	66.91	1924243.0
2012-10-15 14:00:00	QQQ	ETF	66.92	67.01	66.79	66.87	1655086.0
2012-10-15 15:00:00	QQQ	ETF	66.875	67.26	66.85	67.17	4519410.0
2012-10-15 16:00:00	QQQ	ETF	67.17	67.2697	66.9082	67.15	725166.0
2012-10-15 17:00:00	QQQ	ETF	67.16	67.16	67.12	67.12	2120.0
2012-10-15 18:00:00	QQQ	ETF	67.16	67.24	67.14	67.23	2976.0
2012-10-15 19:00:00	QQQ	ETF	67.23	67.27	67.22	67.27	25385.0
2012-10-15 06:00:00	IWM	ETF	82.37	82.37	82.37	82.37	200.0
2012-10-15 07:00:00	IWM	ETF	82.37	82.51	82.37	82.51	53199.0
2012-10-15 08:00:00	IWM	ETF	82.5	82.55	82.36	82.36	86859.0
2012-10-15 09:00:00	IWM	ETF	82.38	82.43	81.86	82.0	3895328.0
2012-10-15 10:00:00	IWM	ETF	81.99	82.13	81.76	82.03	4468763.0
2012-10-15 11:00:00	IWM	ETF	82.03	82.53	81.99	82.32	4219644.0
2012-10-15 12:00:00	IWM	ETF	82.32	82.6	82.18	82.495	4724716.0
2012-10-15 13:00:00	IWM	ETF	82.495	82.63	82.45	82.5	2620761.0
2012-10-15 14:00:00	IWM	ETF	82.505	82.56	82.24	82.29	3157537.0
2012-10-15 15:00:00	IWM	ETF	82.3	82.635	82.26	82.63	5578858.0
2012-10-15 16:00:00	IWM	ETF	82.63	82.74	82.5559	82.74	979617.0
2012-10-15 17:00:00	IWM	ETF	82.72	82.72	82.71	82.71	800.0
2012-10-15 18:00:00	IWM	ETF	82.74	82.74	82.74	82.74	230.0
2012-10-15 19:00:00	IWM	ETF	82.75	82.82	82.75	82.8	7134.0
2012-10-15 07:00:00	DIA	ETF	133.51	133.51	133.51	133.51	400.0
2012-10-15 08:00:00	DIA	ETF	133.51	133.55	133.33	133.33	7300.0
2012-10-15 09:00:00	DIA	ETF	133.34	133.47	133.14	133.22	339266.0
2012-10-15 10:00:00	DIA	ETF	133.2	133.38	133.06	133.25	395939.0

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

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