PREVIEW / etf_1hour / 2014-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-24.parquet
  size:    234 KB
  rows:    7,293

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
2014-01-24 04:00:00	SPY	ETF	182.82	182.82	182.1	182.22	129277.0
2014-01-24 05:00:00	SPY	ETF	182.07	182.17	181.68	181.68	74253.0
2014-01-24 06:00:00	SPY	ETF	181.61	181.78	181.25	181.78	271398.0
2014-01-24 07:00:00	SPY	ETF	181.79	181.82	181.44	181.63	580394.0
2014-01-24 08:00:00	SPY	ETF	181.74	182.02	181.5	181.84	1457672.0
2014-01-24 09:00:00	SPY	ETF	181.81	181.82	180.98	181.34	20126664.0
2014-01-24 10:00:00	SPY	ETF	181.34	181.56	180.36	180.64	36185549.0
2014-01-24 11:00:00	SPY	ETF	180.65	180.82	179.89	180.5765	28778068.0
2014-01-24 12:00:00	SPY	ETF	180.571	181.59	180.09	180.36	17384851.0
2014-01-24 13:00:00	SPY	ETF	180.35	180.48	180.08	180.135	11829389.0
2014-01-24 14:00:00	SPY	ETF	180.135	180.14	179.5	179.69	19140484.0
2014-01-24 15:00:00	SPY	ETF	179.68	179.99	178.87	178.89	45692267.0
2014-01-24 16:00:00	SPY	ETF	178.89	182.7017	178.43	178.48	23281881.0
2014-01-24 17:00:00	SPY	ETF	178.48	182.7017	178.43	178.79	973055.0
2014-01-24 18:00:00	SPY	ETF	178.79	178.81	178.52	178.59	50044.0
2014-01-24 19:00:00	SPY	ETF	178.62	178.69	178.56	178.59	25284.0
2014-01-24 04:00:00	QQQ	ETF	88.35	88.45	88.35	88.45	2100.0
2014-01-24 05:00:00	QQQ	ETF	88.2	88.2	88.12	88.12	9070.0
2014-01-24 06:00:00	QQQ	ETF	88.07	88.12	87.89	88.02	64831.0
2014-01-24 07:00:00	QQQ	ETF	88.12	88.19	87.97	88.1	180165.0
2014-01-24 08:00:00	QQQ	ETF	88.13	88.31	88.08	88.21	351137.0
2014-01-24 09:00:00	QQQ	ETF	88.21	88.21	87.65	87.81	7483384.0
2014-01-24 10:00:00	QQQ	ETF	87.81	87.98	87.41	87.63	10046022.0
2014-01-24 11:00:00	QQQ	ETF	87.62	87.68	87.09	87.53	10060510.0
2014-01-24 12:00:00	QQQ	ETF	87.53	87.595	87.34	87.47	3854848.0
2014-01-24 13:00:00	QQQ	ETF	87.47	87.51	87.25	87.28	2712600.0
2014-01-24 14:00:00	QQQ	ETF	87.28	87.28	87.01	87.159	5395453.0
2014-01-24 15:00:00	QQQ	ETF	87.16	87.17	86.71	86.72	11707786.0
2014-01-24 16:00:00	QQQ	ETF	86.72	87.924	86.56	86.56	1663353.0
2014-01-24 17:00:00	QQQ	ETF	86.58	86.65	86.57	86.61	14888.0
2014-01-24 18:00:00	QQQ	ETF	86.65	86.7	86.64	86.69	5814.0
2014-01-24 19:00:00	QQQ	ETF	86.66	86.7	86.5	86.5	8042.0
2014-01-24 05:00:00	IWM	ETF	116.07	116.07	115.72	115.75	9300.0
2014-01-24 06:00:00	IWM	ETF	115.73	115.8	115.42	115.8	700.0
2014-01-24 07:00:00	IWM	ETF	115.81	115.86	115.61	115.67	186849.0
2014-01-24 08:00:00	IWM	ETF	115.68	116.02	115.63	115.87	375088.0
2014-01-24 09:00:00	IWM	ETF	115.84	115.84	114.81	114.97	6339668.0
2014-01-24 10:00:00	IWM	ETF	114.96	115.07	114.13	114.225	8796725.0
2014-01-24 11:00:00	IWM	ETF	114.23	114.33	113.46	113.97	7189555.0
2014-01-24 12:00:00	IWM	ETF	113.965	114.04	113.465	113.645	4720521.0
2014-01-24 13:00:00	IWM	ETF	113.64	113.74	113.385	113.54	2465580.0
2014-01-24 14:00:00	IWM	ETF	113.53	113.53	113.2201	113.37	4704984.0
2014-01-24 15:00:00	IWM	ETF	113.36	113.56	113.24	113.49	9189194.0
2014-01-24 16:00:00	IWM	ETF	113.5	113.7559	113.27	113.27	2335345.0
2014-01-24 17:00:00	IWM	ETF	113.28	113.399	113.24	113.31	20960.0
2014-01-24 18:00:00	IWM	ETF	113.26	113.35	113.2	113.2	5840.0
2014-01-24 19:00:00	IWM	ETF	113.2	113.39	113.2	113.39	1200.0
2014-01-24 06:00:00	DIA	ETF	160.52	161.0	160.52	161.0	300.0
2014-01-24 07:00:00	DIA	ETF	160.85	160.85	160.75	160.75	700.0
2014-01-24 08:00:00	DIA	ETF	160.62	161.14	160.62	161.0	5510.0

> showing 50 of 7,293 rows — these rows as CSV

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