PREVIEW / etf_1hour / 2013-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-31.parquet
  size:    204 KB
  rows:    6,376

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-07-31 04:00:00	SPY	ETF	168.83	169.18	168.83	169.15	7300.0
2013-07-31 05:00:00	SPY	ETF	169.13	169.13	168.93	168.98	41900.0
2013-07-31 06:00:00	SPY	ETF	168.98	169.14	168.98	168.98	106825.0
2013-07-31 07:00:00	SPY	ETF	168.94	169.02	168.83	168.83	102280.0
2013-07-31 08:00:00	SPY	ETF	168.89	169.1	168.58	168.96	1657053.0
2013-07-31 09:00:00	SPY	ETF	168.95	169.2499	168.82	169.13	11319742.0
2013-07-31 10:00:00	SPY	ETF	169.13	169.69	168.98	169.62	17192541.0
2013-07-31 11:00:00	SPY	ETF	169.625	169.68	169.29	169.31	10532018.0
2013-07-31 12:00:00	SPY	ETF	169.3	169.32	168.92	168.97	7792686.0
2013-07-31 13:00:00	SPY	ETF	168.97	169.03	168.86	168.99	7317427.0
2013-07-31 14:00:00	SPY	ETF	168.99	169.84	168.57	169.835	29103542.0
2013-07-31 15:00:00	SPY	ETF	169.84	169.85	168.49	168.61	38627862.0
2013-07-31 16:00:00	SPY	ETF	168.61	169.381	168.55	169.01	15172830.0
2013-07-31 17:00:00	SPY	ETF	169.03	169.05	168.94	168.98	123410.0
2013-07-31 18:00:00	SPY	ETF	168.98	169.04	168.94	168.99	28373.0
2013-07-31 19:00:00	SPY	ETF	168.97	169.03	168.92	169.01	32580.0
2013-07-31 04:00:00	QQQ	ETF	75.72	75.8	75.72	75.8	6000.0
2013-07-31 05:00:00	QQQ	ETF	75.78	75.78	75.72	75.76	5800.0
2013-07-31 06:00:00	QQQ	ETF	75.77	75.79	75.74	75.74	4600.0
2013-07-31 07:00:00	QQQ	ETF	75.76	75.8	75.72	75.73	41900.0
2013-07-31 08:00:00	QQQ	ETF	75.72	75.81	75.64	75.76	165590.0
2013-07-31 09:00:00	QQQ	ETF	75.76	76.03	75.72	75.95	3407795.0
2013-07-31 10:00:00	QQQ	ETF	75.94	75.98	75.778	75.93	3167572.0
2013-07-31 11:00:00	QQQ	ETF	75.93	75.97	75.8399	75.8925	1424577.0
2013-07-31 12:00:00	QQQ	ETF	75.899	75.899	75.72	75.75	1282961.0
2013-07-31 13:00:00	QQQ	ETF	75.75	75.83	75.7	75.83	1252240.0
2013-07-31 14:00:00	QQQ	ETF	75.83	76.2099	75.63	76.209	4777749.0
2013-07-31 15:00:00	QQQ	ETF	76.1999	76.2	75.65	75.75	7405767.0
2013-07-31 16:00:00	QQQ	ETF	75.74	76.06	75.7077	75.89	1104806.0
2013-07-31 17:00:00	QQQ	ETF	75.89	75.9	75.8	75.82	31150.0
2013-07-31 18:00:00	QQQ	ETF	75.83	75.9	75.83	75.9	4200.0
2013-07-31 19:00:00	QQQ	ETF	75.85	75.88	75.85	75.86	3202.0
2013-07-31 08:00:00	IWM	ETF	103.73	103.98	103.71	103.96	550250.0
2013-07-31 09:00:00	IWM	ETF	103.93	104.0901	103.78	103.97	2790029.0
2013-07-31 10:00:00	IWM	ETF	103.96	104.32	103.9	104.25	4520470.0
2013-07-31 11:00:00	IWM	ETF	104.25	104.26	103.88	103.95	2995322.0
2013-07-31 12:00:00	IWM	ETF	103.95	103.98	103.61	103.68	1710849.0
2013-07-31 13:00:00	IWM	ETF	103.67	103.92	103.64	103.87	2193572.0
2013-07-31 14:00:00	IWM	ETF	103.86	104.68	103.69	104.6085	8338382.0
2013-07-31 15:00:00	IWM	ETF	104.6	104.615	103.65	103.66	9674338.0
2013-07-31 16:00:00	IWM	ETF	103.65	104.1822	103.63	103.88	2589795.0
2013-07-31 17:00:00	IWM	ETF	103.88	103.88	103.85	103.85	6300.0
2013-07-31 18:00:00	IWM	ETF	103.9	103.98	103.84	103.88	1800.0
2013-07-31 19:00:00	IWM	ETF	103.92	103.92	103.87	103.91	1987.0
2013-07-31 04:00:00	DIA	ETF	155.1	155.1	155.1	155.1	100.0
2013-07-31 08:00:00	DIA	ETF	154.97	155.06	154.81	155.04	1560.0
2013-07-31 09:00:00	DIA	ETF	155.05	155.49	155.0	155.36	648608.0
2013-07-31 10:00:00	DIA	ETF	155.35	156.03	155.3	155.84	1452249.0
2013-07-31 11:00:00	DIA	ETF	155.85	155.87	155.48	155.48	854497.0
2013-07-31 12:00:00	DIA	ETF	155.47	155.5	155.021	155.0399	433272.0

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

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