PREVIEW / etf_1hour / 2013-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-01.parquet
  size:    208 KB
  rows:    6,490

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-10-01 04:00:00	SPY	ETF	168.65	168.84	168.65	168.72	27100.0
2013-10-01 05:00:00	SPY	ETF	168.74	168.76	168.44	168.6	32342.0
2013-10-01 06:00:00	SPY	ETF	168.6	168.72	168.6	168.62	73388.0
2013-10-01 07:00:00	SPY	ETF	168.61	168.62	168.26	168.4	323981.0
2013-10-01 08:00:00	SPY	ETF	168.39	168.58	168.09	168.36	828985.0
2013-10-01 09:00:00	SPY	ETF	168.37	168.7	168.0	168.28	20021841.0
2013-10-01 10:00:00	SPY	ETF	168.28	169.275	168.23	169.16	22088017.0
2013-10-01 11:00:00	SPY	ETF	169.17	169.4	169.04	169.29	13858354.0
2013-10-01 12:00:00	SPY	ETF	169.28	169.5	169.18	169.23	8366597.0
2013-10-01 13:00:00	SPY	ETF	169.22	169.35	169.08	169.171	7045371.0
2013-10-01 14:00:00	SPY	ETF	169.1776	169.18	168.77	168.9595	12951526.0
2013-10-01 15:00:00	SPY	ETF	168.956	169.38	168.7	169.33	24412555.0
2013-10-01 16:00:00	SPY	ETF	169.3	169.69	167.9671	169.56	11222433.0
2013-10-01 17:00:00	SPY	ETF	169.57	169.68	167.9671	169.62	1751992.0
2013-10-01 18:00:00	SPY	ETF	169.6	169.63	169.53	169.57	97735.0
2013-10-01 19:00:00	SPY	ETF	169.55	169.55	169.38	169.4	76718.0
2013-10-01 04:00:00	QQQ	ETF	79.13	79.21	79.11	79.13	28160.0
2013-10-01 05:00:00	QQQ	ETF	79.14	79.15	78.98	79.09	39800.0
2013-10-01 06:00:00	QQQ	ETF	79.08	79.11	79.06	79.06	17600.0
2013-10-01 07:00:00	QQQ	ETF	79.05	79.06	78.93	78.98	86700.0
2013-10-01 08:00:00	QQQ	ETF	78.94	79.05	78.87	79.02	164143.0
2013-10-01 09:00:00	QQQ	ETF	79.02	79.22	78.8456	78.95	4081119.0
2013-10-01 10:00:00	QQQ	ETF	78.96	79.54	78.93	79.49	5758434.0
2013-10-01 11:00:00	QQQ	ETF	79.5	79.6	79.42	79.56	2181134.0
2013-10-01 12:00:00	QQQ	ETF	79.56	79.72	79.53	79.57	2650581.0
2013-10-01 13:00:00	QQQ	ETF	79.571	79.62	79.45	79.51	1373002.0
2013-10-01 14:00:00	QQQ	ETF	79.519	79.52	79.32	79.419	2056058.0
2013-10-01 15:00:00	QQQ	ETF	79.41	79.69	79.3	79.67	3665137.0
2013-10-01 16:00:00	QQQ	ETF	79.66	79.8	78.8223	79.72	5225846.0
2013-10-01 17:00:00	QQQ	ETF	79.74	79.79	79.3895	79.75	46408.0
2013-10-01 18:00:00	QQQ	ETF	79.76	79.76	78.85	79.73	74802.0
2013-10-01 19:00:00	QQQ	ETF	79.73	79.74	79.67	79.67	30460.0
2013-10-01 04:00:00	IWM	ETF	106.71	106.92	106.71	106.92	200.0
2013-10-01 07:00:00	IWM	ETF	106.78	106.8	106.67	106.76	156590.0
2013-10-01 08:00:00	IWM	ETF	106.8	106.82	106.5	106.75	173645.0
2013-10-01 09:00:00	IWM	ETF	106.75	107.18	106.45	106.89	6792349.0
2013-10-01 10:00:00	IWM	ETF	106.91	107.53	106.8051	107.45	6689092.0
2013-10-01 11:00:00	IWM	ETF	107.46	107.845	107.44	107.73	4082921.0
2013-10-01 12:00:00	IWM	ETF	107.73	107.85	107.475	107.53	2285798.0
2013-10-01 13:00:00	IWM	ETF	107.54	107.67	107.4	107.65	2632528.0
2013-10-01 14:00:00	IWM	ETF	107.6473	107.65	107.19	107.43	3531675.0
2013-10-01 15:00:00	IWM	ETF	107.42	107.9	107.34	107.87	7775658.0
2013-10-01 16:00:00	IWM	ETF	107.87	108.12	107.372	107.5875	2201895.0
2013-10-01 17:00:00	IWM	ETF	108.01	108.05	107.357	107.98	494544.0
2013-10-01 18:00:00	IWM	ETF	107.98	108.01	107.93	108.01	9859.0
2013-10-01 19:00:00	IWM	ETF	107.95	107.98	107.91	107.91	8604.0
2013-10-01 06:00:00	DIA	ETF	151.65	151.65	151.65	151.65	300.0
2013-10-01 07:00:00	DIA	ETF	151.3	151.3	151.2	151.2	550.0
2013-10-01 08:00:00	DIA	ETF	151.14	151.25	151.06	151.18	2400.0
2013-10-01 09:00:00	DIA	ETF	151.16	151.26	150.82	150.84	1223773.0

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

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