PREVIEW / etf_30min / 2013-03-05

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-05.parquet
  size:    314 KB
  rows:    10,703

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-03-05 04:00:00	SPY	ETF	153.42	153.45	153.3	153.33	24837.0
2013-03-05 04:30:00	SPY	ETF	153.4	153.43	153.4	153.43	66200.0
2013-03-05 05:00:00	SPY	ETF	153.44	153.44	153.44	153.44	59950.0
2013-03-05 05:30:00	SPY	ETF	153.32	153.39	153.31	153.39	60060.0
2013-03-05 06:00:00	SPY	ETF	153.34	153.4	153.29	153.3	2300.0
2013-03-05 06:30:00	SPY	ETF	153.3	153.41	153.27	153.36	8390.0
2013-03-05 07:00:00	SPY	ETF	153.37	153.4	153.32	153.32	122575.0
2013-03-05 07:30:00	SPY	ETF	153.33	153.43	153.32	153.38	417259.0
2013-03-05 08:00:00	SPY	ETF	153.37	153.62	153.36	153.58	552955.0
2013-03-05 08:30:00	SPY	ETF	153.59	153.72	153.55	153.64	863934.0
2013-03-05 09:00:00	SPY	ETF	153.65	153.73	153.62	153.66	826371.0
2013-03-05 09:30:00	SPY	ETF	153.66	154.09	153.64	153.96	17537208.0
2013-03-05 10:00:00	SPY	ETF	153.965	154.3	153.94	154.28	14153639.0
2013-03-05 10:30:00	SPY	ETF	154.28	154.56	154.25	154.42	9981249.0
2013-03-05 11:00:00	SPY	ETF	154.42	154.6	154.27	154.42	7956290.0
2013-03-05 11:30:00	SPY	ETF	154.415	154.54	154.32	154.465	4281928.0
2013-03-05 12:00:00	SPY	ETF	154.47	154.57	154.31	154.34	4369706.0
2013-03-05 12:30:00	SPY	ETF	154.348	154.47	154.32	154.43	2957620.0
2013-03-05 13:00:00	SPY	ETF	154.43	154.5999	154.33	154.53	4642205.0
2013-03-05 13:30:00	SPY	ETF	154.53	154.7	154.34	154.3701	4998212.0
2013-03-05 14:00:00	SPY	ETF	154.37	154.47	154.23	154.25	4258451.0
2013-03-05 14:30:00	SPY	ETF	154.245	154.42	154.17	154.335	5402782.0
2013-03-05 15:00:00	SPY	ETF	154.33	154.42	154.18	154.22	7055287.0
2013-03-05 15:30:00	SPY	ETF	154.2201	154.52	154.08	154.31	17940146.0
2013-03-05 16:00:00	SPY	ETF	154.29	154.3891	152.8386	154.17	4678858.0
2013-03-05 16:30:00	SPY	ETF	154.16	154.37	152.8386	154.33	5767475.0
2013-03-05 17:00:00	SPY	ETF	154.35	154.4	154.35	154.36	198223.0
2013-03-05 17:30:00	SPY	ETF	154.37	154.4	154.36	154.39	27783.0
2013-03-05 18:00:00	SPY	ETF	154.37	154.37	154.31	154.34	47370.0
2013-03-05 18:30:00	SPY	ETF	154.3	154.36	154.29	154.33	28806.0
2013-03-05 19:00:00	SPY	ETF	154.34	154.34	154.17	154.17	173780.0
2013-03-05 19:30:00	SPY	ETF	154.24	154.31	154.18	154.28	28575.0
2013-03-05 04:00:00	QQQ	ETF	67.86	67.86	67.86	67.86	200.0
2013-03-05 05:00:00	QQQ	ETF	67.92	67.92	67.92	67.92	200.0
2013-03-05 05:30:00	QQQ	ETF	67.9	67.9	67.9	67.9	471.0
2013-03-05 06:30:00	QQQ	ETF	67.94	67.94	67.94	67.94	100.0
2013-03-05 07:00:00	QQQ	ETF	67.94	67.95	67.94	67.94	2000.0
2013-03-05 07:30:00	QQQ	ETF	67.98	68.01	67.98	68.0	82482.0
2013-03-05 08:00:00	QQQ	ETF	67.98	68.06	67.97	68.04	123360.0
2013-03-05 08:30:00	QQQ	ETF	68.03	68.09	68.03	68.06	80554.0
2013-03-05 09:00:00	QQQ	ETF	68.06	68.13	68.05	68.1	127847.0
2013-03-05 09:30:00	QQQ	ETF	68.1	68.43	68.08	68.28	5549699.0
2013-03-05 10:00:00	QQQ	ETF	68.29	68.49	68.27	68.48	3026706.0
2013-03-05 10:30:00	QQQ	ETF	68.48	68.66	68.47	68.51	3539552.0
2013-03-05 11:00:00	QQQ	ETF	68.505	68.63	68.47	68.55	2098806.0
2013-03-05 11:30:00	QQQ	ETF	68.56	68.77	68.538	68.72	1449150.0
2013-03-05 12:00:00	QQQ	ETF	68.73	68.77	68.64	68.66	777152.0
2013-03-05 12:30:00	QQQ	ETF	68.66	68.71	68.6	68.6255	639156.0
2013-03-05 13:00:00	QQQ	ETF	68.62	68.73	68.571	68.6999	1748208.0
2013-03-05 13:30:00	QQQ	ETF	68.69	68.77	68.54	68.554	1486140.0

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

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