PREVIEW / etf_30min / 2012-04-03

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-03.parquet
  size:    282 KB
  rows:    9,395

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-04-03 04:00:00	SPY	ETF	141.72	141.72	141.56	141.56	340.0
2012-04-03 04:30:00	SPY	ETF	141.61	141.61	141.47	141.47	600.0
2012-04-03 05:00:00	SPY	ETF	141.44	141.62	141.44	141.62	11850.0
2012-04-03 05:30:00	SPY	ETF	141.5	141.5	141.41	141.41	10300.0
2012-04-03 06:00:00	SPY	ETF	141.42	141.42	141.41	141.41	200.0
2012-04-03 06:30:00	SPY	ETF	141.48	141.49	141.39	141.45	28645.0
2012-04-03 07:00:00	SPY	ETF	141.49	141.56	141.27	141.32	118118.0
2012-04-03 07:30:00	SPY	ETF	141.25	141.41	141.25	141.33	219768.0
2012-04-03 08:00:00	SPY	ETF	141.33	141.51	141.32	141.48	690912.0
2012-04-03 08:30:00	SPY	ETF	141.47	141.5	141.29	141.49	408757.0
2012-04-03 09:00:00	SPY	ETF	141.48	141.71	141.45	141.64	2287319.0
2012-04-03 09:30:00	SPY	ETF	141.64	141.78	141.45	141.63	12184678.0
2012-04-03 10:00:00	SPY	ETF	141.62	141.83	141.36	141.6301	11826679.0
2012-04-03 10:30:00	SPY	ETF	141.64	141.88	141.63	141.76	8164867.0
2012-04-03 11:00:00	SPY	ETF	141.76	141.77	141.4	141.42	6424347.0
2012-04-03 11:30:00	SPY	ETF	141.43	141.44	141.22	141.35	7663277.0
2012-04-03 12:00:00	SPY	ETF	141.35	141.8826	141.01	141.22	8961352.0
2012-04-03 12:30:00	SPY	ETF	141.22	141.3	141.1	141.289	4208167.0
2012-04-03 13:00:00	SPY	ETF	141.29	141.3	141.16	141.2009	3403569.0
2012-04-03 13:30:00	SPY	ETF	141.21	141.42	141.15	141.37	3942367.0
2012-04-03 14:00:00	SPY	ETF	141.36	141.37	140.55	140.76	24911400.0
2012-04-03 14:30:00	SPY	ETF	140.76	140.81	140.43	140.72	14146111.0
2012-04-03 15:00:00	SPY	ETF	140.72	141.12	140.67	140.788	13923217.0
2012-04-03 15:30:00	SPY	ETF	140.78	141.32	140.75	141.28	16735835.0
2012-04-03 16:00:00	SPY	ETF	141.29	141.8826	141.2208	141.33	13348540.0
2012-04-03 16:30:00	SPY	ETF	141.34	141.39	141.26	141.27	1600823.0
2012-04-03 17:00:00	SPY	ETF	141.27	141.3	141.25	141.27	32667.0
2012-04-03 17:30:00	SPY	ETF	141.27	141.27	141.24	141.26	22745.0
2012-04-03 18:00:00	SPY	ETF	141.26	141.29	141.22	141.24	31305.0
2012-04-03 18:30:00	SPY	ETF	141.24	141.24	141.16	141.16	19485.0
2012-04-03 19:00:00	SPY	ETF	141.18	141.19	141.16	141.16	6908.0
2012-04-03 19:30:00	SPY	ETF	141.18	141.22	141.16	141.17	31527.0
2012-04-03 04:00:00	QQQ	ETF	68.18	68.18	68.18	68.18	200.0
2012-04-03 05:30:00	QQQ	ETF	68.15	68.15	68.15	68.15	100.0
2012-04-03 06:30:00	QQQ	ETF	68.15	68.15	68.14	68.14	7000.0
2012-04-03 07:00:00	QQQ	ETF	68.13	68.18	68.1	68.1	26500.0
2012-04-03 07:30:00	QQQ	ETF	68.07	68.16	68.07	68.11	79300.0
2012-04-03 08:00:00	QQQ	ETF	68.12	68.21	68.12	68.21	131390.0
2012-04-03 08:30:00	QQQ	ETF	68.21	68.25	68.16	68.25	389313.0
2012-04-03 09:00:00	QQQ	ETF	68.25	68.35	68.24	68.33	2039096.0
2012-04-03 09:30:00	QQQ	ETF	68.32	68.46	68.26	68.42	6308772.0
2012-04-03 10:00:00	QQQ	ETF	68.412	68.51	68.28	68.43	3813947.0
2012-04-03 10:30:00	QQQ	ETF	68.435	68.55	68.41	68.53	2823169.0
2012-04-03 11:00:00	QQQ	ETF	68.54	68.55	68.335	68.34	2622741.0
2012-04-03 11:30:00	QQQ	ETF	68.34	68.35	68.2	68.229	2675283.0
2012-04-03 12:00:00	QQQ	ETF	68.23	68.25	67.98	68.18	2495580.0
2012-04-03 12:30:00	QQQ	ETF	68.18	68.23	68.1037	68.21	1712088.0
2012-04-03 13:00:00	QQQ	ETF	68.21	68.24	68.13	68.1706	2721450.0
2012-04-03 13:30:00	QQQ	ETF	68.18	68.29	68.15	68.27	806629.0
2012-04-03 14:00:00	QQQ	ETF	68.27	68.27	67.93	68.04	4802174.0

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

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