PREVIEW / etf_30min / 2012-04-02

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-02.parquet
  size:    293 KB
  rows:    9,729

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-02 04:00:00	SPY	ETF	141.12	141.27	141.12	141.17	11487.0
2012-04-02 04:30:00	SPY	ETF	141.06	141.06	140.54	140.62	30750.0
2012-04-02 05:00:00	SPY	ETF	140.69	140.78	140.64	140.76	17600.0
2012-04-02 05:30:00	SPY	ETF	140.73	140.94	140.72	140.94	15580.0
2012-04-02 06:00:00	SPY	ETF	140.92	140.92	140.84	140.84	7700.0
2012-04-02 06:30:00	SPY	ETF	140.81	140.87	140.68	140.68	29400.0
2012-04-02 07:00:00	SPY	ETF	140.66	140.84	140.66	140.71	105805.0
2012-04-02 07:30:00	SPY	ETF	140.71	140.78	140.55	140.65	273482.0
2012-04-02 08:00:00	SPY	ETF	140.67	140.81	140.5	140.7	995221.0
2012-04-02 08:30:00	SPY	ETF	140.69	140.85	140.67	140.78	645762.0
2012-04-02 09:00:00	SPY	ETF	140.78	141.39	140.6	140.65	722875.0
2012-04-02 09:30:00	SPY	ETF	140.64	140.82	140.36	140.63	15058333.0
2012-04-02 10:00:00	SPY	ETF	140.62	141.3	140.61	141.11	17528739.0
2012-04-02 10:30:00	SPY	ETF	141.11	141.25	140.96	141.23	7043305.0
2012-04-02 11:00:00	SPY	ETF	141.23	141.59	141.12	141.55	12097141.0
2012-04-02 11:30:00	SPY	ETF	141.55	141.9	141.54	141.85	9539464.0
2012-04-02 12:00:00	SPY	ETF	141.85	142.07	141.85	141.95	8627489.0
2012-04-02 12:30:00	SPY	ETF	141.95	142.12	141.92	142.03	5944275.0
2012-04-02 13:00:00	SPY	ETF	142.035	142.08	141.97	142.001	5164106.0
2012-04-02 13:30:00	SPY	ETF	142.005	142.09	141.99	142.08	4120573.0
2012-04-02 14:00:00	SPY	ETF	142.075	142.09	141.94	142.02	4774832.0
2012-04-02 14:30:00	SPY	ETF	142.02	142.18	142.01	142.18	7706607.0
2012-04-02 15:00:00	SPY	ETF	142.18	142.21	142.02	142.03	6286813.0
2012-04-02 15:30:00	SPY	ETF	142.03	142.045	141.68	141.8	21341894.0
2012-04-02 16:00:00	SPY	ETF	141.79	141.84	140.38	141.68	7772188.0
2012-04-02 16:30:00	SPY	ETF	141.67	141.67	140.7931	140.7931	10337249.0
2012-04-02 17:00:00	SPY	ETF	141.58	141.63	141.57	141.58	86638.0
2012-04-02 17:30:00	SPY	ETF	141.62	141.62	141.56	141.57	27550.0
2012-04-02 18:00:00	SPY	ETF	141.57	141.65	141.57	141.63	47029.0
2012-04-02 18:30:00	SPY	ETF	141.64	141.7	141.63	141.63	18188.0
2012-04-02 19:00:00	SPY	ETF	141.62	141.68	141.62	141.67	26072.0
2012-04-02 19:30:00	SPY	ETF	141.67	141.68	141.64	141.67	51241.0
2012-04-02 04:30:00	QQQ	ETF	67.56	67.56	67.56	67.56	3000.0
2012-04-02 05:00:00	QQQ	ETF	67.53	67.53	67.53	67.53	4000.0
2012-04-02 06:30:00	QQQ	ETF	67.54	67.54	67.53	67.53	600.0
2012-04-02 07:00:00	QQQ	ETF	67.53	67.56	67.53	67.53	40100.0
2012-04-02 07:30:00	QQQ	ETF	67.52	67.52	67.4	67.45	91240.0
2012-04-02 08:00:00	QQQ	ETF	67.6	67.88	67.38	67.48	576854.0
2012-04-02 08:30:00	QQQ	ETF	67.46	67.57	67.46	67.54	567379.0
2012-04-02 09:00:00	QQQ	ETF	67.51	67.55	67.46	67.47	137001.0
2012-04-02 09:30:00	QQQ	ETF	67.46	67.62	67.36	67.4595	4495279.0
2012-04-02 10:00:00	QQQ	ETF	67.45	67.86	67.42	67.781	4914401.0
2012-04-02 10:30:00	QQQ	ETF	67.781	67.86	67.6858	67.8579	3355682.0
2012-04-02 11:00:00	QQQ	ETF	67.855	68.02	67.79	67.998	3492121.0
2012-04-02 11:30:00	QQQ	ETF	67.99	68.19	67.97	68.142	3131097.0
2012-04-02 12:00:00	QQQ	ETF	68.15	68.25	68.14	68.2	2288564.0
2012-04-02 12:30:00	QQQ	ETF	68.2	68.3	68.17	68.2399	1388389.0
2012-04-02 13:00:00	QQQ	ETF	68.23	68.26	68.19	68.25	1611927.0
2012-04-02 13:30:00	QQQ	ETF	68.25	68.3	68.24	68.3	1077325.0
2012-04-02 14:00:00	QQQ	ETF	68.3	68.3	68.22	68.27	1276012.0

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

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