PREVIEW / etf_1hour / 2013-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-19.parquet
  size:    202 KB
  rows:    6,395

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-06-19 04:00:00	SPY	ETF	165.61	165.94	165.41	165.84	9750.0
2013-06-19 05:00:00	SPY	ETF	165.88	166.02	165.79	165.96	13400.0
2013-06-19 06:00:00	SPY	ETF	165.97	165.97	165.74	165.78	20300.0
2013-06-19 07:00:00	SPY	ETF	165.78	165.8	165.49	165.61	253734.0
2013-06-19 08:00:00	SPY	ETF	165.56	165.81	165.52	165.62	462502.0
2013-06-19 09:00:00	SPY	ETF	165.61	165.83	165.23	165.41	11860434.0
2013-06-19 10:00:00	SPY	ETF	165.4	165.78	165.28	165.55	13265050.0
2013-06-19 11:00:00	SPY	ETF	165.56	165.72	165.43	165.45	11740686.0
2013-06-19 12:00:00	SPY	ETF	165.45	165.6	165.33	165.46	10922085.0
2013-06-19 13:00:00	SPY	ETF	165.46	165.74	165.41	165.74	9660619.0
2013-06-19 14:00:00	SPY	ETF	165.72	165.89	163.83	163.98	63882337.0
2013-06-19 15:00:00	SPY	ETF	163.99	164.72	163.38	163.46	54580712.0
2013-06-19 16:00:00	SPY	ETF	163.49	165.7263	163.24	163.35	19158456.0
2013-06-19 17:00:00	SPY	ETF	163.38	165.7263	163.18	163.25	6270087.0
2013-06-19 18:00:00	SPY	ETF	163.25	163.43	163.25	163.43	183524.0
2013-06-19 19:00:00	SPY	ETF	163.39	163.39	163.27	163.28	55415.0
2013-06-19 04:00:00	QQQ	ETF	73.55	73.74	73.53	73.7	6600.0
2013-06-19 05:00:00	QQQ	ETF	73.69	73.74	73.64	73.72	15000.0
2013-06-19 06:00:00	QQQ	ETF	73.7	73.72	73.66	73.66	8100.0
2013-06-19 07:00:00	QQQ	ETF	73.64	73.64	73.52	73.56	21200.0
2013-06-19 08:00:00	QQQ	ETF	73.59	73.65	73.56	73.6	18563.0
2013-06-19 09:00:00	QQQ	ETF	73.59	73.68	73.43	73.52	2921809.0
2013-06-19 10:00:00	QQQ	ETF	73.51	73.67	73.46	73.55	3056422.0
2013-06-19 11:00:00	QQQ	ETF	73.55	73.62	73.45	73.46	1730162.0
2013-06-19 12:00:00	QQQ	ETF	73.45	73.51	73.41	73.43	1699076.0
2013-06-19 13:00:00	QQQ	ETF	73.44	73.49	73.41	73.47	1764075.0
2013-06-19 14:00:00	QQQ	ETF	73.47	73.61	72.82	72.88	16944953.0
2013-06-19 15:00:00	QQQ	ETF	72.878	73.22	72.68	72.71	11149179.0
2013-06-19 16:00:00	QQQ	ETF	72.72	73.485	72.65	72.68	849500.0
2013-06-19 17:00:00	QQQ	ETF	72.69	72.69	72.62	72.65	16300.0
2013-06-19 18:00:00	QQQ	ETF	72.64	72.71	72.64	72.71	10866.0
2013-06-19 19:00:00	QQQ	ETF	72.71	72.71	72.66	72.67	10950.0
2013-06-19 06:00:00	IWM	ETF	99.66	99.66	99.65	99.66	800.0
2013-06-19 07:00:00	IWM	ETF	99.63	99.63	99.47	99.47	11962.0
2013-06-19 08:00:00	IWM	ETF	99.52	99.66	99.49	99.56	65438.0
2013-06-19 09:00:00	IWM	ETF	99.55	99.7	99.24	99.35	2046039.0
2013-06-19 10:00:00	IWM	ETF	99.34	99.4	99.06	99.13	3650233.0
2013-06-19 11:00:00	IWM	ETF	99.14	99.23	98.91	98.91	2665901.0
2013-06-19 12:00:00	IWM	ETF	98.92	99.075	98.88	98.99	2110288.0
2013-06-19 13:00:00	IWM	ETF	98.99	99.14	98.95	99.12	2848844.0
2013-06-19 14:00:00	IWM	ETF	99.09	99.45	98.25	98.31	14387077.0
2013-06-19 15:00:00	IWM	ETF	98.299	98.82	98.16	98.22	10803187.0
2013-06-19 16:00:00	IWM	ETF	98.22	99.31	97.95	98.0	1967010.0
2013-06-19 17:00:00	IWM	ETF	97.99	98.03	97.91	97.95	36050.0
2013-06-19 18:00:00	IWM	ETF	98.05	98.12	97.95	98.1	28859.0
2013-06-19 19:00:00	IWM	ETF	98.07	98.15	98.03	98.14	5613.0
2013-06-19 07:00:00	DIA	ETF	153.0	153.06	153.0	153.06	945.0
2013-06-19 08:00:00	DIA	ETF	153.1	153.1	152.94	153.01	4300.0
2013-06-19 09:00:00	DIA	ETF	153.0	153.13	152.67	152.7701	403011.0
2013-06-19 10:00:00	DIA	ETF	152.77	153.15	152.66	152.94	669932.0

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

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