PREVIEW / etf_30min / 2012-05-07

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-07.parquet
  size:    287 KB
  rows:    9,727

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-05-07 04:00:00	SPY	ETF	135.5	135.82	135.5	135.82	2320.0
2012-05-07 04:30:00	SPY	ETF	135.75	135.87	135.71	135.85	2932.0
2012-05-07 05:00:00	SPY	ETF	135.75	135.9	135.68	135.9	10200.0
2012-05-07 05:30:00	SPY	ETF	135.89	136.05	135.85	136.05	36176.0
2012-05-07 06:00:00	SPY	ETF	136.07	136.1	136.0	136.1	27050.0
2012-05-07 06:30:00	SPY	ETF	136.15	136.2	136.05	136.13	276350.0
2012-05-07 07:00:00	SPY	ETF	136.1	136.35	136.0	136.3	415458.0
2012-05-07 07:30:00	SPY	ETF	136.3	136.34	136.08	136.15	565790.0
2012-05-07 08:00:00	SPY	ETF	136.15	137.0467	135.38	136.32	2515662.0
2012-05-07 08:30:00	SPY	ETF	136.32	136.42	136.23	136.38	997313.0
2012-05-07 09:00:00	SPY	ETF	136.38	137.0	136.36	136.52	2894803.0
2012-05-07 09:30:00	SPY	ETF	136.51	137.18	136.46	136.93	22527424.0
2012-05-07 10:00:00	SPY	ETF	136.93	137.15	136.65	136.661	10889543.0
2012-05-07 10:30:00	SPY	ETF	136.67	136.9	136.53	136.81	9851729.0
2012-05-07 11:00:00	SPY	ETF	136.81	137.12	136.8	136.94	7098787.0
2012-05-07 11:30:00	SPY	ETF	136.95	137.05	136.87	136.97	5410884.0
2012-05-07 12:00:00	SPY	ETF	136.97	137.12	136.94	137.07	5683850.0
2012-05-07 12:30:00	SPY	ETF	137.06	137.35	137.06	137.24	6598236.0
2012-05-07 13:00:00	SPY	ETF	137.24	137.5	137.18	137.25	6181315.0
2012-05-07 13:30:00	SPY	ETF	137.255	137.56	137.23	137.46	7190552.0
2012-05-07 14:00:00	SPY	ETF	137.46	137.55	137.35	137.3872	4450140.0
2012-05-07 14:30:00	SPY	ETF	137.38	137.46	137.28	137.425	4863805.0
2012-05-07 15:00:00	SPY	ETF	137.425	137.47	137.2	137.26	6823940.0
2012-05-07 15:30:00	SPY	ETF	137.25	137.39	136.99	137.12	12002383.0
2012-05-07 16:00:00	SPY	ETF	137.1	137.14	136.96	137.08	6699626.0
2012-05-07 16:30:00	SPY	ETF	137.09	137.25	137.041	137.18	225630.0
2012-05-07 17:00:00	SPY	ETF	137.18	137.24	137.16	137.16	170493.0
2012-05-07 17:30:00	SPY	ETF	137.15	137.19	137.09	137.19	46445.0
2012-05-07 18:00:00	SPY	ETF	137.17	137.18	137.15	137.17	20090.0
2012-05-07 18:30:00	SPY	ETF	137.17	137.25	137.17	137.17	12115.0
2012-05-07 19:00:00	SPY	ETF	137.21	137.21	137.15	137.18	9021.0
2012-05-07 19:30:00	SPY	ETF	137.18	137.34	137.17	137.28	63360.0
2012-05-07 04:00:00	QQQ	ETF	64.18	64.18	64.0	64.02	1999.0
2012-05-07 04:30:00	QQQ	ETF	64.03	64.05	63.99	64.04	3253.0
2012-05-07 05:00:00	QQQ	ETF	64.0	64.06	64.0	64.06	300.0
2012-05-07 05:30:00	QQQ	ETF	64.1	64.16	64.1	64.16	3200.0
2012-05-07 06:00:00	QQQ	ETF	64.17	64.17	64.17	64.17	500.0
2012-05-07 06:30:00	QQQ	ETF	64.2	64.22	64.18	64.18	4100.0
2012-05-07 07:00:00	QQQ	ETF	64.17	64.25	64.14	64.25	73624.0
2012-05-07 07:30:00	QQQ	ETF	64.24	64.26	64.15	64.17	49102.0
2012-05-07 08:00:00	QQQ	ETF	64.17	64.3	64.16	64.28	84280.0
2012-05-07 08:30:00	QQQ	ETF	64.28	64.43	64.25	64.31	134680.0
2012-05-07 09:00:00	QQQ	ETF	64.3	64.42	64.29	64.3	566265.0
2012-05-07 09:30:00	QQQ	ETF	64.3	64.79	64.29	64.72	8919655.0
2012-05-07 10:00:00	QQQ	ETF	64.71	64.85	64.58	64.58	4946630.0
2012-05-07 10:30:00	QQQ	ETF	64.58	64.78	64.43	64.7708	4559118.0
2012-05-07 11:00:00	QQQ	ETF	64.77	64.9	64.67	64.69	3257159.0
2012-05-07 11:30:00	QQQ	ETF	64.69	64.7823	64.62	64.6809	1382190.0
2012-05-07 12:00:00	QQQ	ETF	64.685	64.76	64.6301	64.7	1257053.0
2012-05-07 12:30:00	QQQ	ETF	64.71	64.919	64.71	64.8491	2727902.0

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

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