PREVIEW / etf_1hour / 2014-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-06.parquet
  size:    218 KB
  rows:    6,845

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-06 04:00:00	SPY	ETF	182.64	182.91	182.64	182.91	2443.0
2014-01-06 05:00:00	SPY	ETF	182.99	183.03	182.9	183.0	8949.0
2014-01-06 06:00:00	SPY	ETF	182.99	183.13	182.99	183.1	60450.0
2014-01-06 07:00:00	SPY	ETF	183.04	183.32	183.04	183.17	107166.0
2014-01-06 08:00:00	SPY	ETF	183.17	183.28	183.15	183.26	259884.0
2014-01-06 09:00:00	SPY	ETF	183.26	183.56	182.72	182.9772	11961373.0
2014-01-06 10:00:00	SPY	ETF	182.97	183.1	182.54	182.56	16663097.0
2014-01-06 11:00:00	SPY	ETF	182.565	182.68	182.08	182.37	18011477.0
2014-01-06 12:00:00	SPY	ETF	182.37	182.44	182.15	182.34	8027419.0
2014-01-06 13:00:00	SPY	ETF	182.35	182.79	182.18	182.675	7895306.0
2014-01-06 14:00:00	SPY	ETF	182.68	182.93	182.53	182.855	9153298.0
2014-01-06 15:00:00	SPY	ETF	182.85	182.87	182.34	182.4	19458050.0
2014-01-06 16:00:00	SPY	ETF	182.4	183.47	182.27	182.31	7733096.0
2014-01-06 17:00:00	SPY	ETF	182.29	182.36	182.29	182.33	4256019.0
2014-01-06 18:00:00	SPY	ETF	182.33	182.5	182.33	182.38	907515.0
2014-01-06 19:00:00	SPY	ETF	182.4	182.42	182.36	182.385	230590.0
2014-01-06 05:00:00	QQQ	ETF	86.67	86.67	86.67	86.67	175.0
2014-01-06 06:00:00	QQQ	ETF	86.66	86.69	86.66	86.69	1620.0
2014-01-06 07:00:00	QQQ	ETF	86.64	86.72	86.64	86.72	13050.0
2014-01-06 08:00:00	QQQ	ETF	86.72	86.75	86.56	86.59	154353.0
2014-01-06 09:00:00	QQQ	ETF	86.635	86.76	86.24	86.31	4313545.0
2014-01-06 10:00:00	QQQ	ETF	86.31	86.35	86.135	86.18	5623906.0
2014-01-06 11:00:00	QQQ	ETF	86.18	86.29	86.0	86.2	2914305.0
2014-01-06 12:00:00	QQQ	ETF	86.2	86.277	86.1	86.23	2372199.0
2014-01-06 13:00:00	QQQ	ETF	86.23	86.42	86.1	86.37	2347516.0
2014-01-06 14:00:00	QQQ	ETF	86.38	86.6	86.34	86.5745	3462270.0
2014-01-06 15:00:00	QQQ	ETF	86.57	86.59	86.32	86.33	4898679.0
2014-01-06 16:00:00	QQQ	ETF	86.33	86.654	86.05	86.24	4182267.0
2014-01-06 17:00:00	QQQ	ETF	86.24	86.26	86.22	86.26	5898.0
2014-01-06 18:00:00	QQQ	ETF	86.26	86.33	86.26	86.32	5050.0
2014-01-06 19:00:00	QQQ	ETF	86.33	86.33	86.31	86.31	12000.0
2014-01-06 07:00:00	IWM	ETF	114.8	115.02	114.78	114.94	61400.0
2014-01-06 08:00:00	IWM	ETF	114.96	115.02	114.88	115.01	83389.0
2014-01-06 09:00:00	IWM	ETF	115.02	115.27	114.21	114.48	4730871.0
2014-01-06 10:00:00	IWM	ETF	114.48	114.78	114.08	114.135	4500816.0
2014-01-06 11:00:00	IWM	ETF	114.135	114.24	113.84	114.07	3534263.0
2014-01-06 12:00:00	IWM	ETF	114.08	114.14	113.82	114.01	2689977.0
2014-01-06 13:00:00	IWM	ETF	114.0	114.13	113.74	114.06	3626592.0
2014-01-06 14:00:00	IWM	ETF	114.07	114.14	113.89	114.04	2642785.0
2014-01-06 15:00:00	IWM	ETF	114.03	114.04	113.71	113.76	7054926.0
2014-01-06 16:00:00	IWM	ETF	113.76	114.6911	113.72	113.72	3161718.0
2014-01-06 17:00:00	IWM	ETF	113.71	113.72	113.69	113.72	5550.0
2014-01-06 18:00:00	IWM	ETF	113.78	113.78	113.73	113.73	3000.0
2014-01-06 19:00:00	IWM	ETF	113.73	113.73	113.73	113.73	350.0
2014-01-06 08:00:00	DIA	ETF	164.71	164.8	164.7	164.8	2575.0
2014-01-06 09:00:00	DIA	ETF	164.79	165.06	164.17	164.522	860929.0
2014-01-06 10:00:00	DIA	ETF	164.496	164.71	164.09	164.09	1169186.0
2014-01-06 11:00:00	DIA	ETF	164.09	164.17	163.71	163.96	1183557.0
2014-01-06 12:00:00	DIA	ETF	163.97	164.09	163.7587	163.94	765686.0
2014-01-06 13:00:00	DIA	ETF	163.95	164.39	163.79	164.29	683108.0

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

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