PREVIEW / etf_1hour / 2013-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-30.parquet
  size:    213 KB
  rows:    6,811

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-12-30 04:00:00	SPY	ETF	183.83	183.83	183.8	183.8	1950.0
2013-12-30 05:00:00	SPY	ETF	183.83	184.0	183.83	184.0	11886.0
2013-12-30 06:00:00	SPY	ETF	183.98	184.08	183.95	183.98	29119.0
2013-12-30 07:00:00	SPY	ETF	183.96	184.0	183.89	183.95	89826.0
2013-12-30 08:00:00	SPY	ETF	183.95	184.01	183.84	183.85	217779.0
2013-12-30 09:00:00	SPY	ETF	183.85	184.02	183.67	183.685	6324441.0
2013-12-30 10:00:00	SPY	ETF	183.685	183.8	183.58	183.69	7007622.0
2013-12-30 11:00:00	SPY	ETF	183.68	183.875	183.64	183.72	7401284.0
2013-12-30 12:00:00	SPY	ETF	183.72	183.75	183.58	183.63	4943773.0
2013-12-30 13:00:00	SPY	ETF	183.62	183.72	183.58	183.68	5503911.0
2013-12-30 14:00:00	SPY	ETF	183.6799	183.87	183.67	183.82	5382688.0
2013-12-30 15:00:00	SPY	ETF	183.83	183.84	183.65	183.81	11293944.0
2013-12-30 16:00:00	SPY	ETF	183.8	183.85	183.6	183.77	7728668.0
2013-12-30 17:00:00	SPY	ETF	183.79	183.81	183.75	183.75	62500.0
2013-12-30 18:00:00	SPY	ETF	183.78	183.78	183.73	183.75	13475.0
2013-12-30 19:00:00	SPY	ETF	183.74	183.77	183.74	183.75	36614.0
2013-12-30 06:00:00	QQQ	ETF	87.53	87.53	87.51	87.51	300.0
2013-12-30 07:00:00	QQQ	ETF	87.5	87.5	87.46	87.47	2975.0
2013-12-30 08:00:00	QQQ	ETF	87.49	87.49	87.41	87.41	20265.0
2013-12-30 09:00:00	QQQ	ETF	87.37	87.44	87.14	87.25	2495332.0
2013-12-30 10:00:00	QQQ	ETF	87.245	87.38	87.175	87.285	3009911.0
2013-12-30 11:00:00	QQQ	ETF	87.28	87.46	87.28	87.389	1930889.0
2013-12-30 12:00:00	QQQ	ETF	87.39	87.39	87.31	87.3201	1625913.0
2013-12-30 13:00:00	QQQ	ETF	87.325	87.41	87.32	87.355	1571719.0
2013-12-30 14:00:00	QQQ	ETF	87.35	87.51	87.34	87.4601	1226222.0
2013-12-30 15:00:00	QQQ	ETF	87.47	87.47	87.35	87.38	3250458.0
2013-12-30 16:00:00	QQQ	ETF	87.39	87.5012	87.3752	87.41	867584.0
2013-12-30 17:00:00	QQQ	ETF	87.43	87.43	87.41	87.42	1088.0
2013-12-30 19:00:00	QQQ	ETF	87.38	87.38	87.38	87.38	1875.0
2013-12-30 07:00:00	IWM	ETF	115.28	115.29	115.28	115.29	4950.0
2013-12-30 08:00:00	IWM	ETF	115.26	115.26	115.05	115.05	90483.0
2013-12-30 09:00:00	IWM	ETF	115.07	115.27	114.89	114.95	2683075.0
2013-12-30 10:00:00	IWM	ETF	114.95	115.13	114.85	115.0	3463440.0
2013-12-30 11:00:00	IWM	ETF	114.995	115.37	114.99	115.34	2280521.0
2013-12-30 12:00:00	IWM	ETF	115.335	115.37	115.1	115.205	1602953.0
2013-12-30 13:00:00	IWM	ETF	115.21	115.3	115.14	115.22	2154875.0
2013-12-30 14:00:00	IWM	ETF	115.22	115.37	115.19	115.33	1445620.0
2013-12-30 15:00:00	IWM	ETF	115.33	115.37	115.03	115.07	4711556.0
2013-12-30 16:00:00	IWM	ETF	115.06	115.2489	114.94	115.1778	3965462.0
2013-12-30 17:00:00	IWM	ETF	114.99	114.99	114.98	114.98	2000.0
2013-12-30 07:00:00	DIA	ETF	164.47	164.47	164.47	164.47	100.0
2013-12-30 09:00:00	DIA	ETF	164.49	164.68	164.44	164.47	548858.0
2013-12-30 10:00:00	DIA	ETF	164.46	164.58	164.409	164.45	622705.0
2013-12-30 11:00:00	DIA	ETF	164.431	164.64	164.43	164.458	658281.0
2013-12-30 12:00:00	DIA	ETF	164.45	164.5	164.4	164.42	232778.0
2013-12-30 13:00:00	DIA	ETF	164.43	164.51	164.4	164.46	256712.0
2013-12-30 14:00:00	DIA	ETF	164.446	164.63	164.446	164.592	317284.0
2013-12-30 15:00:00	DIA	ETF	164.6017	164.68	164.51	164.62	659111.0
2013-12-30 16:00:00	DIA	ETF	164.63	164.64	164.56	164.59	71155.0
2013-12-30 17:00:00	DIA	ETF	164.65	164.65	164.65	164.65	150.0

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

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