PREVIEW / etf_30min / 2012-05-23

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-23.parquet
  size:    301 KB
  rows:    10,064

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-23 04:00:00	SPY	ETF	131.67	131.67	131.2	131.2	990.0
2012-05-23 04:30:00	SPY	ETF	131.27	131.27	131.27	131.27	260.0
2012-05-23 05:00:00	SPY	ETF	131.24	131.26	131.1	131.1	22200.0
2012-05-23 05:30:00	SPY	ETF	131.21	131.21	131.13	131.13	12100.0
2012-05-23 06:00:00	SPY	ETF	131.07	131.16	131.0	131.11	94665.0
2012-05-23 06:30:00	SPY	ETF	131.05	131.18	130.97	131.15	118400.0
2012-05-23 07:00:00	SPY	ETF	131.16	131.21	131.07	131.18	215597.0
2012-05-23 07:30:00	SPY	ETF	131.16	131.36	131.09	131.3	347084.0
2012-05-23 08:00:00	SPY	ETF	131.27	131.34	130.84	131.06	682204.0
2012-05-23 08:30:00	SPY	ETF	131.06	131.46	130.91	131.38	1029238.0
2012-05-23 09:00:00	SPY	ETF	131.39	131.52	131.2	131.25	1073169.0
2012-05-23 09:30:00	SPY	ETF	131.25	131.52	130.92	131.36	17862194.0
2012-05-23 10:00:00	SPY	ETF	131.35	131.61	130.53	130.75	19387834.0
2012-05-23 10:30:00	SPY	ETF	130.75	130.79	130.18	130.389	20506601.0
2012-05-23 11:00:00	SPY	ETF	130.38	130.71	130.26	130.485	11340837.0
2012-05-23 11:30:00	SPY	ETF	130.495	130.72	130.24	130.32	10866341.0
2012-05-23 12:00:00	SPY	ETF	130.32	130.3513	129.99	130.07	9645104.0
2012-05-23 12:30:00	SPY	ETF	130.07	130.48	130.04	130.31	8424777.0
2012-05-23 13:00:00	SPY	ETF	130.31	130.74	130.29	130.73	8558781.0
2012-05-23 13:30:00	SPY	ETF	130.73	130.99	130.63	130.941	10070800.0
2012-05-23 14:00:00	SPY	ETF	130.95	130.97	130.42	130.43	8465930.0
2012-05-23 14:30:00	SPY	ETF	130.42	131.31	130.38	131.269	13702547.0
2012-05-23 15:00:00	SPY	ETF	131.27	131.76	131.05	131.6	17741336.0
2012-05-23 15:30:00	SPY	ETF	131.59	132.46	131.59	132.26	34412609.0
2012-05-23 16:00:00	SPY	ETF	132.25	132.3	130.38	132.14	7768500.0
2012-05-23 16:30:00	SPY	ETF	132.16	132.16	131.98	132.03	1419749.0
2012-05-23 17:00:00	SPY	ETF	132.03	132.27	132.03	132.14	198628.0
2012-05-23 17:30:00	SPY	ETF	132.17	132.17	132.07	132.1	57585.0
2012-05-23 18:00:00	SPY	ETF	132.1	132.17	132.02	132.1	52205.0
2012-05-23 18:30:00	SPY	ETF	132.11	132.16	132.06	132.13	19921.0
2012-05-23 19:00:00	SPY	ETF	132.13	132.16	132.05	132.05	32774.0
2012-05-23 19:30:00	SPY	ETF	132.06	132.08	131.48	131.51	194037.0
2012-05-23 05:00:00	QQQ	ETF	61.97	61.99	61.97	61.99	900.0
2012-05-23 05:30:00	QQQ	ETF	61.89	61.89	61.89	61.89	200.0
2012-05-23 06:00:00	QQQ	ETF	61.85	61.85	61.85	61.85	1900.0
2012-05-23 06:30:00	QQQ	ETF	61.82	61.83	61.82	61.83	2000.0
2012-05-23 07:00:00	QQQ	ETF	61.85	61.9	61.84	61.87	13050.0
2012-05-23 07:30:00	QQQ	ETF	61.87	61.96	61.85	61.96	20490.0
2012-05-23 08:00:00	QQQ	ETF	61.96	62.08	61.75	61.82	101020.0
2012-05-23 08:30:00	QQQ	ETF	61.82	62.01	61.77	61.99	140364.0
2012-05-23 09:00:00	QQQ	ETF	61.99	62.04	61.89	61.92	132622.0
2012-05-23 09:30:00	QQQ	ETF	61.93	62.12	61.67	62.05	6138964.0
2012-05-23 10:00:00	QQQ	ETF	62.05	62.19	61.64	61.87	6248734.0
2012-05-23 10:30:00	QQQ	ETF	61.88	61.91	61.52	61.61	5511413.0
2012-05-23 11:00:00	QQQ	ETF	61.61	61.79	61.54	61.6499	3723172.0
2012-05-23 11:30:00	QQQ	ETF	61.64	61.7501	61.47	61.51	2495234.0
2012-05-23 12:00:00	QQQ	ETF	61.51	61.5401	61.37	61.44	2598605.0
2012-05-23 12:30:00	QQQ	ETF	61.43	61.66	61.42	61.56	2494984.0
2012-05-23 13:00:00	QQQ	ETF	61.56	61.8	61.55	61.79	2159357.0
2012-05-23 13:30:00	QQQ	ETF	61.8	61.97	61.77	61.96	3071769.0

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

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