PREVIEW / etf_1hour / 2011-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-28.parquet
  size:    180 KB
  rows:    5,552

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-28 04:00:00	SPY	ETF	126.47	126.47	126.46	126.46	8159.0
2011-12-28 05:00:00	SPY	ETF	126.47	126.77	126.47	126.74	53363.0
2011-12-28 06:00:00	SPY	ETF	126.75	126.8	126.67	126.76	338500.0
2011-12-28 07:00:00	SPY	ETF	126.74	126.85	126.69	126.72	364250.0
2011-12-28 08:00:00	SPY	ETF	126.69	126.79	126.03	126.71	504521.0
2011-12-28 09:00:00	SPY	ETF	126.71	126.73	125.65	125.74	19752678.0
2011-12-28 10:00:00	SPY	ETF	125.75	125.94	125.23	125.411	18008801.0
2011-12-28 11:00:00	SPY	ETF	125.42	125.46	124.87	125.06	15389303.0
2011-12-28 12:00:00	SPY	ETF	125.06	125.16	124.87	124.949	10381215.0
2011-12-28 13:00:00	SPY	ETF	124.95	125.32	124.92	125.29	10115356.0
2011-12-28 14:00:00	SPY	ETF	125.29	125.3	124.94	125.01	11462521.0
2011-12-28 15:00:00	SPY	ETF	125.0	125.15	124.73	124.96	24883048.0
2011-12-28 16:00:00	SPY	ETF	124.96	126.4299	124.78	124.93	5530975.0
2011-12-28 17:00:00	SPY	ETF	124.91	125.01	124.89	124.98	387139.0
2011-12-28 18:00:00	SPY	ETF	124.98	125.15	124.92	125.14	656063.0
2011-12-28 19:00:00	SPY	ETF	125.14	125.21	124.96	125.07	85245.0
2011-12-28 05:00:00	QQQ	ETF	56.21	56.21	56.21	56.21	100.0
2011-12-28 06:00:00	QQQ	ETF	56.25	56.26	56.25	56.26	1300.0
2011-12-28 07:00:00	QQQ	ETF	56.24	56.3	56.24	56.29	19800.0
2011-12-28 08:00:00	QQQ	ETF	56.29	56.3	56.25	56.28	235162.0
2011-12-28 09:00:00	QQQ	ETF	56.28	56.29	55.82	55.86	5263631.0
2011-12-28 10:00:00	QQQ	ETF	55.86	56.01	55.71	55.79	4678320.0
2011-12-28 11:00:00	QQQ	ETF	55.78	55.84	55.63	55.71	3403180.0
2011-12-28 12:00:00	QQQ	ETF	55.71	55.77	55.58	55.63	2860450.0
2011-12-28 13:00:00	QQQ	ETF	55.63	55.79	55.63	55.76	2364356.0
2011-12-28 14:00:00	QQQ	ETF	55.7617	55.775	55.64	55.67	2660767.0
2011-12-28 15:00:00	QQQ	ETF	55.67	55.715	55.44	55.6	8592221.0
2011-12-28 16:00:00	QQQ	ETF	55.61	55.66	55.51	55.63	1689379.0
2011-12-28 17:00:00	QQQ	ETF	55.61	55.66	55.61	55.61	40500.0
2011-12-28 18:00:00	QQQ	ETF	55.61	55.66	55.61	55.66	12389.0
2011-12-28 19:00:00	QQQ	ETF	55.66	55.67	55.57	55.64	8246.0
2011-12-28 07:00:00	IWM	ETF	75.02	75.04	75.0	75.0	4400.0
2011-12-28 08:00:00	IWM	ETF	75.0	75.08	74.99	75.03	97829.0
2011-12-28 09:00:00	IWM	ETF	75.01	75.04	74.15	74.26	4792142.0
2011-12-28 10:00:00	IWM	ETF	74.26	74.45	73.74	73.92	5852700.0
2011-12-28 11:00:00	IWM	ETF	73.9	73.95	73.51	73.671	3471512.0
2011-12-28 12:00:00	IWM	ETF	73.68	73.85	73.52	73.67	2007663.0
2011-12-28 13:00:00	IWM	ETF	73.66	74.06	73.63	73.97	1674577.0
2011-12-28 14:00:00	IWM	ETF	73.98	73.98	73.54	73.6	3275215.0
2011-12-28 15:00:00	IWM	ETF	73.59	73.69	73.27	73.46	8640747.0
2011-12-28 16:00:00	IWM	ETF	73.45	73.58	73.3485	73.54	3129266.0
2011-12-28 17:00:00	IWM	ETF	73.54	73.56	73.52	73.54	5864.0
2011-12-28 18:00:00	IWM	ETF	73.55	73.57	73.55	73.57	497.0
2011-12-28 19:00:00	IWM	ETF	73.62	73.66	73.55	73.56	14800.0
2011-12-28 08:00:00	DIA	ETF	122.66	122.88	122.66	122.82	5900.0
2011-12-28 09:00:00	DIA	ETF	122.83	122.84	121.98	122.07	541330.0
2011-12-28 10:00:00	DIA	ETF	122.07	122.2	121.65	121.77	431753.0
2011-12-28 11:00:00	DIA	ETF	121.77	121.78	121.25	121.37	620411.0
2011-12-28 12:00:00	DIA	ETF	121.37	121.49	121.25	121.28	400844.0
2011-12-28 13:00:00	DIA	ETF	121.28	121.6	121.25	121.57	301289.0

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

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