PREVIEW / etf_30min / 2013-04-18

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-18.parquet
  size:    317 KB
  rows:    10,600

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-18 04:00:00	SPY	ETF	155.13	155.25	155.13	155.16	9886.0
2013-04-18 04:30:00	SPY	ETF	155.31	155.41	155.24	155.41	8500.0
2013-04-18 05:00:00	SPY	ETF	155.35	155.54	155.35	155.54	1800.0
2013-04-18 05:30:00	SPY	ETF	155.54	155.73	155.54	155.62	54943.0
2013-04-18 06:00:00	SPY	ETF	155.61	155.62	155.49	155.55	7600.0
2013-04-18 06:30:00	SPY	ETF	155.5	155.66	155.44	155.56	64000.0
2013-04-18 07:00:00	SPY	ETF	155.51	155.77	155.51	155.71	113078.0
2013-04-18 07:30:00	SPY	ETF	155.72	155.8	155.55	155.59	238761.0
2013-04-18 08:00:00	SPY	ETF	155.59	155.75	155.0	155.56	650939.0
2013-04-18 08:30:00	SPY	ETF	155.56	155.7	155.48	155.5	386553.0
2013-04-18 09:00:00	SPY	ETF	155.51	155.53	155.29	155.37	834688.0
2013-04-18 09:30:00	SPY	ETF	155.37	155.41	154.5	154.65	18463436.0
2013-04-18 10:00:00	SPY	ETF	154.64	154.65	154.05	154.4999	20378336.0
2013-04-18 10:30:00	SPY	ETF	154.5	155.19	154.488	155.02	15875282.0
2013-04-18 11:00:00	SPY	ETF	155.02	155.055	154.6	154.62	9805982.0
2013-04-18 11:30:00	SPY	ETF	154.62	154.79	154.2	154.4801	8772815.0
2013-04-18 12:00:00	SPY	ETF	154.49	155.1562	154.25	154.42	6143420.0
2013-04-18 12:30:00	SPY	ETF	154.415	154.71	154.3	154.64	6833841.0
2013-04-18 13:00:00	SPY	ETF	154.65	154.86	154.53	154.675	5201212.0
2013-04-18 13:30:00	SPY	ETF	154.68	154.68	154.31	154.46	4048232.0
2013-04-18 14:00:00	SPY	ETF	154.465	154.47	153.87	154.1645	10676505.0
2013-04-18 14:30:00	SPY	ETF	154.17	154.22	153.55	153.75	13143064.0
2013-04-18 15:00:00	SPY	ETF	153.74	154.16	153.72	154.081	12292655.0
2013-04-18 15:30:00	SPY	ETF	154.09	155.1562	154.05	154.17	18177825.0
2013-04-18 16:00:00	SPY	ETF	154.18	154.3497	153.81	153.92	8941959.0
2013-04-18 16:30:00	SPY	ETF	153.94	154.25	153.81	154.22	4447551.0
2013-04-18 17:00:00	SPY	ETF	154.23	154.28	154.16	154.2	88016.0
2013-04-18 17:30:00	SPY	ETF	154.18	154.24	154.09	154.15	126750.0
2013-04-18 18:00:00	SPY	ETF	154.15	154.31	154.01	154.31	74389.0
2013-04-18 18:30:00	SPY	ETF	154.28	154.28	154.15	154.23	31620.0
2013-04-18 19:00:00	SPY	ETF	154.27	154.28	154.23	154.27	33810.0
2013-04-18 19:30:00	SPY	ETF	154.29	154.34	154.27	154.32	27523.0
2013-04-18 04:30:00	QQQ	ETF	68.21	68.24	68.2	68.21	4100.0
2013-04-18 06:30:00	QQQ	ETF	68.3	68.36	68.3	68.36	1900.0
2013-04-18 07:00:00	QQQ	ETF	68.31	68.43	68.3	68.39	37000.0
2013-04-18 07:30:00	QQQ	ETF	68.4	68.42	68.36	68.36	4900.0
2013-04-18 08:00:00	QQQ	ETF	68.38	68.42	68.33	68.36	83292.0
2013-04-18 08:30:00	QQQ	ETF	68.41	68.42	68.33	68.34	79779.0
2013-04-18 09:00:00	QQQ	ETF	68.33	68.35	68.28	68.33	198127.0
2013-04-18 09:30:00	QQQ	ETF	68.33	68.33	67.71	67.75	5968004.0
2013-04-18 10:00:00	QQQ	ETF	67.73	67.75	67.3	67.5808	8355529.0
2013-04-18 10:30:00	QQQ	ETF	67.58	67.95	67.57	67.84	4276928.0
2013-04-18 11:00:00	QQQ	ETF	67.85	67.85	67.55	67.55	2424046.0
2013-04-18 11:30:00	QQQ	ETF	67.55	67.61	67.24	67.46	4273624.0
2013-04-18 12:00:00	QQQ	ETF	67.46	67.49	67.33	67.42	1134086.0
2013-04-18 12:30:00	QQQ	ETF	67.415	67.5011	67.35	67.45	1319772.0
2013-04-18 13:00:00	QQQ	ETF	67.45	67.54	67.38	67.44	2118312.0
2013-04-18 13:30:00	QQQ	ETF	67.435	67.44	67.27	67.35	1698533.0
2013-04-18 14:00:00	QQQ	ETF	67.35	67.35	66.98	67.12	4527570.0
2013-04-18 14:30:00	QQQ	ETF	67.13	67.19	66.88	66.975	2695529.0

> showing 50 of 10,600 rows — these rows as CSV

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