PREVIEW / etf_1hour / 2013-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-14.parquet
  size:    203 KB
  rows:    6,383

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-08-14 04:00:00	SPY	ETF	169.51	169.51	169.04	169.2	26884.0
2013-08-14 05:00:00	SPY	ETF	169.18	169.24	169.1	169.23	6982.0
2013-08-14 06:00:00	SPY	ETF	169.23	169.38	169.23	169.38	34700.0
2013-08-14 07:00:00	SPY	ETF	169.4	169.4	169.29	169.36	98788.0
2013-08-14 08:00:00	SPY	ETF	169.28	169.37	169.06	169.32	567427.0
2013-08-14 09:00:00	SPY	ETF	169.32	169.8	169.32	169.58	9779073.0
2013-08-14 10:00:00	SPY	ETF	169.59	169.67	168.86	169.06	13521362.0
2013-08-14 11:00:00	SPY	ETF	169.05	169.22	168.86	168.98	9838797.0
2013-08-14 12:00:00	SPY	ETF	168.98	169.27	168.95	169.02	6763980.0
2013-08-14 13:00:00	SPY	ETF	169.02	169.16	168.7	168.9	10736079.0
2013-08-14 14:00:00	SPY	ETF	168.895	169.04	168.72	168.95	6797039.0
2013-08-14 15:00:00	SPY	ETF	168.95	169.2	168.71	168.74	14493034.0
2013-08-14 16:00:00	SPY	ETF	168.74	169.6442	168.6	168.68	5210268.0
2013-08-14 17:00:00	SPY	ETF	168.68	169.0764	168.48	168.52	497677.0
2013-08-14 18:00:00	SPY	ETF	168.52	168.52	168.21	168.34	221557.0
2013-08-14 19:00:00	SPY	ETF	168.33	168.37	168.28	168.3	36764.0
2013-08-14 04:00:00	QQQ	ETF	76.92	76.97	76.91	76.97	19000.0
2013-08-14 05:00:00	QQQ	ETF	76.95	77.0	76.91	77.0	8324.0
2013-08-14 06:00:00	QQQ	ETF	77.01	77.07	77.01	77.07	6600.0
2013-08-14 07:00:00	QQQ	ETF	77.03	77.05	77.02	77.04	29052.0
2013-08-14 08:00:00	QQQ	ETF	77.02	77.03	76.89	77.0	75027.0
2013-08-14 09:00:00	QQQ	ETF	77.01	77.18	76.93	77.099	4555909.0
2013-08-14 10:00:00	QQQ	ETF	77.11	77.1499	76.7	76.88	4458104.0
2013-08-14 11:00:00	QQQ	ETF	76.87	76.95	76.81	76.87	2314136.0
2013-08-14 12:00:00	QQQ	ETF	76.87	77.06	76.87	76.96	2706039.0
2013-08-14 13:00:00	QQQ	ETF	76.95	77.0	76.76	76.825	2191250.0
2013-08-14 14:00:00	QQQ	ETF	76.83	76.98	76.81	76.95	2384450.0
2013-08-14 15:00:00	QQQ	ETF	76.96	77.04	76.79	76.82	4009495.0
2013-08-14 16:00:00	QQQ	ETF	76.81	77.1025	76.55	76.58	2966949.0
2013-08-14 17:00:00	QQQ	ETF	76.57	76.57	76.27	76.35	719973.0
2013-08-14 18:00:00	QQQ	ETF	76.39	76.41	76.25	76.28	199106.0
2013-08-14 19:00:00	QQQ	ETF	76.3	76.31	76.26	76.29	17694.0
2013-08-14 07:00:00	IWM	ETF	104.32	104.35	104.28	104.32	6960.0
2013-08-14 08:00:00	IWM	ETF	104.33	104.34	104.16	104.34	106858.0
2013-08-14 09:00:00	IWM	ETF	104.34	104.64	104.2	104.53	2862700.0
2013-08-14 10:00:00	IWM	ETF	104.54	104.6	104.1303	104.29	4452007.0
2013-08-14 11:00:00	IWM	ETF	104.295	104.3	104.05	104.18	2703435.0
2013-08-14 12:00:00	IWM	ETF	104.178	104.42	104.16	104.205	1905731.0
2013-08-14 13:00:00	IWM	ETF	104.205	104.32	104.06	104.22	2254761.0
2013-08-14 14:00:00	IWM	ETF	104.22	104.3	104.02	104.11	2344932.0
2013-08-14 15:00:00	IWM	ETF	104.12	104.265	104.01	104.02	4100359.0
2013-08-14 16:00:00	IWM	ETF	104.03	104.2725	103.97	104.04	927295.0
2013-08-14 17:00:00	IWM	ETF	104.04	104.04	103.9	103.9	56066.0
2013-08-14 18:00:00	IWM	ETF	103.7	103.85	103.7	103.84	400.0
2013-08-14 19:00:00	IWM	ETF	103.8	103.8	103.75	103.75	3000.0
2013-08-14 07:00:00	DIA	ETF	154.3	154.3	154.24	154.24	1600.0
2013-08-14 08:00:00	DIA	ETF	154.11	154.11	153.96	154.08	2500.0
2013-08-14 09:00:00	DIA	ETF	154.22	154.43	153.82	154.12	788558.0
2013-08-14 10:00:00	DIA	ETF	154.12	154.23	153.47	153.6245	1022366.0
2013-08-14 11:00:00	DIA	ETF	153.626	153.88	153.5199	153.63	586011.0

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

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