PREVIEW / etf_30min / 2012-05-30

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-30.parquet
  size:    283 KB
  rows:    9,660

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
2012-05-30 04:00:00	SPY	ETF	133.0	133.18	132.99	133.17	2282.0
2012-05-30 04:30:00	SPY	ETF	133.09	133.09	132.88	132.99	2400.0
2012-05-30 05:00:00	SPY	ETF	132.85	132.94	132.67	132.72	38761.0
2012-05-30 05:30:00	SPY	ETF	132.94	132.95	132.79	132.95	9617.0
2012-05-30 06:00:00	SPY	ETF	132.86	132.93	132.63	132.93	68150.0
2012-05-30 06:30:00	SPY	ETF	132.91	132.91	132.5	132.57	124499.0
2012-05-30 07:00:00	SPY	ETF	132.57	133.68	132.57	132.9	1333552.0
2012-05-30 07:30:00	SPY	ETF	132.9	133.45	132.87	132.98	757804.0
2012-05-30 08:00:00	SPY	ETF	133.0	133.37	132.69	132.88	1062164.0
2012-05-30 08:30:00	SPY	ETF	132.88	133.0	132.6	132.8	942622.0
2012-05-30 09:00:00	SPY	ETF	132.8	133.25	132.53	132.56	1545548.0
2012-05-30 09:30:00	SPY	ETF	132.56	132.62	132.02	132.17	22070393.0
2012-05-30 10:00:00	SPY	ETF	132.1759	132.3	131.87	132.16	15188083.0
2012-05-30 10:30:00	SPY	ETF	132.16	132.25	131.81	131.839	10009296.0
2012-05-30 11:00:00	SPY	ETF	131.83	132.25	131.76	132.09	10124234.0
2012-05-30 11:30:00	SPY	ETF	132.09	132.15	131.88	131.96	8072923.0
2012-05-30 12:00:00	SPY	ETF	131.96	132.03	131.55	131.63	8057647.0
2012-05-30 12:30:00	SPY	ETF	131.62	131.93	131.6	131.86	6707281.0
2012-05-30 13:00:00	SPY	ETF	131.86	131.89	131.64	131.86	4589165.0
2012-05-30 13:30:00	SPY	ETF	131.85	132.165	131.83	132.12	7322707.0
2012-05-30 14:00:00	SPY	ETF	132.13	132.29	131.92	132.01	6396390.0
2012-05-30 14:30:00	SPY	ETF	132.02	133.6924	131.87	131.93	7352156.0
2012-05-30 15:00:00	SPY	ETF	131.92	132.09	131.49	132.03	12687662.0
2012-05-30 15:30:00	SPY	ETF	132.03	133.6924	131.74	131.79	19337867.0
2012-05-30 16:00:00	SPY	ETF	131.79	132.3222	131.38	131.46	17172045.0
2012-05-30 16:30:00	SPY	ETF	131.48	131.784	131.4	131.4	579415.0
2012-05-30 17:00:00	SPY	ETF	131.41	131.43	131.31	131.35	207562.0
2012-05-30 17:30:00	SPY	ETF	131.39	131.39	131.33	131.37	20960.0
2012-05-30 18:00:00	SPY	ETF	131.35	131.45	131.27	131.45	74446.0
2012-05-30 18:30:00	SPY	ETF	131.43	131.46	131.38	131.41	34467.0
2012-05-30 19:00:00	SPY	ETF	131.41	131.47	131.38	131.4	14000.0
2012-05-30 19:30:00	SPY	ETF	131.39	131.48	131.39	131.46	93182.0
2012-05-30 05:00:00	QQQ	ETF	62.36	62.36	62.27	62.29	1447.0
2012-05-30 06:00:00	QQQ	ETF	62.39	62.39	62.25	62.36	4200.0
2012-05-30 06:30:00	QQQ	ETF	62.35	62.35	62.21	62.21	10400.0
2012-05-30 07:00:00	QQQ	ETF	62.4	62.62	62.32	62.4	40189.0
2012-05-30 07:30:00	QQQ	ETF	62.41	62.65	62.39	62.46	30785.0
2012-05-30 08:00:00	QQQ	ETF	62.46	62.47	62.34	62.39	137240.0
2012-05-30 08:30:00	QQQ	ETF	62.38	62.4	62.32	62.37	59315.0
2012-05-30 09:00:00	QQQ	ETF	62.39	62.39	62.28	62.29	317391.0
2012-05-30 09:30:00	QQQ	ETF	62.29	62.35	61.94	62.1	8027520.0
2012-05-30 10:00:00	QQQ	ETF	62.12	62.27	62.02	62.19	4795532.0
2012-05-30 10:30:00	QQQ	ETF	62.19	62.23	61.97	62.0	4519002.0
2012-05-30 11:00:00	QQQ	ETF	62.0	62.2801	61.97	62.2201	2804364.0
2012-05-30 11:30:00	QQQ	ETF	62.22	62.28	62.12	62.2	2661985.0
2012-05-30 12:00:00	QQQ	ETF	62.2	62.23	61.96	62.0195	1957472.0
2012-05-30 12:30:00	QQQ	ETF	62.01	62.24	62.0	62.21	1924717.0
2012-05-30 13:00:00	QQQ	ETF	62.21	62.23	62.06	62.17	1115297.0
2012-05-30 13:30:00	QQQ	ETF	62.17	62.46	62.1537	62.44	4142606.0
2012-05-30 14:00:00	QQQ	ETF	62.4441	62.55	62.35	62.4	3417290.0

> showing 50 of 9,660 rows — these rows as CSV

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