PREVIEW / etf_1hour / 2014-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-01.parquet
  size:    238 KB
  rows:    7,572

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-12-01 04:00:00	SPY	ETF	206.73	207.0	205.84	206.24	95922.0
2014-12-01 05:00:00	SPY	ETF	206.19	206.3	206.07	206.27	63450.0
2014-12-01 06:00:00	SPY	ETF	206.28	206.45	206.22	206.42	19655.0
2014-12-01 07:00:00	SPY	ETF	206.46	206.63	206.2	206.3	302890.0
2014-12-01 08:00:00	SPY	ETF	206.376	207.2	206.03	206.3	1482929.0
2014-12-01 09:00:00	SPY	ETF	206.32	207.2	205.46	205.721	13712168.0
2014-12-01 10:00:00	SPY	ETF	205.73	206.43	205.38	205.48	18815178.0
2014-12-01 11:00:00	SPY	ETF	205.47	206.0	205.44	205.61	16714568.0
2014-12-01 12:00:00	SPY	ETF	205.61	206.16	205.5699	206.13	9322476.0
2014-12-01 13:00:00	SPY	ETF	206.12	206.38	206.1	206.16	9407722.0
2014-12-01 14:00:00	SPY	ETF	206.16	206.19	205.61	205.855	8893340.0
2014-12-01 15:00:00	SPY	ETF	205.8599	206.29	205.75	205.8	17405607.0
2014-12-01 16:00:00	SPY	ETF	205.79	207.1813	205.5	205.59	4808040.0
2014-12-01 17:00:00	SPY	ETF	205.59	205.64	205.54	205.58	201406.0
2014-12-01 18:00:00	SPY	ETF	205.6	205.7	205.59	205.64	116409.0
2014-12-01 19:00:00	SPY	ETF	205.65	205.74	205.63	205.64	36875.0
2014-12-01 04:00:00	QQQ	ETF	105.86	105.86	105.43	105.75	2097.0
2014-12-01 05:00:00	QQQ	ETF	105.77	105.77	105.76	105.77	22600.0
2014-12-01 06:00:00	QQQ	ETF	105.77	105.84	105.75	105.84	24347.0
2014-12-01 07:00:00	QQQ	ETF	105.92	105.92	105.72	105.73	62452.0
2014-12-01 08:00:00	QQQ	ETF	105.74	105.8	105.51	105.7	119515.0
2014-12-01 09:00:00	QQQ	ETF	105.7	105.9199	104.42	105.03	9287815.0
2014-12-01 10:00:00	QQQ	ETF	105.03	105.4	104.65	104.72	6270027.0
2014-12-01 11:00:00	QQQ	ETF	104.71	104.95	104.68	104.73	3459823.0
2014-12-01 12:00:00	QQQ	ETF	104.72	105.05	104.68	105.03	2226315.0
2014-12-01 13:00:00	QQQ	ETF	105.03	105.29	105.02	105.1	2801396.0
2014-12-01 14:00:00	QQQ	ETF	105.1	105.13	104.63	104.82	2556505.0
2014-12-01 15:00:00	QQQ	ETF	104.81	105.02	104.67	104.81	3985390.0
2014-12-01 16:00:00	QQQ	ETF	104.82	106.0123	104.66	104.73	2518685.0
2014-12-01 17:00:00	QQQ	ETF	104.73	104.78	104.72	104.78	10050.0
2014-12-01 18:00:00	QQQ	ETF	104.75	104.78	104.741	104.75	9155.0
2014-12-01 19:00:00	QQQ	ETF	104.77	104.83	104.77	104.77	3375.0
2014-12-01 04:00:00	IWM	ETF	116.0	116.0	115.67	115.67	748.0
2014-12-01 06:00:00	IWM	ETF	115.91	116.05	115.91	116.05	380.0
2014-12-01 07:00:00	IWM	ETF	116.23	116.23	116.11	116.11	1100.0
2014-12-01 08:00:00	IWM	ETF	116.5	116.77	115.94	116.23	235504.0
2014-12-01 09:00:00	IWM	ETF	116.23	116.5	115.43	115.73	5023616.0
2014-12-01 10:00:00	IWM	ETF	115.73	116.1699	114.95	115.05	6548058.0
2014-12-01 11:00:00	IWM	ETF	115.05	115.52	114.99	115.1	4716451.0
2014-12-01 12:00:00	IWM	ETF	115.09	115.51	115.04	115.475	3192345.0
2014-12-01 13:00:00	IWM	ETF	115.48	115.57	115.215	115.255	2334030.0
2014-12-01 14:00:00	IWM	ETF	115.25	115.34	114.91	115.23	3412500.0
2014-12-01 15:00:00	IWM	ETF	115.23	115.49	114.81	114.88	6131254.0
2014-12-01 16:00:00	IWM	ETF	114.88	114.98	114.7	114.81	2420103.0
2014-12-01 17:00:00	IWM	ETF	114.79	114.86	114.79	114.86	3702.0
2014-12-01 18:00:00	IWM	ETF	114.86	114.89	114.86	114.88	1450.0
2014-12-01 19:00:00	IWM	ETF	114.82	114.94	114.82	114.87	4372.0
2014-12-01 07:00:00	DIA	ETF	177.5	177.5	177.5	177.5	1100.0
2014-12-01 08:00:00	DIA	ETF	177.5	177.5	177.3	177.361	30214.0
2014-12-01 09:00:00	DIA	ETF	177.7	177.75	177.026	177.08	1708259.0

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

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