PREVIEW / stock_30min / 2014-09-03

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-03.parquet
  size:    1.6 MB
  rows:    82,724
  symbols: 3,582

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
2014-09-03 04:00:00	AAPL	Stock	25.7475	25.9725	25.7475	25.9725	51756.0
2014-09-03 04:30:00	AAPL	Stock	25.9625	25.9925	25.945	25.945	54788.0
2014-09-03 05:00:00	AAPL	Stock	25.9375	25.96	25.9275	25.93	24880.0
2014-09-03 05:30:00	AAPL	Stock	25.925	25.95	25.925	25.95	6800.0
2014-09-03 06:00:00	AAPL	Stock	25.9475	25.9475	25.9275	25.9475	37924.0
2014-09-03 06:30:00	AAPL	Stock	25.9475	25.9475	25.875	25.9125	112832.0
2014-09-03 07:00:00	AAPL	Stock	25.9125	25.9125	25.8425	25.8625	97880.0
2014-09-03 07:30:00	AAPL	Stock	25.855	25.8575	25.805	25.8175	159724.0
2014-09-03 08:00:00	AAPL	Stock	25.825	25.9125	25.725	25.7725	1002960.0
2014-09-03 08:30:00	AAPL	Stock	25.7725	25.7875	25.725	25.7625	765188.0
2014-09-03 09:00:00	AAPL	Stock	25.7525	25.82	25.75	25.79	683252.0
2014-09-03 09:30:00	AAPL	Stock	25.775	25.8	24.975	25.07	102725304.0
2014-09-03 10:00:00	AAPL	Stock	25.07	25.2775	25.0575	25.125	42678916.0
2014-09-03 10:30:00	AAPL	Stock	25.125	25.1375	25.0075	25.0675	30299292.0
2014-09-03 11:00:00	AAPL	Stock	25.0662	25.0925	24.94	24.94	32910452.0
2014-09-03 11:30:00	AAPL	Stock	24.9425	24.9475	24.645	24.77	61478420.0
2014-09-03 12:00:00	AAPL	Stock	24.7725	24.815	24.7	24.775	32284200.0
2014-09-03 12:30:00	AAPL	Stock	24.7775	24.9825	24.74	24.97	33925208.0
2014-09-03 13:00:00	AAPL	Stock	24.9675	25.045	24.9075	25.0	18422072.0
2014-09-03 13:30:00	AAPL	Stock	24.9988	25.01	24.915	24.98	12716084.0
2014-09-03 14:00:00	AAPL	Stock	24.98	24.9975	24.8925	24.92	11583328.0
2014-09-03 14:30:00	AAPL	Stock	24.92	24.945	24.7275	24.745	20289088.0
2014-09-03 15:00:00	AAPL	Stock	24.7425	24.8	24.72	24.7725	20772516.0
2014-09-03 15:30:00	AAPL	Stock	24.7725	24.78	24.7025	24.735	37225132.0
2014-09-03 16:00:00	AAPL	Stock	24.735	25.3898	24.73	24.7375	7443432.0
2014-09-03 16:30:00	AAPL	Stock	24.7375	24.7675	24.735	24.765	322540.0
2014-09-03 17:00:00	AAPL	Stock	24.7675	24.7775	24.735	24.7775	430880.0
2014-09-03 17:30:00	AAPL	Stock	24.7775	24.7875	24.735	24.7775	596280.0
2014-09-03 18:00:00	AAPL	Stock	24.7775	24.805	24.735	24.8	283724.0
2014-09-03 18:30:00	AAPL	Stock	24.8	24.805	24.735	24.7875	260860.0
2014-09-03 19:00:00	AAPL	Stock	24.7925	24.7975	24.7875	24.79	89900.0
2014-09-03 19:30:00	AAPL	Stock	24.7925	24.795	24.75	24.75	266528.0
2014-09-03 04:00:00	MSFT	Stock	45.3	45.3	45.3	45.3	221.0
2014-09-03 06:00:00	MSFT	Stock	45.21	45.21	45.21	45.21	100.0
2014-09-03 07:00:00	MSFT	Stock	45.23	45.23	45.21	45.21	980.0
2014-09-03 07:30:00	MSFT	Stock	45.21	45.23	45.21	45.21	3522.0
2014-09-03 08:00:00	MSFT	Stock	45.19	45.21	45.11	45.12	12572.0
2014-09-03 08:30:00	MSFT	Stock	45.13	45.13	45.0	45.02	11603.0
2014-09-03 09:00:00	MSFT	Stock	45.03	45.05	44.1	44.56	734978.0
2014-09-03 09:30:00	MSFT	Stock	44.53	45.0	44.53	44.91	7329519.0
2014-09-03 10:00:00	MSFT	Stock	44.911	44.96	44.84	44.91	3029643.0
2014-09-03 10:30:00	MSFT	Stock	44.91	45.03	44.9	44.94	2153050.0
2014-09-03 11:00:00	MSFT	Stock	44.945	45.0	44.86	44.87	1857782.0
2014-09-03 11:30:00	MSFT	Stock	44.87	44.98	44.86	44.88	1341380.0
2014-09-03 12:00:00	MSFT	Stock	44.885	45.01	44.85	45.01	1796454.0
2014-09-03 12:30:00	MSFT	Stock	45.005	45.08	45.0	45.055	1752731.0
2014-09-03 13:00:00	MSFT	Stock	45.055	45.11	45.01	45.05	1987499.0
2014-09-03 13:30:00	MSFT	Stock	45.06	45.1	45.01	45.045	1800139.0
2014-09-03 14:00:00	MSFT	Stock	45.045	45.06	44.96	44.971	1378417.0
2014-09-03 14:30:00	MSFT	Stock	44.98	45.0	44.92	44.935	1035627.0

> showing 50 of 82,724 rows — these rows as CSV

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