PREVIEW / etf_1hour / 2015-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-14.parquet
  size:    242 KB
  rows:    7,741

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-07-14 04:00:00	SPY	ETF	209.76	209.82	209.73	209.82	28235.0
2015-07-14 05:00:00	SPY	ETF	209.8	209.81	209.77	209.79	28700.0
2015-07-14 06:00:00	SPY	ETF	209.83	209.88	209.75	209.87	56911.0
2015-07-14 07:00:00	SPY	ETF	209.88	209.97	209.85	209.85	148151.0
2015-07-14 08:00:00	SPY	ETF	209.63	210.03	209.56	209.6	1208294.0
2015-07-14 09:00:00	SPY	ETF	209.57	210.26	209.54	210.16	10425776.0
2015-07-14 10:00:00	SPY	ETF	210.17	210.45	210.05	210.38	11797477.0
2015-07-14 11:00:00	SPY	ETF	210.38	210.74	210.38	210.68	9272382.0
2015-07-14 12:00:00	SPY	ETF	210.67	210.76	210.36	210.49	7502684.0
2015-07-14 13:00:00	SPY	ETF	210.49	210.65	210.42	210.635	5114263.0
2015-07-14 14:00:00	SPY	ETF	210.6337	210.93	210.575	210.89	9343608.0
2015-07-14 15:00:00	SPY	ETF	210.88	211.05	210.66	210.68	19698687.0
2015-07-14 16:00:00	SPY	ETF	210.68	210.87	209.9467	210.79	6135403.0
2015-07-14 17:00:00	SPY	ETF	210.79	210.85	210.77	210.78	84900.0
2015-07-14 18:00:00	SPY	ETF	210.78	210.78	210.56	210.58	249027.0
2015-07-14 19:00:00	SPY	ETF	210.57	210.58	210.47	210.52	163500.0
2015-07-14 04:00:00	QQQ	ETF	109.64	109.64	109.64	109.64	25000.0
2015-07-14 05:00:00	QQQ	ETF	109.69	109.69	109.51	109.56	15500.0
2015-07-14 06:00:00	QQQ	ETF	109.65	109.7	109.56	109.57	30840.0
2015-07-14 07:00:00	QQQ	ETF	109.61	109.65	109.6	109.62	17640.0
2015-07-14 08:00:00	QQQ	ETF	109.63	109.72	109.59	109.59	74977.0
2015-07-14 09:00:00	QQQ	ETF	109.6	109.941	109.6	109.91	2726695.0
2015-07-14 10:00:00	QQQ	ETF	109.91	110.12	109.84	110.09	3234632.0
2015-07-14 11:00:00	QQQ	ETF	110.09	110.42	110.08	110.36	3296683.0
2015-07-14 12:00:00	QQQ	ETF	110.37	110.42	110.19	110.26	1978858.0
2015-07-14 13:00:00	QQQ	ETF	110.26	110.42	110.2	110.39	1361324.0
2015-07-14 14:00:00	QQQ	ETF	110.39	110.54	110.33	110.485	1789029.0
2015-07-14 15:00:00	QQQ	ETF	110.4899	110.56	110.24	110.25	3955205.0
2015-07-14 16:00:00	QQQ	ETF	110.24	110.33	110.22	110.33	695089.0
2015-07-14 17:00:00	QQQ	ETF	110.33	110.36	110.31	110.32	25960.0
2015-07-14 18:00:00	QQQ	ETF	110.32	110.33	110.26	110.26	2697.0
2015-07-14 19:00:00	QQQ	ETF	110.25	110.26	110.22	110.22	4600.0
2015-07-14 07:00:00	IWM	ETF	125.59	125.67	125.59	125.67	19900.0
2015-07-14 08:00:00	IWM	ETF	125.6	125.6	125.37	125.4	50950.0
2015-07-14 09:00:00	IWM	ETF	125.4	125.92	125.39	125.85	2021894.0
2015-07-14 10:00:00	IWM	ETF	125.845	126.03	125.72	126.025	2485380.0
2015-07-14 11:00:00	IWM	ETF	126.02	126.44	126.02	126.27	2699996.0
2015-07-14 12:00:00	IWM	ETF	126.27	126.3799	126.06	126.13	1302060.0
2015-07-14 13:00:00	IWM	ETF	126.14	126.28	126.12	126.255	956650.0
2015-07-14 14:00:00	IWM	ETF	126.255	126.41	126.2	126.33	1249795.0
2015-07-14 15:00:00	IWM	ETF	126.33	126.5	126.24	126.25	3944963.0
2015-07-14 16:00:00	IWM	ETF	126.25	126.31	126.15	126.25	2205910.0
2015-07-14 17:00:00	IWM	ETF	126.22	126.31	126.22	126.24	2630.0
2015-07-14 18:00:00	IWM	ETF	126.25	126.25	126.25	126.25	600.0
2015-07-14 19:00:00	IWM	ETF	126.23	126.25	126.23	126.23	2200.0
2015-07-14 08:00:00	DIA	ETF	179.62	179.62	179.45	179.45	5000.0
2015-07-14 09:00:00	DIA	ETF	179.3	179.81	179.3	179.72	418875.0
2015-07-14 10:00:00	DIA	ETF	179.73	179.95	179.62	179.91	361510.0
2015-07-14 11:00:00	DIA	ETF	179.91	180.23	179.91	180.2	417557.0
2015-07-14 12:00:00	DIA	ETF	180.22	180.3	180.03	180.16	316191.0

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

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