PREVIEW / etf_1hour / 2016-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-09.parquet
  size:    245 KB
  rows:    7,851

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
2016-03-09 04:00:00	SPY	ETF	198.88	199.57	198.88	199.3	20459.0
2016-03-09 05:00:00	SPY	ETF	199.15	199.48	199.01	199.48	23068.0
2016-03-09 06:00:00	SPY	ETF	199.44	199.74	199.38	199.67	166054.0
2016-03-09 07:00:00	SPY	ETF	199.69	199.99	199.59	199.6	355077.0
2016-03-09 08:00:00	SPY	ETF	199.7	199.91	198.61	199.48	810136.0
2016-03-09 09:00:00	SPY	ETF	199.49	199.56	198.87	199.21	9855580.0
2016-03-09 10:00:00	SPY	ETF	199.21	199.69	198.43	198.73	17374437.0
2016-03-09 11:00:00	SPY	ETF	198.739	199.79	198.7	199.71	11779488.0
2016-03-09 12:00:00	SPY	ETF	199.72	199.73	198.98	199.02	7136909.0
2016-03-09 13:00:00	SPY	ETF	199.02	199.49	198.83	199.4	6248971.0
2016-03-09 14:00:00	SPY	ETF	199.4	199.53	199.11	199.2851	9372924.0
2016-03-09 15:00:00	SPY	ETF	199.28	199.44	198.84	199.42	17820936.0
2016-03-09 16:00:00	SPY	ETF	199.41	199.68	199.1044	199.55	9042669.0
2016-03-09 17:00:00	SPY	ETF	199.54	199.56	199.4	199.52	144216.0
2016-03-09 18:00:00	SPY	ETF	199.53	199.67	199.47	199.49	184438.0
2016-03-09 19:00:00	SPY	ETF	199.52	199.57	199.38	199.43	54691.0
2016-03-09 04:00:00	QQQ	ETF	104.68	104.68	104.68	104.68	100.0
2016-03-09 05:00:00	QQQ	ETF	104.7	104.72	104.7	104.72	400.0
2016-03-09 06:00:00	QQQ	ETF	104.81	104.9	104.76	104.85	6764.0
2016-03-09 07:00:00	QQQ	ETF	104.88	104.96	104.79	104.79	32662.0
2016-03-09 08:00:00	QQQ	ETF	104.77	104.85	104.6	104.67	66773.0
2016-03-09 09:00:00	QQQ	ETF	104.71	104.74	103.96	104.18	4434798.0
2016-03-09 10:00:00	QQQ	ETF	104.18	104.815	104.04	104.13	5027193.0
2016-03-09 11:00:00	QQQ	ETF	104.13	104.76	104.12	104.71	3007110.0
2016-03-09 12:00:00	QQQ	ETF	104.71	104.72	104.35	104.39	1878556.0
2016-03-09 13:00:00	QQQ	ETF	104.385	104.8099	104.33	104.74	2099688.0
2016-03-09 14:00:00	QQQ	ETF	104.74	104.84	104.55	104.73	1819525.0
2016-03-09 15:00:00	QQQ	ETF	104.72	104.82	104.465	104.82	4016038.0
2016-03-09 16:00:00	QQQ	ETF	104.82	104.97	104.5475	104.87	2724705.0
2016-03-09 17:00:00	QQQ	ETF	104.86	104.9	104.78	104.86	946625.0
2016-03-09 18:00:00	QQQ	ETF	104.86	104.93	104.81	104.81	6425.0
2016-03-09 19:00:00	QQQ	ETF	104.86	104.86	104.77	104.8	10681.0
2016-03-09 06:00:00	IWM	ETF	107.03	107.03	107.0	107.0	22869.0
2016-03-09 07:00:00	IWM	ETF	107.11	107.2	106.89	106.93	40813.0
2016-03-09 08:00:00	IWM	ETF	107.1	107.1	106.82	106.87	94481.0
2016-03-09 09:00:00	IWM	ETF	106.88	107.005	106.265	106.69	4040566.0
2016-03-09 10:00:00	IWM	ETF	106.68	106.91	106.07	106.34	5045919.0
2016-03-09 11:00:00	IWM	ETF	106.35	106.91	106.29	106.86	3138596.0
2016-03-09 12:00:00	IWM	ETF	106.86	106.87	106.49	106.55	2078831.0
2016-03-09 13:00:00	IWM	ETF	106.55	106.91	106.485	106.86	1669023.0
2016-03-09 14:00:00	IWM	ETF	106.85	106.98	106.69	106.86	1647913.0
2016-03-09 15:00:00	IWM	ETF	106.87	106.88	106.465	106.81	4340675.0
2016-03-09 16:00:00	IWM	ETF	106.81	107.04	106.7679	106.99	1905671.0
2016-03-09 17:00:00	IWM	ETF	107.0	107.01	106.5	106.91	202833.0
2016-03-09 18:00:00	IWM	ETF	106.92	106.97	106.92	106.95	3300.0
2016-03-09 19:00:00	IWM	ETF	106.93	106.98	106.91	106.91	1407.0
2016-03-09 07:00:00	DIA	ETF	170.87	170.87	170.64	170.64	1181.0
2016-03-09 08:00:00	DIA	ETF	170.7	170.7	170.7	170.7	500.0
2016-03-09 09:00:00	DIA	ETF	170.51	170.53	170.16	170.32	214062.0
2016-03-09 10:00:00	DIA	ETF	170.31	170.56	169.54	169.78	707446.0

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

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