PREVIEW / etf_30min / 2012-07-30

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-30.parquet
  size:    279 KB
  rows:    9,434

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-30 04:00:00	SPY	ETF	138.41	138.41	138.25	138.25	500.0
2012-07-30 04:30:00	SPY	ETF	138.24	138.24	138.24	138.24	500.0
2012-07-30 05:00:00	SPY	ETF	138.25	138.44	138.25	138.44	15100.0
2012-07-30 05:30:00	SPY	ETF	138.51	138.51	138.51	138.51	100.0
2012-07-30 06:00:00	SPY	ETF	138.59	138.59	138.51	138.51	20200.0
2012-07-30 06:30:00	SPY	ETF	138.51	138.54	138.41	138.45	8104.0
2012-07-30 07:00:00	SPY	ETF	138.49	138.58	138.47	138.54	50460.0
2012-07-30 07:30:00	SPY	ETF	138.54	138.57	138.41	138.47	135326.0
2012-07-30 08:00:00	SPY	ETF	138.47	138.58	138.37	138.37	385387.0
2012-07-30 08:30:00	SPY	ETF	138.36	138.49	138.3	138.49	464801.0
2012-07-30 09:00:00	SPY	ETF	138.49	138.59	138.44	138.51	708150.0
2012-07-30 09:30:00	SPY	ETF	138.52	138.98	138.51	138.96	12159668.0
2012-07-30 10:00:00	SPY	ETF	138.965	139.339	138.86	139.21	10480996.0
2012-07-30 10:30:00	SPY	ETF	139.21	139.22	138.69	138.71	10882418.0
2012-07-30 11:00:00	SPY	ETF	138.71	138.94	138.44	138.5	10072698.0
2012-07-30 11:30:00	SPY	ETF	138.49	138.52	138.27	138.46	6647193.0
2012-07-30 12:00:00	SPY	ETF	138.46	138.48	138.27	138.42	4209941.0
2012-07-30 12:30:00	SPY	ETF	138.42	138.65	138.35	138.53	6402049.0
2012-07-30 13:00:00	SPY	ETF	138.53	138.66	138.4	138.56	3835346.0
2012-07-30 13:30:00	SPY	ETF	138.56	138.75	138.4	138.47	3891192.0
2012-07-30 14:00:00	SPY	ETF	138.46	138.6	138.32	138.54	5163919.0
2012-07-30 14:30:00	SPY	ETF	138.538	138.76	138.535	138.69	3684490.0
2012-07-30 15:00:00	SPY	ETF	138.68	138.71	138.37	138.65	5466134.0
2012-07-30 15:30:00	SPY	ETF	138.66	138.77	138.48	138.67	12491112.0
2012-07-30 16:00:00	SPY	ETF	138.67	138.8161	138.5421	138.62	4604650.0
2012-07-30 16:30:00	SPY	ETF	138.6	138.68	138.52	138.61	458392.0
2012-07-30 17:00:00	SPY	ETF	138.61	138.67	138.28	138.64	2089450.0
2012-07-30 17:30:00	SPY	ETF	138.64	138.68	138.64	138.64	8365.0
2012-07-30 18:00:00	SPY	ETF	138.64	138.68	138.64	138.68	43158.0
2012-07-30 18:30:00	SPY	ETF	138.69	138.72	138.67	138.69	2694.0
2012-07-30 19:00:00	SPY	ETF	138.67	138.72	138.67	138.67	2100.0
2012-07-30 19:30:00	SPY	ETF	138.67	138.7	138.52	138.6	18572.0
2012-07-30 04:00:00	QQQ	ETF	64.69	64.7	64.69	64.7	200.0
2012-07-30 04:30:00	QQQ	ETF	64.78	64.78	64.78	64.78	100.0
2012-07-30 05:00:00	QQQ	ETF	64.87	64.87	64.84	64.84	200.0
2012-07-30 05:30:00	QQQ	ETF	64.96	64.96	64.96	64.96	500.0
2012-07-30 06:00:00	QQQ	ETF	64.92	64.92	64.92	64.92	500.0
2012-07-30 07:00:00	QQQ	ETF	64.91	64.96	64.91	64.93	30268.0
2012-07-30 07:30:00	QQQ	ETF	64.95	64.96	64.91	64.95	7000.0
2012-07-30 08:00:00	QQQ	ETF	64.91	65.01	64.91	64.93	97695.0
2012-07-30 08:30:00	QQQ	ETF	64.92	65.02	64.92	65.01	72766.0
2012-07-30 09:00:00	QQQ	ETF	65.01	65.09	64.99	65.01	177772.0
2012-07-30 09:30:00	QQQ	ETF	65.01	65.31	64.98	65.2595	4399968.0
2012-07-30 10:00:00	QQQ	ETF	65.26	65.31	65.03	65.19	3244803.0
2012-07-30 10:30:00	QQQ	ETF	65.19	65.195	64.85	64.87	5396108.0
2012-07-30 11:00:00	QQQ	ETF	64.875	65.02	64.69	64.755	3246114.0
2012-07-30 11:30:00	QQQ	ETF	64.75	64.82	64.68	64.8011	1902686.0
2012-07-30 12:00:00	QQQ	ETF	64.8	64.8199	64.68	64.748	1875099.0
2012-07-30 12:30:00	QQQ	ETF	64.75	64.89	64.67	64.76	1767691.0
2012-07-30 13:00:00	QQQ	ETF	64.76	64.85	64.7	64.82	778265.0

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

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