PREVIEW / stock_30min / 2011-12-13

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-13.parquet
  size:    1.4 MB
  rows:    76,486
  symbols: 3,526

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
2011-12-13 04:30:00	AAPL	Stock	14.0	14.0	14.0	14.0	2800.0
2011-12-13 05:00:00	AAPL	Stock	14.0357	14.0357	14.0357	14.0357	2800.0
2011-12-13 06:00:00	AAPL	Stock	14.0714	14.0714	14.0711	14.0711	5600.0
2011-12-13 06:30:00	AAPL	Stock	14.0714	14.0714	14.0714	14.0714	2800.0
2011-12-13 07:00:00	AAPL	Stock	14.0579	14.0714	14.0357	14.0711	64540.0
2011-12-13 07:30:00	AAPL	Stock	14.0675	14.0711	14.0536	14.0679	81200.0
2011-12-13 08:00:00	AAPL	Stock	14.0536	14.0725	14.0357	14.0643	859012.0
2011-12-13 08:30:00	AAPL	Stock	14.0614	14.0614	13.9943	14.0446	1511580.0
2011-12-13 09:00:00	AAPL	Stock	14.0375	14.045	14.025	14.0386	958664.0
2011-12-13 09:30:00	AAPL	Stock	14.0357	14.1214	14.0279	14.1011	47760076.0
2011-12-13 10:00:00	AAPL	Stock	14.108	14.1082	14.0668	14.0731	21945756.0
2011-12-13 10:30:00	AAPL	Stock	14.075	14.0961	14.0061	14.0349	29881768.0
2011-12-13 11:00:00	AAPL	Stock	14.0321	14.0361	13.985	14.0196	22527568.0
2011-12-13 11:30:00	AAPL	Stock	14.0192	14.0429	14.0096	14.0382	13321112.0
2011-12-13 12:00:00	AAPL	Stock	14.0386	14.0446	14.0207	14.0354	9613576.0
2011-12-13 12:30:00	AAPL	Stock	14.035	14.0443	13.9961	14.0271	14829556.0
2011-12-13 13:00:00	AAPL	Stock	14.0268	14.0386	14.0011	14.0102	11834060.0
2011-12-13 13:30:00	AAPL	Stock	14.01	14.0354	14.0068	14.0304	7054572.0
2011-12-13 14:00:00	AAPL	Stock	14.0325	14.0621	13.9939	14.0287	21856100.0
2011-12-13 14:30:00	AAPL	Stock	14.0261	14.0325	13.9571	13.9971	26216904.0
2011-12-13 15:00:00	AAPL	Stock	13.9961	14.0129	13.8679	13.8764	32959136.0
2011-12-13 15:30:00	AAPL	Stock	13.8764	13.9067	13.825	13.8854	57653204.0
2011-12-13 16:00:00	AAPL	Stock	13.8831	13.9994	13.8721	13.8868	10743460.0
2011-12-13 16:30:00	AAPL	Stock	13.8861	14.0436	13.8584	13.8893	365064.0
2011-12-13 17:00:00	AAPL	Stock	13.9943	13.9943	13.8875	13.8982	62300.0
2011-12-13 17:30:00	AAPL	Stock	13.8954	13.9071	13.8954	13.9021	102900.0
2011-12-13 18:00:00	AAPL	Stock	13.9061	13.9071	13.8861	13.9071	100912.0
2011-12-13 18:30:00	AAPL	Stock	13.9071	13.9093	13.9025	13.9025	30492.0
2011-12-13 19:00:00	AAPL	Stock	13.9004	13.9054	13.8968	13.9054	42840.0
2011-12-13 19:30:00	AAPL	Stock	13.9054	13.9107	13.9054	13.9107	31220.0
2011-12-13 07:00:00	MSFT	Stock	25.69	25.69	25.51	25.51	200.0
2011-12-13 07:30:00	MSFT	Stock	25.67	25.7	25.65	25.65	5900.0
2011-12-13 08:00:00	MSFT	Stock	25.66	25.73	25.65	25.71	23201.0
2011-12-13 08:30:00	MSFT	Stock	25.7	25.7	25.61	25.7	23549.0
2011-12-13 09:00:00	MSFT	Stock	25.69	25.78	25.68	25.76	58797.0
2011-12-13 09:30:00	MSFT	Stock	25.75	26.0	25.72	25.93	6306206.0
2011-12-13 10:00:00	MSFT	Stock	25.94	26.05	25.93	25.97	3882790.0
2011-12-13 10:30:00	MSFT	Stock	25.965	25.97	25.79	25.89	4741905.0
2011-12-13 11:00:00	MSFT	Stock	25.89	25.9	25.79	25.9	3170484.0
2011-12-13 11:30:00	MSFT	Stock	25.89	26.02	25.88	26.0	3075288.0
2011-12-13 12:00:00	MSFT	Stock	26.001	26.03	25.91	25.97	1842592.0
2011-12-13 12:30:00	MSFT	Stock	25.97	26.02	25.93	25.98	1707040.0
2011-12-13 13:00:00	MSFT	Stock	25.98	26.04	25.94	25.98	2289701.0
2011-12-13 13:30:00	MSFT	Stock	25.98	26.02	25.94	26.015	1676882.0
2011-12-13 14:00:00	MSFT	Stock	26.011	26.1	25.94	25.989	3721547.0
2011-12-13 14:30:00	MSFT	Stock	25.99	25.99	25.84	25.89	4098432.0
2011-12-13 15:00:00	MSFT	Stock	25.885	25.92	25.74	25.775	5015477.0
2011-12-13 15:30:00	MSFT	Stock	25.77	25.8	25.651	25.73	8750207.0
2011-12-13 16:00:00	MSFT	Stock	25.74	25.99	25.73	25.775	3288528.0
2011-12-13 16:30:00	MSFT	Stock	25.76	25.978	25.732	25.769	72557.0

> showing 50 of 76,486 rows — these rows as CSV

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