PREVIEW / etf_1hour / 2013-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-06.parquet
  size:    204 KB
  rows:    6,568

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
2013-11-06 04:00:00	SPY	ETF	176.75	177.01	176.75	176.98	263268.0
2013-11-06 05:00:00	SPY	ETF	176.98	177.17	176.93	177.12	513491.0
2013-11-06 06:00:00	SPY	ETF	177.16	177.2	177.0	177.0	74973.0
2013-11-06 07:00:00	SPY	ETF	177.03	177.12	176.93	177.01	225593.0
2013-11-06 08:00:00	SPY	ETF	177.0	177.07	176.9	176.93	643662.0
2013-11-06 09:00:00	SPY	ETF	176.94	177.5	176.88	177.34	12690649.0
2013-11-06 10:00:00	SPY	ETF	177.345	177.48	176.7	176.84	12688706.0
2013-11-06 11:00:00	SPY	ETF	176.83	176.99	176.54	176.79	10366929.0
2013-11-06 12:00:00	SPY	ETF	176.79	177.11	176.77	176.94	5107045.0
2013-11-06 13:00:00	SPY	ETF	176.93	177.17	176.88	177.03	6070477.0
2013-11-06 14:00:00	SPY	ETF	177.025	177.1	176.88	177.04	6929481.0
2013-11-06 15:00:00	SPY	ETF	177.05	177.24	176.88	177.15	19527390.0
2013-11-06 16:00:00	SPY	ETF	177.15	177.3473	176.4116	177.02	10162527.0
2013-11-06 17:00:00	SPY	ETF	177.03	177.03	176.88	176.93	715433.0
2013-11-06 18:00:00	SPY	ETF	176.92	176.92	176.7	176.76	169446.0
2013-11-06 19:00:00	SPY	ETF	176.76	176.82	176.71	176.82	49087.0
2013-11-06 04:00:00	QQQ	ETF	83.3	83.3	83.24	83.24	3200.0
2013-11-06 05:00:00	QQQ	ETF	83.3	83.32	83.3	83.32	11399.0
2013-11-06 06:00:00	QQQ	ETF	83.31	83.32	83.31	83.32	1040.0
2013-11-06 07:00:00	QQQ	ETF	83.26	83.32	83.26	83.27	35750.0
2013-11-06 08:00:00	QQQ	ETF	83.26	83.29	83.21	83.21	92915.0
2013-11-06 09:00:00	QQQ	ETF	83.21	83.4	83.1	83.31	4336926.0
2013-11-06 10:00:00	QQQ	ETF	83.32	83.365	82.84	82.9	5622976.0
2013-11-06 11:00:00	QQQ	ETF	82.9	83.03	82.73	82.92	3806971.0
2013-11-06 12:00:00	QQQ	ETF	82.91	83.01	82.83	82.84	2421246.0
2013-11-06 13:00:00	QQQ	ETF	82.83	83.01	82.79	82.89	1504498.0
2013-11-06 14:00:00	QQQ	ETF	82.88	82.99	82.84	82.94	1622837.0
2013-11-06 15:00:00	QQQ	ETF	82.93	83.05	82.89	82.99	4529481.0
2013-11-06 16:00:00	QQQ	ETF	83.0	83.326	82.85	82.875	828030.0
2013-11-06 17:00:00	QQQ	ETF	82.87	82.92	82.84	82.88	24879.0
2013-11-06 18:00:00	QQQ	ETF	82.85	82.85	82.72	82.72	65655.0
2013-11-06 19:00:00	QQQ	ETF	82.74	82.77	82.7	82.77	22326.0
2013-11-06 05:00:00	IWM	ETF	108.64	108.64	108.64	108.64	192.0
2013-11-06 07:00:00	IWM	ETF	110.65	110.69	110.32	110.33	128450.0
2013-11-06 08:00:00	IWM	ETF	110.31	110.39	110.25	110.26	206152.0
2013-11-06 09:00:00	IWM	ETF	110.28	110.37	109.93	110.08	5721439.0
2013-11-06 10:00:00	IWM	ETF	110.08	110.1	109.075	109.19	7048108.0
2013-11-06 11:00:00	IWM	ETF	109.18	109.39	108.905	109.26	5916807.0
2013-11-06 12:00:00	IWM	ETF	109.25	109.4301	109.17	109.29	1441562.0
2013-11-06 13:00:00	IWM	ETF	109.29	109.375	109.08	109.17	2477887.0
2013-11-06 14:00:00	IWM	ETF	109.165	109.235	109.03	109.15	1798797.0
2013-11-06 15:00:00	IWM	ETF	109.16	109.29	109.02	109.1	4710470.0
2013-11-06 16:00:00	IWM	ETF	109.1	109.19	109.06	109.12	1443973.0
2013-11-06 17:00:00	IWM	ETF	109.11	109.11	109.04	109.08	15370.0
2013-11-06 18:00:00	IWM	ETF	109.08	109.08	108.92	108.92	3200.0
2013-11-06 19:00:00	IWM	ETF	108.96	108.96	108.9	108.9	16456.0
2013-11-06 04:00:00	DIA	ETF	156.36	156.36	156.36	156.36	100.0
2013-11-06 07:00:00	DIA	ETF	156.45	156.45	156.45	156.45	1800.0
2013-11-06 08:00:00	DIA	ETF	156.36	156.4	156.33	156.38	7700.0
2013-11-06 09:00:00	DIA	ETF	156.38	157.06	156.37	156.96	1473449.0

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

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