PREVIEW / etf_1hour / 2013-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-08.parquet
  size:    199 KB
  rows:    6,139

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-04-08 04:00:00	SPY	ETF	155.31	155.47	155.22	155.47	15472.0
2013-04-08 05:00:00	SPY	ETF	155.42	155.42	155.39	155.41	44700.0
2013-04-08 06:00:00	SPY	ETF	155.46	155.52	155.42	155.5	46580.0
2013-04-08 07:00:00	SPY	ETF	155.49	155.62	155.47	155.61	347554.0
2013-04-08 08:00:00	SPY	ETF	155.59	155.62	155.42	155.43	721563.0
2013-04-08 09:00:00	SPY	ETF	155.44	155.44	154.81	155.02	11958592.0
2013-04-08 10:00:00	SPY	ETF	155.03	155.26	154.75	155.22	14457166.0
2013-04-08 11:00:00	SPY	ETF	155.221	155.26	154.99	155.06	7568252.0
2013-04-08 12:00:00	SPY	ETF	155.06	155.205	154.94	155.1099	6869371.0
2013-04-08 13:00:00	SPY	ETF	155.11	155.625	155.1	155.601	7657668.0
2013-04-08 14:00:00	SPY	ETF	155.6022	155.8	155.58	155.675	8402623.0
2013-04-08 15:00:00	SPY	ETF	155.67	156.22	155.2534	156.19	19760808.0
2013-04-08 16:00:00	SPY	ETF	156.19	156.66	156.0223	156.66	5927087.0
2013-04-08 17:00:00	SPY	ETF	156.63	156.65	156.46	156.49	285834.0
2013-04-08 18:00:00	SPY	ETF	156.5	156.53	156.4	156.44	89679.0
2013-04-08 19:00:00	SPY	ETF	156.43	156.47	156.4	156.46	75035.0
2013-04-08 04:00:00	QQQ	ETF	67.97	67.97	67.97	67.97	1400.0
2013-04-08 05:00:00	QQQ	ETF	68.0	68.0	67.97	67.97	4398.0
2013-04-08 06:00:00	QQQ	ETF	68.01	68.04	68.01	68.03	14722.0
2013-04-08 07:00:00	QQQ	ETF	68.04	68.1	68.04	68.1	43900.0
2013-04-08 08:00:00	QQQ	ETF	68.09	68.1	68.0	68.02	316142.0
2013-04-08 09:00:00	QQQ	ETF	68.0	68.0	67.78	67.88	3032812.0
2013-04-08 10:00:00	QQQ	ETF	67.88	67.91	67.69	67.87	2714074.0
2013-04-08 11:00:00	QQQ	ETF	67.87	67.8892	67.75	67.79	1736841.0
2013-04-08 12:00:00	QQQ	ETF	67.79	67.83	67.69	67.79	787500.0
2013-04-08 13:00:00	QQQ	ETF	67.79	68.02	67.78	68.01	1223090.0
2013-04-08 14:00:00	QQQ	ETF	68.01	68.1	67.98	67.98	1779707.0
2013-04-08 15:00:00	QQQ	ETF	67.99	68.24	67.98	68.23	4579305.0
2013-04-08 16:00:00	QQQ	ETF	68.23	68.42	68.0136	68.42	1073560.0
2013-04-08 17:00:00	QQQ	ETF	68.43	68.43	68.1594	68.36	58060.0
2013-04-08 18:00:00	QQQ	ETF	68.37	68.39	68.33	68.33	9825.0
2013-04-08 19:00:00	QQQ	ETF	68.34	68.34	68.32	68.34	2850.0
2013-04-08 04:00:00	IWM	ETF	91.65	91.99	91.65	91.99	300.0
2013-04-08 05:00:00	IWM	ETF	92.1	92.1	92.05	92.09	750.0
2013-04-08 06:00:00	IWM	ETF	92.17	92.25	92.17	92.25	3699.0
2013-04-08 07:00:00	IWM	ETF	92.21	92.31	92.21	92.28	44924.0
2013-04-08 08:00:00	IWM	ETF	92.28	92.28	92.09	92.09	156630.0
2013-04-08 09:00:00	IWM	ETF	92.06	92.06	91.43	91.55	4792539.0
2013-04-08 10:00:00	IWM	ETF	91.56	91.84	91.33	91.6301	4750323.0
2013-04-08 11:00:00	IWM	ETF	91.63	91.76	91.47	91.65	2014477.0
2013-04-08 12:00:00	IWM	ETF	91.65	91.75	91.55	91.65	1059050.0
2013-04-08 13:00:00	IWM	ETF	91.66	92.03	91.65	92.02	2515707.0
2013-04-08 14:00:00	IWM	ETF	92.0199	92.16	91.99	92.0772	2052468.0
2013-04-08 15:00:00	IWM	ETF	92.07	92.52	92.05	92.48	6491160.0
2013-04-08 16:00:00	IWM	ETF	92.48	92.75	92.48	92.75	1267145.0
2013-04-08 17:00:00	IWM	ETF	92.77	92.77	92.69	92.74	29805.0
2013-04-08 18:00:00	IWM	ETF	92.7	92.7	92.7	92.7	500.0
2013-04-08 19:00:00	IWM	ETF	92.66	92.66	92.62	92.62	2995.0
2013-04-08 04:00:00	DIA	ETF	145.55	145.55	145.55	145.55	100.0
2013-04-08 08:00:00	DIA	ETF	145.61	145.61	145.45	145.45	35435.0

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

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