PREVIEW / etf_1hour / 2013-12-24

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-24.parquet
  size:    132 KB
  rows:    3,986

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-24 04:00:00	SPY	ETF	182.62	182.62	182.57	182.61	5350.0
2013-12-24 05:00:00	SPY	ETF	182.58	182.63	182.56	182.59	12102.0
2013-12-24 06:00:00	SPY	ETF	182.58	182.64	182.51	182.51	8314.0
2013-12-24 07:00:00	SPY	ETF	182.5	182.5	182.39	182.46	41083.0
2013-12-24 08:00:00	SPY	ETF	182.44	182.59	182.43	182.57	201599.0
2013-12-24 09:00:00	SPY	ETF	182.56	182.71	182.49	182.64	10537969.0
2013-12-24 10:00:00	SPY	ETF	182.645	182.89	182.62	182.86	8494450.0
2013-12-24 11:00:00	SPY	ETF	182.86	182.99	182.81	182.94	7525404.0
2013-12-24 12:00:00	SPY	ETF	182.955	183.01	182.88	182.96	11902285.0
2013-12-24 13:00:00	SPY	ETF	182.96	183.45	182.4518	183.35	3448594.0
2013-12-24 14:00:00	SPY	ETF	183.35	183.43	182.93	182.93	1793328.0
2013-12-24 15:00:00	SPY	ETF	183.35	183.35	183.3	183.319	18818.0
2013-12-24 16:00:00	SPY	ETF	183.31	183.35	183.3	183.35	17257.0
2013-12-24 04:00:00	QQQ	ETF	87.39	87.39	87.39	87.39	340.0
2013-12-24 06:00:00	QQQ	ETF	87.38	87.38	87.36	87.36	900.0
2013-12-24 07:00:00	QQQ	ETF	87.34	87.36	87.32	87.36	11067.0
2013-12-24 08:00:00	QQQ	ETF	87.38	87.42	87.37	87.4	39700.0
2013-12-24 09:00:00	QQQ	ETF	87.41	87.51	87.3301	87.43	3047262.0
2013-12-24 10:00:00	QQQ	ETF	87.42	87.445	87.27	87.3405	4060802.0
2013-12-24 11:00:00	QQQ	ETF	87.345	87.42	87.33	87.37	1558513.0
2013-12-24 12:00:00	QQQ	ETF	87.37	87.49	87.37	87.47	3510258.0
2013-12-24 13:00:00	QQQ	ETF	87.45	87.59	87.45	87.5701	624414.0
2013-12-24 14:00:00	QQQ	ETF	87.57	87.58	87.45	87.57	697754.0
2013-12-24 15:00:00	QQQ	ETF	87.57	87.6	87.57	87.6	300.0
2013-12-24 16:00:00	QQQ	ETF	87.57	87.59	87.57	87.59	1403.0
2013-12-24 07:00:00	IWM	ETF	114.66	114.66	114.66	114.66	5400.0
2013-12-24 08:00:00	IWM	ETF	114.71	114.8	114.69	114.8	33500.0
2013-12-24 09:00:00	IWM	ETF	114.8	115.04	114.74	115.01	2788797.0
2013-12-24 10:00:00	IWM	ETF	115.02	115.44	114.98	115.26	4617830.0
2013-12-24 11:00:00	IWM	ETF	115.25	115.44	115.21	115.39	1760261.0
2013-12-24 12:00:00	IWM	ETF	115.389	115.43	115.11	115.17	3808649.0
2013-12-24 13:00:00	IWM	ETF	115.17	115.46	115.17	115.24	1104472.0
2013-12-24 14:00:00	IWM	ETF	115.23	115.23	115.22	115.22	1530541.0
2013-12-24 08:00:00	DIA	ETF	162.73	162.82	162.73	162.8	1500.0
2013-12-24 09:00:00	DIA	ETF	162.76	162.96	162.71	162.8901	519063.0
2013-12-24 10:00:00	DIA	ETF	162.89	163.03	162.86	162.97	501036.0
2013-12-24 11:00:00	DIA	ETF	162.98	163.15	162.97	163.1	324924.0
2013-12-24 12:00:00	DIA	ETF	163.12	163.26	163.08	163.2	768264.0
2013-12-24 13:00:00	DIA	ETF	163.19	163.3	162.86	163.3	103775.0
2013-12-24 15:00:00	DIA	ETF	163.23	163.23	163.23	163.23	300.0
2013-12-24 16:00:00	DIA	ETF	163.15	163.15	163.15	163.15	350.0
2013-12-24 07:00:00	GLD	ETF	115.77	115.85	115.77	115.85	975.0
2013-12-24 08:00:00	GLD	ETF	115.7	115.9	115.7	115.81	9350.0
2013-12-24 09:00:00	GLD	ETF	115.87	116.0	115.43	115.79	511807.0
2013-12-24 10:00:00	GLD	ETF	115.78	116.01	115.71	115.93	667419.0
2013-12-24 11:00:00	GLD	ETF	115.9199	116.04	115.85	116.0201	605580.0
2013-12-24 12:00:00	GLD	ETF	116.029	116.29	116.0101	116.13	1201608.0
2013-12-24 13:00:00	GLD	ETF	116.1	116.25	116.09	116.25	65581.0
2013-12-24 14:00:00	GLD	ETF	116.25	116.251	116.25	116.25	1325.0
2013-12-24 15:00:00	GLD	ETF	116.25	116.25	116.25	116.25	950.0

> showing 50 of 3,986 rows — these rows as CSV

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