PREVIEW / etf_1hour / 2011-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-30.parquet
  size:    183 KB
  rows:    5,686

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
2011-12-30 05:00:00	SPY	ETF	126.15	126.25	126.15	126.25	109018.0
2011-12-30 06:00:00	SPY	ETF	126.3	126.31	126.21	126.27	17690.0
2011-12-30 07:00:00	SPY	ETF	126.31	126.45	126.27	126.39	95290.0
2011-12-30 08:00:00	SPY	ETF	126.4	126.45	125.95	126.19	472523.0
2011-12-30 09:00:00	SPY	ETF	126.18	126.24	125.89	126.169	12448077.0
2011-12-30 10:00:00	SPY	ETF	126.16	126.33	126.02	126.11	11106397.0
2011-12-30 11:00:00	SPY	ETF	126.11	126.25	126.02	126.02	9170322.0
2011-12-30 12:00:00	SPY	ETF	126.021	126.1	125.97	126.055	5442916.0
2011-12-30 13:00:00	SPY	ETF	126.04	126.08	125.98	126.039	3619918.0
2011-12-30 14:00:00	SPY	ETF	126.04	126.04	125.68	125.83	10520003.0
2011-12-30 15:00:00	SPY	ETF	125.83	126.1966	125.59	125.59	25335028.0
2011-12-30 16:00:00	SPY	ETF	125.6	126.1966	125.45	125.5	13669596.0
2011-12-30 17:00:00	SPY	ETF	125.51	125.65	125.49	125.62	143720.0
2011-12-30 18:00:00	SPY	ETF	125.61	125.62	125.4	125.4	158044.0
2011-12-30 19:00:00	SPY	ETF	125.45	125.5	125.25	125.43	167954.0
2011-12-30 06:00:00	QQQ	ETF	55.93	55.96	55.93	55.96	2300.0
2011-12-30 07:00:00	QQQ	ETF	56.04	56.04	56.02	56.03	5900.0
2011-12-30 08:00:00	QQQ	ETF	56.05	56.05	55.9	55.91	72942.0
2011-12-30 09:00:00	QQQ	ETF	55.91	56.07	55.86	56.065	2009873.0
2011-12-30 10:00:00	QQQ	ETF	56.065	56.12	55.95	56.02	2688513.0
2011-12-30 11:00:00	QQQ	ETF	56.01	56.1	56.01	56.02	2006501.0
2011-12-30 12:00:00	QQQ	ETF	56.01	56.07	55.98	56.0502	1097307.0
2011-12-30 13:00:00	QQQ	ETF	56.06	56.08	56.02	56.03	1199154.0
2011-12-30 14:00:00	QQQ	ETF	56.03	56.039	55.86	55.91	2411995.0
2011-12-30 15:00:00	QQQ	ETF	55.92	55.99	55.82	55.829	7646029.0
2011-12-30 16:00:00	QQQ	ETF	55.83	55.94	55.77	55.77	1732241.0
2011-12-30 17:00:00	QQQ	ETF	55.79	55.85	55.79	55.85	4100.0
2011-12-30 18:00:00	QQQ	ETF	55.83	55.87	55.82	55.85	7200.0
2011-12-30 19:00:00	QQQ	ETF	55.85	55.85	55.79	55.79	23929.0
2011-12-30 05:00:00	IWM	ETF	74.41	74.41	74.41	74.41	100.0
2011-12-30 06:00:00	IWM	ETF	74.42	74.42	74.42	74.42	100.0
2011-12-30 07:00:00	IWM	ETF	74.42	74.42	74.4	74.4	1100.0
2011-12-30 08:00:00	IWM	ETF	74.2	74.45	74.2	74.28	76204.0
2011-12-30 09:00:00	IWM	ETF	74.27	74.33	73.96	74.2599	2913845.0
2011-12-30 10:00:00	IWM	ETF	74.26	74.41	74.19	74.34	3567849.0
2011-12-30 11:00:00	IWM	ETF	74.345	74.52	74.3	74.43	3158347.0
2011-12-30 12:00:00	IWM	ETF	74.43	74.51	74.35	74.425	1473680.0
2011-12-30 13:00:00	IWM	ETF	74.41	74.47	74.38	74.45	1364178.0
2011-12-30 14:00:00	IWM	ETF	74.455	74.455	74.12	74.22	2667694.0
2011-12-30 15:00:00	IWM	ETF	74.21	74.34	73.8	73.85	10267442.0
2011-12-30 16:00:00	IWM	ETF	73.84	74.13	73.69	73.8	2609648.0
2011-12-30 17:00:00	IWM	ETF	73.79	73.82	73.76	73.77	36968.0
2011-12-30 18:00:00	IWM	ETF	73.83	73.86	73.75	73.76	6860.0
2011-12-30 19:00:00	IWM	ETF	73.75	73.81	73.74	73.75	4026.0
2011-12-30 08:00:00	DIA	ETF	122.6	122.63	122.54	122.54	1400.0
2011-12-30 09:00:00	DIA	ETF	122.5	122.55	122.23	122.49	453009.0
2011-12-30 10:00:00	DIA	ETF	122.49	122.63	122.33	122.42	358819.0
2011-12-30 11:00:00	DIA	ETF	122.41	122.54	122.32	122.32	864558.0
2011-12-30 12:00:00	DIA	ETF	122.32	122.4	122.24	122.26	203742.0
2011-12-30 13:00:00	DIA	ETF	122.269	122.33	122.21	122.2476	408683.0

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

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