PREVIEW / etf_30min / 2011-05-17

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-17.parquet
  size:    289 KB
  rows:    9,550

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
2011-05-17 04:00:00	SPY	ETF	133.09	133.28	133.09	133.27	2300.0
2011-05-17 04:30:00	SPY	ETF	133.32	133.5	133.29	133.31	1850.0
2011-05-17 05:00:00	SPY	ETF	133.31	133.61	133.31	133.6	25400.0
2011-05-17 05:30:00	SPY	ETF	133.59	133.59	133.41	133.44	18950.0
2011-05-17 06:00:00	SPY	ETF	133.5	133.6	133.5	133.6	900.0
2011-05-17 06:30:00	SPY	ETF	133.53	133.67	133.46	133.46	26718.0
2011-05-17 07:00:00	SPY	ETF	133.5	133.5	133.32	133.35	135740.0
2011-05-17 07:30:00	SPY	ETF	133.33	133.36	133.15	133.2	409125.0
2011-05-17 08:00:00	SPY	ETF	133.16	133.37	133.04	133.2	516540.0
2011-05-17 08:30:00	SPY	ETF	133.16	133.16	132.63	132.75	1795399.0
2011-05-17 09:00:00	SPY	ETF	132.75	132.88	132.45	132.69	2189331.0
2011-05-17 09:30:00	SPY	ETF	132.69	133.1	132.48	133.03	18730261.0
2011-05-17 10:00:00	SPY	ETF	133.02	133.35	132.65	133.3	15296151.0
2011-05-17 10:30:00	SPY	ETF	133.29	133.35	132.73	132.8	14096458.0
2011-05-17 11:00:00	SPY	ETF	132.8	132.82	132.31	132.48	19801702.0
2011-05-17 11:30:00	SPY	ETF	132.48	132.55	132.12	132.495	14491817.0
2011-05-17 12:00:00	SPY	ETF	132.491	132.74	132.39	132.63	8406130.0
2011-05-17 12:30:00	SPY	ETF	132.62	132.85	132.35	132.48	9216502.0
2011-05-17 13:00:00	SPY	ETF	132.49	132.85	132.42	132.799	7184466.0
2011-05-17 13:30:00	SPY	ETF	132.79	132.95	132.68	132.83	7628126.0
2011-05-17 14:00:00	SPY	ETF	132.83	133.07	132.6	132.71	8786936.0
2011-05-17 14:30:00	SPY	ETF	132.7	133.22	132.565	133.2001	10189012.0
2011-05-17 15:00:00	SPY	ETF	133.2	133.22	132.86	132.93	16538112.0
2011-05-17 15:30:00	SPY	ETF	132.93	133.215	132.9	133.19	21218285.0
2011-05-17 16:00:00	SPY	ETF	133.19	133.21	132.97	133.07	14785848.0
2011-05-17 16:30:00	SPY	ETF	133.09	133.19	133.03	133.19	617659.0
2011-05-17 17:00:00	SPY	ETF	133.18	133.22	133.15	133.18	200048.0
2011-05-17 17:30:00	SPY	ETF	133.16	133.2	133.15	133.15	21930.0
2011-05-17 18:00:00	SPY	ETF	133.17	133.24	133.14	133.17	61272.0
2011-05-17 18:30:00	SPY	ETF	133.17	133.26	133.17	133.2	27565.0
2011-05-17 19:00:00	SPY	ETF	133.25	133.27	133.18	133.21	21300.0
2011-05-17 19:30:00	SPY	ETF	133.2	133.26	133.19	133.25	28952.0
2011-05-17 04:00:00	QQQ	ETF	57.42	57.44	57.42	57.44	255.0
2011-05-17 05:00:00	QQQ	ETF	57.47	57.6	57.46	57.57	35700.0
2011-05-17 05:30:00	QQQ	ETF	57.55	57.55	57.55	57.55	200.0
2011-05-17 06:00:00	QQQ	ETF	57.57	57.57	57.57	57.57	700.0
2011-05-17 06:30:00	QQQ	ETF	57.54	57.54	57.52	57.52	8700.0
2011-05-17 07:00:00	QQQ	ETF	57.5	57.5	57.44	57.47	12437.0
2011-05-17 07:30:00	QQQ	ETF	57.45	57.45	57.35	57.4	18945.0
2011-05-17 08:00:00	QQQ	ETF	57.4	57.53	57.32	57.38	152159.0
2011-05-17 08:30:00	QQQ	ETF	57.34	57.36	57.18	57.18	370599.0
2011-05-17 09:00:00	QQQ	ETF	57.17	57.26	57.09	57.1	999514.0
2011-05-17 09:30:00	QQQ	ETF	57.11	57.27	57.05	57.24	6451115.0
2011-05-17 10:00:00	QQQ	ETF	57.23	57.4899	57.1101	57.44	6121383.0
2011-05-17 10:30:00	QQQ	ETF	57.44	57.4784	57.14	57.19	6117657.0
2011-05-17 11:00:00	QQQ	ETF	57.19	57.2	56.98	57.13	8257365.0
2011-05-17 11:30:00	QQQ	ETF	57.1208	57.18	57.01	57.1401	3549746.0
2011-05-17 12:00:00	QQQ	ETF	57.15	57.25	57.1	57.2184	2431338.0
2011-05-17 12:30:00	QQQ	ETF	57.21	57.38	57.12	57.17	5074814.0
2011-05-17 13:00:00	QQQ	ETF	57.17	57.375	57.15	57.335	4616832.0

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

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