PREVIEW / etf_30min / 2012-07-10

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-10.parquet
  size:    283 KB
  rows:    9,363

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-07-10 04:00:00	SPY	ETF	135.05	135.07	135.0	135.07	1100.0
2012-07-10 04:30:00	SPY	ETF	135.12	135.81	135.12	135.81	4137.0
2012-07-10 05:00:00	SPY	ETF	135.82	135.87	135.82	135.82	700.0
2012-07-10 05:30:00	SPY	ETF	135.88	136.05	135.88	135.9	53804.0
2012-07-10 06:00:00	SPY	ETF	135.9	136.04	135.9	136.03	14300.0
2012-07-10 06:30:00	SPY	ETF	136.03	136.11	136.01	136.01	46700.0
2012-07-10 07:00:00	SPY	ETF	136.01	136.04	135.87	135.87	63413.0
2012-07-10 07:30:00	SPY	ETF	135.87	135.98	135.82	135.92	177566.0
2012-07-10 08:00:00	SPY	ETF	135.92	135.94	135.43	135.56	418285.0
2012-07-10 08:30:00	SPY	ETF	135.56	135.95	135.52	135.93	1317642.0
2012-07-10 09:00:00	SPY	ETF	135.94	136.06	135.685	136.02	2339449.0
2012-07-10 09:30:00	SPY	ETF	136.01	136.23	135.86	135.8809	13505165.0
2012-07-10 10:00:00	SPY	ETF	135.88	136.0225	135.32	135.5395	12099218.0
2012-07-10 10:30:00	SPY	ETF	135.5301	135.61	135.01	135.17	9440556.0
2012-07-10 11:00:00	SPY	ETF	135.18	135.18	134.83	135.07	11632143.0
2012-07-10 11:30:00	SPY	ETF	135.07	135.21	135.01	135.17	5999150.0
2012-07-10 12:00:00	SPY	ETF	135.17	135.23	134.98	135.02	5060645.0
2012-07-10 12:30:00	SPY	ETF	135.021	135.24	135.0	135.08	3137599.0
2012-07-10 13:00:00	SPY	ETF	135.07	135.19	134.87	134.92	4703703.0
2012-07-10 13:30:00	SPY	ETF	134.93	134.93	134.57	134.68	8383207.0
2012-07-10 14:00:00	SPY	ETF	134.6705	135.3091	134.12	134.2	11218749.0
2012-07-10 14:30:00	SPY	ETF	134.21	134.26	133.92	133.97	10913380.0
2012-07-10 15:00:00	SPY	ETF	133.97	134.285	133.79	133.8	16605201.0
2012-07-10 15:30:00	SPY	ETF	133.8006	134.35	133.68	134.16	24282270.0
2012-07-10 16:00:00	SPY	ETF	134.17	135.3091	134.04	134.12	10705190.0
2012-07-10 16:30:00	SPY	ETF	134.1	134.25	134.1	134.23	2864624.0
2012-07-10 17:00:00	SPY	ETF	134.22	134.22	134.14	134.14	2097190.0
2012-07-10 17:30:00	SPY	ETF	134.13	134.16	134.1	134.16	57327.0
2012-07-10 18:00:00	SPY	ETF	134.13	134.16	134.09	134.1	4530536.0
2012-07-10 18:30:00	SPY	ETF	134.1	134.13	134.08	134.13	16277.0
2012-07-10 19:00:00	SPY	ETF	134.12	134.14	134.08	134.12	8820.0
2012-07-10 19:30:00	SPY	ETF	134.12	134.15	134.09	134.14	79811.0
2012-07-10 04:30:00	QQQ	ETF	64.05	64.18	64.05	64.18	4800.0
2012-07-10 05:30:00	QQQ	ETF	64.27	64.3	64.27	64.3	600.0
2012-07-10 06:00:00	QQQ	ETF	64.26	64.26	64.26	64.26	5000.0
2012-07-10 06:30:00	QQQ	ETF	64.3	64.31	64.3	64.3	1600.0
2012-07-10 07:00:00	QQQ	ETF	64.3	64.3	64.25	64.25	8500.0
2012-07-10 07:30:00	QQQ	ETF	64.26	64.26	64.25	64.25	1508.0
2012-07-10 08:00:00	QQQ	ETF	64.26	64.26	64.07	64.13	120370.0
2012-07-10 08:30:00	QQQ	ETF	64.13	64.35	64.12	64.35	1605664.0
2012-07-10 09:00:00	QQQ	ETF	64.34	64.36	64.25	64.33	610693.0
2012-07-10 09:30:00	QQQ	ETF	64.33	64.51	64.28	64.35	4499761.0
2012-07-10 10:00:00	QQQ	ETF	64.36	64.43	63.92	64.04	4913642.0
2012-07-10 10:30:00	QQQ	ETF	64.0399	64.06	63.72	63.81	2688077.0
2012-07-10 11:00:00	QQQ	ETF	63.8	63.8	63.51	63.7	4979854.0
2012-07-10 11:30:00	QQQ	ETF	63.7	63.78	63.68	63.7552	1456893.0
2012-07-10 12:00:00	QQQ	ETF	63.7595	63.85	63.67	63.72	1556621.0
2012-07-10 12:30:00	QQQ	ETF	63.72	63.82	63.71	63.76	893004.0
2012-07-10 13:00:00	QQQ	ETF	63.77	63.829	63.64	63.67	1774903.0
2012-07-10 13:30:00	QQQ	ETF	63.67	63.72	63.59	63.64	3551991.0

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

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