PREVIEW / etf_1hour / 2012-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-06.parquet
  size:    191 KB
  rows:    5,877

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-06-06 04:00:00	SPY	ETF	130.0	130.58	130.0	130.51	9815.0
2012-06-06 05:00:00	SPY	ETF	130.43	130.51	130.28	130.28	52425.0
2012-06-06 06:00:00	SPY	ETF	130.26	130.6	130.16	130.49	432356.0
2012-06-06 07:00:00	SPY	ETF	130.46	130.67	130.15	130.34	1854097.0
2012-06-06 08:00:00	SPY	ETF	130.34	130.49	129.03	129.7	5446638.0
2012-06-06 09:00:00	SPY	ETF	129.71	130.79	129.66	130.6404	24868327.0
2012-06-06 10:00:00	SPY	ETF	130.6401	131.03	130.56	130.99	26258373.0
2012-06-06 11:00:00	SPY	ETF	130.98	131.44	130.91	131.3	20836729.0
2012-06-06 12:00:00	SPY	ETF	131.3	131.64	131.3	131.5	15483477.0
2012-06-06 13:00:00	SPY	ETF	131.505	131.52	131.25	131.28	13654066.0
2012-06-06 14:00:00	SPY	ETF	131.28	131.53	131.08	131.415	18671201.0
2012-06-06 15:00:00	SPY	ETF	131.412	132.03	131.26	132.01	41108647.0
2012-06-06 16:00:00	SPY	ETF	132.01	132.19	130.9662	132.08	13739427.0
2012-06-06 17:00:00	SPY	ETF	132.09	132.19	132.08	132.13	355987.0
2012-06-06 18:00:00	SPY	ETF	132.15	132.41	132.13	132.31	207547.0
2012-06-06 19:00:00	SPY	ETF	132.31	132.4	132.2	132.3	153919.0
2012-06-06 04:00:00	QQQ	ETF	61.58	61.69	61.58	61.69	821.0
2012-06-06 05:00:00	QQQ	ETF	61.75	61.75	61.75	61.75	100.0
2012-06-06 06:00:00	QQQ	ETF	61.75	61.84	61.65	61.84	75366.0
2012-06-06 07:00:00	QQQ	ETF	61.81	61.96	61.72	61.79	479141.0
2012-06-06 08:00:00	QQQ	ETF	61.79	61.873	61.44	61.5	1365301.0
2012-06-06 09:00:00	QQQ	ETF	61.52	62.09	61.52	62.02	7060398.0
2012-06-06 10:00:00	QQQ	ETF	62.03	62.35	61.98	62.3005	19049763.0
2012-06-06 11:00:00	QQQ	ETF	62.31	62.42	62.215	62.345	6342080.0
2012-06-06 12:00:00	QQQ	ETF	62.335	62.5	62.329	62.44	3313787.0
2012-06-06 13:00:00	QQQ	ETF	62.4499	62.455	62.28	62.29	4017098.0
2012-06-06 14:00:00	QQQ	ETF	62.3	62.42	62.18	62.35	4228085.0
2012-06-06 15:00:00	QQQ	ETF	62.35	62.57	62.24	62.55	9141992.0
2012-06-06 16:00:00	QQQ	ETF	62.54	62.72	61.1291	62.55	2067095.0
2012-06-06 17:00:00	QQQ	ETF	62.67	62.72	62.64	62.65	131338.0
2012-06-06 18:00:00	QQQ	ETF	62.66	62.77	62.66	62.76	94413.0
2012-06-06 19:00:00	QQQ	ETF	62.75	62.76	62.7	62.74	22049.0
2012-06-06 04:00:00	IWM	ETF	75.25	75.39	75.25	75.39	555.0
2012-06-06 05:00:00	IWM	ETF	75.48	75.63	75.48	75.63	200.0
2012-06-06 06:00:00	IWM	ETF	75.5	75.69	75.5	75.62	3687.0
2012-06-06 07:00:00	IWM	ETF	75.68	75.83	75.58	75.59	93244.0
2012-06-06 08:00:00	IWM	ETF	75.58	75.58	74.95	75.01	899842.0
2012-06-06 09:00:00	IWM	ETF	75.01	75.74	75.01	75.595	5668387.0
2012-06-06 10:00:00	IWM	ETF	75.59	75.97	75.56	75.92	5681607.0
2012-06-06 11:00:00	IWM	ETF	75.93	76.24	75.81	76.18	5080548.0
2012-06-06 12:00:00	IWM	ETF	76.19	76.42	76.18	76.3	3080133.0
2012-06-06 13:00:00	IWM	ETF	76.3	76.32	76.06	76.09	3813173.0
2012-06-06 14:00:00	IWM	ETF	76.0901	76.32	75.9	76.2	4499305.0
2012-06-06 15:00:00	IWM	ETF	76.205	76.51	76.078	76.44	8367681.0
2012-06-06 16:00:00	IWM	ETF	76.43	76.7	75.8	76.65	2134175.0
2012-06-06 17:00:00	IWM	ETF	76.66	76.7	76.43	76.58	14109.0
2012-06-06 18:00:00	IWM	ETF	76.69	76.76	76.69	76.76	2600.0
2012-06-06 19:00:00	IWM	ETF	76.79	76.79	76.75	76.75	1320.0
2012-06-06 04:00:00	DIA	ETF	122.21	122.22	122.21	122.22	1500.0
2012-06-06 05:00:00	DIA	ETF	122.17	122.19	122.15	122.15	10200.0

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

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