PREVIEW / etf_30min / 2012-12-11

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-11.parquet
  size:    291 KB
  rows:    10,053

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-12-11 04:00:00	SPY	ETF	142.54	142.68	142.53	142.68	19281.0
2012-12-11 04:30:00	SPY	ETF	142.81	142.9	142.79	142.9	25376.0
2012-12-11 05:00:00	SPY	ETF	142.88	143.07	142.88	143.07	43245.0
2012-12-11 05:30:00	SPY	ETF	143.03	143.03	142.94	142.94	56664.0
2012-12-11 06:00:00	SPY	ETF	142.95	143.0	142.94	142.96	95825.0
2012-12-11 06:30:00	SPY	ETF	142.94	143.05	142.92	143.05	102300.0
2012-12-11 07:00:00	SPY	ETF	143.05	143.14	142.95	143.09	144634.0
2012-12-11 07:30:00	SPY	ETF	143.05	143.17	142.98	143.09	104784.0
2012-12-11 08:00:00	SPY	ETF	143.08	143.14	142.86	143.12	359179.0
2012-12-11 08:30:00	SPY	ETF	143.13	143.14	142.99	143.06	254079.0
2012-12-11 09:00:00	SPY	ETF	143.07	143.12	143.02	143.07	778919.0
2012-12-11 09:30:00	SPY	ETF	143.06	143.461	142.99	143.46	13734844.0
2012-12-11 10:00:00	SPY	ETF	143.45	143.69	143.45	143.635	13705125.0
2012-12-11 10:30:00	SPY	ETF	143.635	143.81	143.6	143.65	10273422.0
2012-12-11 11:00:00	SPY	ETF	143.66	144.11	143.61	143.915	10574414.0
2012-12-11 11:30:00	SPY	ETF	143.915	143.95	143.75	143.79	5664178.0
2012-12-11 12:00:00	SPY	ETF	143.8	143.96	143.515	143.86	12599346.0
2012-12-11 12:30:00	SPY	ETF	143.85	143.9	143.75	143.805	3061139.0
2012-12-11 13:00:00	SPY	ETF	143.79	143.85	143.68	143.77	2725346.0
2012-12-11 13:30:00	SPY	ETF	143.77	143.81	143.73	143.749	3170327.0
2012-12-11 14:00:00	SPY	ETF	143.75	143.82	143.71	143.73	3482288.0
2012-12-11 14:30:00	SPY	ETF	143.72	143.74	143.35	143.42	9549785.0
2012-12-11 15:00:00	SPY	ETF	143.41	143.42	143.03	143.32	17956121.0
2012-12-11 15:30:00	SPY	ETF	143.31	143.5	143.27	143.43	14762271.0
2012-12-11 16:00:00	SPY	ETF	143.42	143.85	142.4789	143.82	8913024.0
2012-12-11 16:30:00	SPY	ETF	143.82	143.93	142.4789	143.89	13201215.0
2012-12-11 17:00:00	SPY	ETF	143.88	143.9	143.7306	143.8	5401430.0
2012-12-11 17:30:00	SPY	ETF	143.8	143.82	143.78	143.81	255653.0
2012-12-11 18:00:00	SPY	ETF	143.82	143.82	143.72	143.8	68188.0
2012-12-11 18:30:00	SPY	ETF	143.75	143.79	143.75	143.77	18831.0
2012-12-11 19:00:00	SPY	ETF	143.77	143.77	143.67	143.67	67216.0
2012-12-11 19:30:00	SPY	ETF	143.68	143.82	143.66	143.72	72236.0
2012-12-11 05:00:00	QQQ	ETF	65.37	65.37	65.37	65.37	2400.0
2012-12-11 06:00:00	QQQ	ETF	65.34	65.34	65.34	65.34	900.0
2012-12-11 06:30:00	QQQ	ETF	65.34	65.37	65.34	65.37	1400.0
2012-12-11 07:00:00	QQQ	ETF	65.33	65.42	65.33	65.37	26166.0
2012-12-11 07:30:00	QQQ	ETF	65.34	65.42	65.34	65.42	2160.0
2012-12-11 08:00:00	QQQ	ETF	65.4	65.48	65.4	65.47	36430.0
2012-12-11 08:30:00	QQQ	ETF	65.47	65.52	65.45	65.45	36280.0
2012-12-11 09:00:00	QQQ	ETF	65.48	65.6	65.46	65.59	287610.0
2012-12-11 09:30:00	QQQ	ETF	65.58	65.94	65.515	65.92	5111430.0
2012-12-11 10:00:00	QQQ	ETF	65.93	66.08	65.86	66.07	4435278.0
2012-12-11 10:30:00	QQQ	ETF	66.07	66.19	66.06	66.11	2177255.0
2012-12-11 11:00:00	QQQ	ETF	66.11	66.34	66.1	66.26	3368609.0
2012-12-11 11:30:00	QQQ	ETF	66.26	66.28	66.12	66.14	2031850.0
2012-12-11 12:00:00	QQQ	ETF	66.14	66.25	66.01	66.2	2109287.0
2012-12-11 12:30:00	QQQ	ETF	66.2	66.23	66.16	66.181	881874.0
2012-12-11 13:00:00	QQQ	ETF	66.185	66.21	66.1	66.1501	709249.0
2012-12-11 13:30:00	QQQ	ETF	66.16	66.2	66.15	66.191	701838.0
2012-12-11 14:00:00	QQQ	ETF	66.192	66.255	66.165	66.1999	1057498.0

> showing 50 of 10,053 rows — these rows as CSV

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