PREVIEW / etf_1hour / 2013-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-10.parquet
  size:    206 KB
  rows:    6,479

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
2013-07-10 04:00:00	SPY	ETF	165.13	165.13	164.61	164.68	13176.0
2013-07-10 05:00:00	SPY	ETF	164.68	164.84	164.68	164.84	61400.0
2013-07-10 06:00:00	SPY	ETF	164.86	164.91	164.7	164.7	43650.0
2013-07-10 07:00:00	SPY	ETF	164.68	164.96	164.67	164.93	184778.0
2013-07-10 08:00:00	SPY	ETF	164.7	165.09	164.7	165.0	531111.0
2013-07-10 09:00:00	SPY	ETF	165.0	165.23	164.82	165.18	11530874.0
2013-07-10 10:00:00	SPY	ETF	165.19	165.28	164.77	164.89	15756371.0
2013-07-10 11:00:00	SPY	ETF	164.9	165.05	164.7	164.82	9636263.0
2013-07-10 12:00:00	SPY	ETF	164.83	165.03	164.75	164.95	6421068.0
2013-07-10 13:00:00	SPY	ETF	164.94	165.07	164.83	164.94	5942298.0
2013-07-10 14:00:00	SPY	ETF	164.93	165.75	164.63	164.88	38407214.0
2013-07-10 15:00:00	SPY	ETF	164.88	165.27	164.68	165.16	20811805.0
2013-07-10 16:00:00	SPY	ETF	165.2	165.9	164.9174	165.9	7403622.0
2013-07-10 17:00:00	SPY	ETF	165.88	166.33	165.83	166.24	1903448.0
2013-07-10 18:00:00	SPY	ETF	166.23	166.79	166.2	166.72	754218.0
2013-07-10 19:00:00	SPY	ETF	166.69	166.69	166.52	166.69	377014.0
2013-07-10 04:00:00	QQQ	ETF	73.09	73.09	72.89	72.92	11200.0
2013-07-10 05:00:00	QQQ	ETF	72.91	72.98	72.91	72.98	8500.0
2013-07-10 06:00:00	QQQ	ETF	72.95	72.95	72.89	72.89	3000.0
2013-07-10 07:00:00	QQQ	ETF	72.9	72.99	72.89	72.99	7428.0
2013-07-10 08:00:00	QQQ	ETF	72.99	73.04	72.89	73.01	22433.0
2013-07-10 09:00:00	QQQ	ETF	72.98	73.33	72.93	73.3	2888496.0
2013-07-10 10:00:00	QQQ	ETF	73.3	73.35	73.14	73.23	3343106.0
2013-07-10 11:00:00	QQQ	ETF	73.22	73.33	73.12	73.23	1783063.0
2013-07-10 12:00:00	QQQ	ETF	73.225	73.37	73.2	73.295	1150476.0
2013-07-10 13:00:00	QQQ	ETF	73.29	73.36	73.249	73.34	1161338.0
2013-07-10 14:00:00	QQQ	ETF	73.33	73.62	73.22	73.3799	8746570.0
2013-07-10 15:00:00	QQQ	ETF	73.38	73.59	73.32	73.51	5020839.0
2013-07-10 16:00:00	QQQ	ETF	73.51	73.77	73.1585	73.75	1059409.0
2013-07-10 17:00:00	QQQ	ETF	73.09	73.95	73.09	73.8	110821.0
2013-07-10 18:00:00	QQQ	ETF	73.81	74.11	73.8	74.11	100855.0
2013-07-10 19:00:00	QQQ	ETF	74.1	74.1	74.01	74.04	24501.0
2013-07-10 05:00:00	IWM	ETF	100.78	100.89	100.78	100.89	1500.0
2013-07-10 06:00:00	IWM	ETF	100.94	100.99	100.79	100.79	11800.0
2013-07-10 07:00:00	IWM	ETF	100.85	100.98	100.77	100.98	15800.0
2013-07-10 08:00:00	IWM	ETF	100.95	101.05	100.89	101.02	155472.0
2013-07-10 09:00:00	IWM	ETF	100.98	101.33	100.9	101.21	2918548.0
2013-07-10 10:00:00	IWM	ETF	101.22	101.29	100.86	100.98	4327011.0
2013-07-10 11:00:00	IWM	ETF	100.99	101.04	100.74	100.891	2741924.0
2013-07-10 12:00:00	IWM	ETF	100.895	101.06	100.815	101.05	1846471.0
2013-07-10 13:00:00	IWM	ETF	101.06	101.11	100.97	101.02	1214616.0
2013-07-10 14:00:00	IWM	ETF	101.03	101.37	100.85	101.27	8211659.0
2013-07-10 15:00:00	IWM	ETF	101.27	101.38	101.0	101.25	5718863.0
2013-07-10 16:00:00	IWM	ETF	101.25	101.59	101.1576	101.57	1542205.0
2013-07-10 17:00:00	IWM	ETF	101.55	101.85	101.55	101.78	227384.0
2013-07-10 18:00:00	IWM	ETF	101.87	102.0	101.83	102.0	36500.0
2013-07-10 19:00:00	IWM	ETF	102.0	102.06	101.92	101.99	16344.0
2013-07-10 07:00:00	DIA	ETF	152.52	152.75	152.5	152.75	2327.0
2013-07-10 08:00:00	DIA	ETF	152.74	152.75	152.74	152.75	600.0
2013-07-10 09:00:00	DIA	ETF	152.72	153.05	152.69	152.97	408539.0

> showing 50 of 6,479 rows — these rows as CSV

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