PREVIEW / etf_30min / 2012-07-23

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-23.parquet
  size:    295 KB
  rows:    9,939

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-23 04:00:00	SPY	ETF	135.48	136.25	135.26	135.26	17316.0
2012-07-23 04:30:00	SPY	ETF	135.33	135.33	135.3	135.3	41300.0
2012-07-23 05:00:00	SPY	ETF	135.31	135.31	134.9	135.03	16685.0
2012-07-23 05:30:00	SPY	ETF	135.01	135.05	134.9	134.92	11756.0
2012-07-23 06:00:00	SPY	ETF	134.94	135.12	134.75	135.01	32513.0
2012-07-23 06:30:00	SPY	ETF	135.01	135.15	135.0	135.05	34945.0
2012-07-23 07:00:00	SPY	ETF	135.06	135.14	134.85	134.9	205720.0
2012-07-23 07:30:00	SPY	ETF	134.9	135.14	134.89	134.95	154172.0
2012-07-23 08:00:00	SPY	ETF	134.95	135.78	134.7	134.8	1726012.0
2012-07-23 08:30:00	SPY	ETF	134.78	134.88	134.37	134.58	2001515.0
2012-07-23 09:00:00	SPY	ETF	134.58	134.67	134.41	134.48	2945461.0
2012-07-23 09:30:00	SPY	ETF	134.47	134.5	133.84	134.09	20815087.0
2012-07-23 10:00:00	SPY	ETF	134.09	134.33	133.87	134.09	10464021.0
2012-07-23 10:30:00	SPY	ETF	134.098	134.54	134.02	134.419	10444887.0
2012-07-23 11:00:00	SPY	ETF	134.41	134.68	134.39	134.62	8650587.0
2012-07-23 11:30:00	SPY	ETF	134.62	134.71	134.31	134.59	6905502.0
2012-07-23 12:00:00	SPY	ETF	134.5938	134.64	134.35	134.48	4454571.0
2012-07-23 12:30:00	SPY	ETF	134.47	134.89	134.34	134.8	5480710.0
2012-07-23 13:00:00	SPY	ETF	134.81	134.87	134.69	134.82	6503753.0
2012-07-23 13:30:00	SPY	ETF	134.82	134.97	134.81	134.92	4223051.0
2012-07-23 14:00:00	SPY	ETF	134.92	135.11	134.85	134.9	6234802.0
2012-07-23 14:30:00	SPY	ETF	134.905	136.3852	134.825	134.88	6180149.0
2012-07-23 15:00:00	SPY	ETF	134.87	135.42	134.72	135.4	9592587.0
2012-07-23 15:30:00	SPY	ETF	135.409	135.46	135.12	135.13	18447185.0
2012-07-23 16:00:00	SPY	ETF	135.14	135.1772	134.24	135.02	10544315.0
2012-07-23 16:30:00	SPY	ETF	135.01	135.15	134.6	134.68	3659345.0
2012-07-23 17:00:00	SPY	ETF	134.67	134.76	134.48	134.5	195565.0
2012-07-23 17:30:00	SPY	ETF	134.51	134.64	134.5	134.5	101379.0
2012-07-23 18:00:00	SPY	ETF	134.5	134.56	134.32	134.54	249724.0
2012-07-23 18:30:00	SPY	ETF	134.53	134.64	134.51	134.64	39211.0
2012-07-23 19:00:00	SPY	ETF	134.61	134.66	134.57	134.64	49383.0
2012-07-23 19:30:00	SPY	ETF	134.66	134.71	134.66	134.69	45054.0
2012-07-23 04:00:00	QQQ	ETF	63.8	63.8	63.66	63.66	980.0
2012-07-23 04:30:00	QQQ	ETF	63.62	63.63	63.62	63.63	400.0
2012-07-23 05:00:00	QQQ	ETF	63.6	63.6	63.6	63.6	166.0
2012-07-23 05:30:00	QQQ	ETF	63.5	63.52	63.45	63.45	2450.0
2012-07-23 06:00:00	QQQ	ETF	63.39	63.39	63.39	63.39	100.0
2012-07-23 06:30:00	QQQ	ETF	63.45	63.49	63.45	63.49	2350.0
2012-07-23 07:00:00	QQQ	ETF	63.5	63.51	63.36	63.38	42447.0
2012-07-23 07:30:00	QQQ	ETF	63.45	63.51	63.4	63.42	17825.0
2012-07-23 08:00:00	QQQ	ETF	63.43	63.44	63.21	63.3	158387.0
2012-07-23 08:30:00	QQQ	ETF	63.32	63.34	63.13	63.17	283018.0
2012-07-23 09:00:00	QQQ	ETF	63.16	63.22	62.95	63.01	310809.0
2012-07-23 09:30:00	QQQ	ETF	63.0	63.02	62.51	62.72	7762043.0
2012-07-23 10:00:00	QQQ	ETF	62.71	62.8	62.63	62.76	3258544.0
2012-07-23 10:30:00	QQQ	ETF	62.76	63.03	62.71	62.91	3346904.0
2012-07-23 11:00:00	QQQ	ETF	62.905	63.07	62.9	63.06	1871066.0
2012-07-23 11:30:00	QQQ	ETF	63.06	63.1	62.85	63.045	1826294.0
2012-07-23 12:00:00	QQQ	ETF	63.05	63.08	62.97	63.03	1911132.0
2012-07-23 12:30:00	QQQ	ETF	63.03	63.28	62.95	63.22	1830753.0

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

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