PREVIEW / etf_1hour / 2011-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-09.parquet
  size:    191 KB
  rows:    5,931

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-11-09 04:00:00	SPY	ETF	127.11	127.11	125.6	125.6	62215.0
2011-11-09 05:00:00	SPY	ETF	125.69	125.84	125.1	125.4	140598.0
2011-11-09 06:00:00	SPY	ETF	125.33	125.33	124.59	124.91	1844742.0
2011-11-09 07:00:00	SPY	ETF	124.98	125.36	124.82	125.2	4119417.0
2011-11-09 08:00:00	SPY	ETF	125.0	125.67	124.28	125.21	12728487.0
2011-11-09 09:00:00	SPY	ETF	125.21	125.8	124.32	124.51	40728737.0
2011-11-09 10:00:00	SPY	ETF	124.52	125.14	124.17	124.91	46463197.0
2011-11-09 11:00:00	SPY	ETF	124.93	125.47	124.77	125.22	25309488.0
2011-11-09 12:00:00	SPY	ETF	125.23	125.3	124.74	125.08	18866796.0
2011-11-09 13:00:00	SPY	ETF	125.07	125.21	123.7	123.9	29500594.0
2011-11-09 14:00:00	SPY	ETF	123.9	123.9	122.86	123.32	55591067.0
2011-11-09 15:00:00	SPY	ETF	123.33	123.91	122.94	123.17	68199732.0
2011-11-09 16:00:00	SPY	ETF	123.17	127.8445	122.94	123.26	23281361.0
2011-11-09 17:00:00	SPY	ETF	123.25	127.8445	123.07	123.17	7360934.0
2011-11-09 18:00:00	SPY	ETF	123.19	123.23	122.83	122.86	571283.0
2011-11-09 19:00:00	SPY	ETF	122.87	122.95	122.57	122.95	458305.0
2011-11-09 04:00:00	QQQ	ETF	58.58	58.58	57.99	57.99	8150.0
2011-11-09 05:00:00	QQQ	ETF	57.96	57.96	57.67	57.79	14300.0
2011-11-09 06:00:00	QQQ	ETF	57.77	57.79	57.52	57.72	65412.0
2011-11-09 07:00:00	QQQ	ETF	57.76	57.9	57.7	57.87	218029.0
2011-11-09 08:00:00	QQQ	ETF	57.87	57.96	57.59	57.91	652483.0
2011-11-09 09:00:00	QQQ	ETF	57.92	57.92	57.328	57.41	8717798.0
2011-11-09 10:00:00	QQQ	ETF	57.4	57.6	57.2	57.5	8598285.0
2011-11-09 11:00:00	QQQ	ETF	57.5	57.83	57.47	57.72	5410088.0
2011-11-09 12:00:00	QQQ	ETF	57.724	57.76	57.53	57.75	2931695.0
2011-11-09 13:00:00	QQQ	ETF	57.74	57.8187	57.1	57.19	5362615.0
2011-11-09 14:00:00	QQQ	ETF	57.19	57.19	56.63	56.81	13057354.0
2011-11-09 15:00:00	QQQ	ETF	56.81	57.05	56.67	56.83	12371995.0
2011-11-09 16:00:00	QQQ	ETF	56.83	57.01	56.71	56.94	2046425.0
2011-11-09 17:00:00	QQQ	ETF	56.95	56.97	56.81	56.91	300471.0
2011-11-09 18:00:00	QQQ	ETF	56.91	56.96	56.79	56.79	89986.0
2011-11-09 19:00:00	QQQ	ETF	56.79	56.81	56.68	56.8	31796.0
2011-11-09 04:00:00	IWM	ETF	74.5	74.5	73.82	73.85	3150.0
2011-11-09 05:00:00	IWM	ETF	73.9	73.9	73.52	73.52	11750.0
2011-11-09 06:00:00	IWM	ETF	73.59	73.6	73.14	73.41	35253.0
2011-11-09 07:00:00	IWM	ETF	73.4	73.76	73.35	73.72	498240.0
2011-11-09 08:00:00	IWM	ETF	73.63	73.89	73.27	73.69	1737186.0
2011-11-09 09:00:00	IWM	ETF	73.7	73.72	73.15	73.36	8488932.0
2011-11-09 10:00:00	IWM	ETF	73.35	73.77	73.17	73.47	10186739.0
2011-11-09 11:00:00	IWM	ETF	73.46	73.92	73.33	73.68	5795571.0
2011-11-09 12:00:00	IWM	ETF	73.69	73.75	73.23	73.5	4493823.0
2011-11-09 13:00:00	IWM	ETF	73.495	73.51	72.42	72.61	9552320.0
2011-11-09 14:00:00	IWM	ETF	72.61	72.62	72.02	72.39	12381766.0
2011-11-09 15:00:00	IWM	ETF	72.38	72.67	71.82	71.93	14949500.0
2011-11-09 16:00:00	IWM	ETF	71.93	75.4902	71.62	71.85	3790984.0
2011-11-09 17:00:00	IWM	ETF	71.81	71.84	71.73	71.8	59814.0
2011-11-09 18:00:00	IWM	ETF	71.8	71.8	71.58	71.58	9127.0
2011-11-09 19:00:00	IWM	ETF	71.67	71.67	71.4	71.53	35634.0
2011-11-09 04:00:00	DIA	ETF	120.75	120.75	120.35	120.35	400.0
2011-11-09 07:00:00	DIA	ETF	119.35	119.69	119.3	119.69	3920.0

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

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