PREVIEW / etf_1hour / 2015-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-30.parquet
  size:    244 KB
  rows:    7,744

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
2015-01-30 04:00:00	SPY	ETF	201.81	201.81	200.73	200.8	58221.0
2015-01-30 05:00:00	SPY	ETF	200.77	200.98	200.58	200.84	429324.0
2015-01-30 06:00:00	SPY	ETF	200.86	201.39	200.79	201.14	106826.0
2015-01-30 07:00:00	SPY	ETF	201.11	201.11	200.71	200.76	367250.0
2015-01-30 08:00:00	SPY	ETF	200.78	201.97	200.02	200.22	2842236.0
2015-01-30 09:00:00	SPY	ETF	200.2	201.71	200.12	201.15	18921951.0
2015-01-30 10:00:00	SPY	ETF	201.15	201.4	200.05	200.6	20443722.0
2015-01-30 11:00:00	SPY	ETF	200.59	200.8	199.8	200.61	19633333.0
2015-01-30 12:00:00	SPY	ETF	200.6	201.45	200.5	200.61	13208408.0
2015-01-30 13:00:00	SPY	ETF	200.61	201.45	200.28	201.43	13322568.0
2015-01-30 14:00:00	SPY	ETF	201.435	202.17	200.53	200.7	25477877.0
2015-01-30 15:00:00	SPY	ETF	200.7	202.1499	199.13	199.44	53562752.0
2015-01-30 16:00:00	SPY	ETF	199.45	201.9402	199.24	199.38	17964398.0
2015-01-30 17:00:00	SPY	ETF	199.39	201.9405	199.36	199.38	5454422.0
2015-01-30 18:00:00	SPY	ETF	199.4	199.4	199.11	199.15	179546.0
2015-01-30 19:00:00	SPY	ETF	199.12	201.9401	199.11	199.23	1044056.0
2015-01-30 04:00:00	QQQ	ETF	101.83	101.88	101.83	101.88	1200.0
2015-01-30 05:00:00	QQQ	ETF	101.84	101.84	101.63	101.66	3500.0
2015-01-30 06:00:00	QQQ	ETF	101.81	102.06	101.79	101.9	20400.0
2015-01-30 07:00:00	QQQ	ETF	101.9	101.9	101.72	101.74	150774.0
2015-01-30 08:00:00	QQQ	ETF	101.82	101.87	101.48	101.61	205723.0
2015-01-30 09:00:00	QQQ	ETF	101.6	102.58	101.57	102.03	6054791.0
2015-01-30 10:00:00	QQQ	ETF	102.03	102.21	101.4	101.79	4888674.0
2015-01-30 11:00:00	QQQ	ETF	101.79	102.02	101.52	102.0	2778121.0
2015-01-30 12:00:00	QQQ	ETF	102.0	102.459	101.98	102.04	4131825.0
2015-01-30 13:00:00	QQQ	ETF	102.04	102.28	101.8	102.23	2765929.0
2015-01-30 14:00:00	QQQ	ETF	102.23	102.56	101.72	101.86	3935279.0
2015-01-30 15:00:00	QQQ	ETF	101.855	101.95	100.96	101.12	8822113.0
2015-01-30 16:00:00	QQQ	ETF	101.12	101.9977	101.04	101.1	3354561.0
2015-01-30 17:00:00	QQQ	ETF	101.09	101.13	101.07	101.07	1354962.0
2015-01-30 18:00:00	QQQ	ETF	101.07	101.11	101.06	101.1	7000.0
2015-01-30 19:00:00	QQQ	ETF	101.1	101.1	101.04	101.09	956.0
2015-01-30 04:00:00	IWM	ETF	117.92	117.92	117.69	117.69	300.0
2015-01-30 07:00:00	IWM	ETF	117.74	117.89	117.58	117.63	86239.0
2015-01-30 08:00:00	IWM	ETF	117.61	117.68	117.21	117.34	251273.0
2015-01-30 09:00:00	IWM	ETF	117.3	117.96	117.05	117.06	3631474.0
2015-01-30 10:00:00	IWM	ETF	117.07	117.36	116.22	116.58	5083850.0
2015-01-30 11:00:00	IWM	ETF	116.58	116.9	116.29	116.865	2947792.0
2015-01-30 12:00:00	IWM	ETF	116.865	117.17	116.655	116.69	2338121.0
2015-01-30 13:00:00	IWM	ETF	116.68	116.87	116.255	116.84	3527624.0
2015-01-30 14:00:00	IWM	ETF	116.83	117.42	116.38	116.53	4447936.0
2015-01-30 15:00:00	IWM	ETF	116.52	116.63	115.6	115.76	13431743.0
2015-01-30 16:00:00	IWM	ETF	115.75	116.02	115.68	115.79	2986445.0
2015-01-30 17:00:00	IWM	ETF	115.79	115.82	115.7	115.75	1688701.0
2015-01-30 18:00:00	IWM	ETF	115.75	115.8	115.71	115.8	3138.0
2015-01-30 19:00:00	IWM	ETF	115.79	115.79	115.71	115.74	1700.0
2015-01-30 05:00:00	DIA	ETF	173.35	173.57	173.35	173.57	2600.0
2015-01-30 06:00:00	DIA	ETF	173.4	173.71	173.4	173.71	600.0
2015-01-30 07:00:00	DIA	ETF	173.6	173.6	173.35	173.35	2100.0
2015-01-30 08:00:00	DIA	ETF	173.25	173.28	172.85	172.85	21541.0

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

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