PREVIEW / etf_1hour / 2011-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-24.parquet
  size:    176 KB
  rows:    5,427

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-05-24 04:00:00	SPY	ETF	132.27	132.47	132.27	132.45	5600.0
2011-05-24 05:00:00	SPY	ETF	132.3	132.59	132.3	132.56	32132.0
2011-05-24 06:00:00	SPY	ETF	132.49	132.5	132.28	132.45	42750.0
2011-05-24 07:00:00	SPY	ETF	132.43	132.43	132.15	132.4	388998.0
2011-05-24 08:00:00	SPY	ETF	132.4	132.58	132.37	132.52	2145236.0
2011-05-24 09:00:00	SPY	ETF	132.51	132.61	132.32	132.55	16639327.0
2011-05-24 10:00:00	SPY	ETF	132.54	132.73	132.08	132.13	25264349.0
2011-05-24 11:00:00	SPY	ETF	132.13	132.41	131.95	132.03	19176702.0
2011-05-24 12:00:00	SPY	ETF	132.01	132.72	131.82	131.89	17780777.0
2011-05-24 13:00:00	SPY	ETF	131.89	132.08	131.7	132.0	13756454.0
2011-05-24 14:00:00	SPY	ETF	132.0	132.27	131.92	132.19	12676539.0
2011-05-24 15:00:00	SPY	ETF	132.2	132.37	131.92	131.96	22984796.0
2011-05-24 16:00:00	SPY	ETF	131.96	132.1955	131.63	131.76	12630306.0
2011-05-24 17:00:00	SPY	ETF	131.74	131.83	131.73	131.76	119581.0
2011-05-24 18:00:00	SPY	ETF	131.74	131.95	131.71	131.8	55601.0
2011-05-24 19:00:00	SPY	ETF	131.8	131.84	131.7	131.7	38532.0
2011-05-24 04:00:00	QQQ	ETF	57.0	57.0	57.0	57.0	500.0
2011-05-24 05:00:00	QQQ	ETF	57.02	57.02	57.02	57.02	200.0
2011-05-24 06:00:00	QQQ	ETF	57.05	57.09	57.01	57.07	80400.0
2011-05-24 07:00:00	QQQ	ETF	57.0	57.04	56.94	57.04	61148.0
2011-05-24 08:00:00	QQQ	ETF	57.02	57.12	57.02	57.1	692950.0
2011-05-24 09:00:00	QQQ	ETF	57.09	57.13	56.84	56.91	5176618.0
2011-05-24 10:00:00	QQQ	ETF	56.915	57.0	56.73	56.78	7302067.0
2011-05-24 11:00:00	QQQ	ETF	56.78	56.88	56.68	56.71	4057879.0
2011-05-24 12:00:00	QQQ	ETF	56.705	56.74	56.65	56.67	3830294.0
2011-05-24 13:00:00	QQQ	ETF	56.67	56.75	56.57	56.7	2406482.0
2011-05-24 14:00:00	QQQ	ETF	56.71	56.79	56.68	56.74	2364205.0
2011-05-24 15:00:00	QQQ	ETF	56.7367	56.8	56.56	56.57	7769330.0
2011-05-24 16:00:00	QQQ	ETF	56.57	56.9184	56.46	56.47	4604707.0
2011-05-24 17:00:00	QQQ	ETF	56.53	56.54	56.5	56.54	23711.0
2011-05-24 18:00:00	QQQ	ETF	56.51	56.59	56.47	56.5	58698.0
2011-05-24 19:00:00	QQQ	ETF	56.51	56.55	56.5	56.51	17395.0
2011-05-24 05:00:00	IWM	ETF	81.55	81.69	81.55	81.69	1300.0
2011-05-24 06:00:00	IWM	ETF	81.56	81.56	81.56	81.56	2500.0
2011-05-24 07:00:00	IWM	ETF	81.5	81.57	81.36	81.48	20300.0
2011-05-24 08:00:00	IWM	ETF	81.58	81.69	81.55	81.66	379915.0
2011-05-24 09:00:00	IWM	ETF	81.65	81.77	81.425	81.73	6591231.0
2011-05-24 10:00:00	IWM	ETF	81.73	81.96	81.17	81.232	10028157.0
2011-05-24 11:00:00	IWM	ETF	81.245	81.48	81.07	81.09	7315041.0
2011-05-24 12:00:00	IWM	ETF	81.0929	81.16	80.89	81.045	6358264.0
2011-05-24 13:00:00	IWM	ETF	81.03	81.22	80.83	81.16	4682449.0
2011-05-24 14:00:00	IWM	ETF	81.17	81.37	81.12	81.25	4710124.0
2011-05-24 15:00:00	IWM	ETF	81.26	81.48	80.96	80.97	8331705.0
2011-05-24 16:00:00	IWM	ETF	80.97	81.03	80.85	80.85	3376634.0
2011-05-24 17:00:00	IWM	ETF	80.9	80.95	80.89	80.89	23600.0
2011-05-24 18:00:00	IWM	ETF	80.96	80.97	80.95	80.96	3100.0
2011-05-24 19:00:00	IWM	ETF	80.93	80.94	80.91	80.91	800.0
2011-05-24 05:00:00	DIA	ETF	123.84	123.84	123.84	123.84	100.0
2011-05-24 07:00:00	DIA	ETF	123.87	123.87	123.69	123.79	7100.0
2011-05-24 08:00:00	DIA	ETF	123.86	123.95	123.84	123.89	11400.0

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

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