PREVIEW / stock_30min / 2011-07-22

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-22.parquet
  size:    1.4 MB
  rows:    73,967
  symbols: 3,530

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-07-22 04:00:00	AAPL	Stock	13.9032	13.9032	13.9029	13.9029	8400.0
2011-07-22 04:30:00	AAPL	Stock	13.9071	13.9129	13.9071	13.9129	22400.0
2011-07-22 06:30:00	AAPL	Stock	13.9218	13.9218	13.9018	13.9018	19600.0
2011-07-22 07:00:00	AAPL	Stock	13.9204	13.9286	13.8961	13.9082	129080.0
2011-07-22 07:30:00	AAPL	Stock	13.9229	13.925	13.8586	13.8661	277256.0
2011-07-22 08:00:00	AAPL	Stock	13.8746	13.9236	13.8318	13.8607	722680.0
2011-07-22 08:30:00	AAPL	Stock	13.8586	13.8586	13.8254	13.8514	463036.0
2011-07-22 09:00:00	AAPL	Stock	13.8461	13.875	13.8214	13.8686	1263192.0
2011-07-22 09:30:00	AAPL	Stock	13.8686	13.9286	13.8482	13.8962	60394740.0
2011-07-22 10:00:00	AAPL	Stock	13.8957	13.9621	13.8861	13.9256	56972692.0
2011-07-22 10:30:00	AAPL	Stock	13.9214	13.9471	13.9189	13.942	27180104.0
2011-07-22 11:00:00	AAPL	Stock	13.9436	13.9471	13.925	13.9332	18388104.0
2011-07-22 11:30:00	AAPL	Stock	13.9332	13.9493	13.9268	13.9432	18895156.0
2011-07-22 12:00:00	AAPL	Stock	13.9432	13.9496	13.9357	13.9404	20645016.0
2011-07-22 12:30:00	AAPL	Stock	13.9414	13.9864	13.9368	13.9829	26744144.0
2011-07-22 13:00:00	AAPL	Stock	13.9831	14.0011	13.965	13.9711	27698160.0
2011-07-22 13:30:00	AAPL	Stock	13.9707	14.0532	13.9679	14.0514	40467168.0
2011-07-22 14:00:00	AAPL	Stock	14.0504	14.1071	14.0268	14.1007	64197728.0
2011-07-22 14:30:00	AAPL	Stock	14.1014	14.1089	14.0807	14.0843	36660680.0
2011-07-22 15:00:00	AAPL	Stock	14.0843	14.0868	14.0232	14.0486	45828440.0
2011-07-22 15:30:00	AAPL	Stock	14.0486	14.0532	14.0204	14.0464	55133904.0
2011-07-22 16:00:00	AAPL	Stock	14.0459	14.0492	13.9924	14.0429	5009732.0
2011-07-22 16:30:00	AAPL	Stock	14.0429	14.0481	14.0375	14.0414	170408.0
2011-07-22 17:00:00	AAPL	Stock	14.0421	14.0457	14.0411	14.0443	80080.0
2011-07-22 17:30:00	AAPL	Stock	14.0429	14.0461	14.0429	14.0461	211260.0
2011-07-22 18:00:00	AAPL	Stock	14.0368	14.0464	13.9921	14.0	816116.0
2011-07-22 18:30:00	AAPL	Stock	14.0	14.0	13.9571	13.9668	598920.0
2011-07-22 19:00:00	AAPL	Stock	13.9629	13.9732	13.9496	13.9671	340648.0
2011-07-22 19:30:00	AAPL	Stock	13.98	13.9911	13.9714	13.9836	293384.0
2011-07-22 04:00:00	MSFT	Stock	27.5	27.5	26.99	27.06	1600.0
2011-07-22 04:30:00	MSFT	Stock	26.93	27.05	26.93	27.05	500.0
2011-07-22 05:00:00	MSFT	Stock	27.05	27.05	27.05	27.05	100.0
2011-07-22 06:00:00	MSFT	Stock	26.98	26.98	26.98	26.98	800.0
2011-07-22 06:30:00	MSFT	Stock	27.0	27.01	26.86	26.86	15200.0
2011-07-22 07:00:00	MSFT	Stock	26.82	26.9	26.75	26.86	79169.0
2011-07-22 07:30:00	MSFT	Stock	26.85	26.9	26.72	26.77	243378.0
2011-07-22 08:00:00	MSFT	Stock	26.79	27.095	26.77	26.91	198403.0
2011-07-22 08:30:00	MSFT	Stock	26.9	26.92	26.81	26.87	107654.0
2011-07-22 09:00:00	MSFT	Stock	26.86	26.92	26.79	26.86	192625.0
2011-07-22 09:30:00	MSFT	Stock	26.86	27.33	26.68	27.13	17137951.0
2011-07-22 10:00:00	MSFT	Stock	27.125	27.14	26.85	27.04	7486399.0
2011-07-22 10:30:00	MSFT	Stock	27.04	27.13	26.99	27.11	5154268.0
2011-07-22 11:00:00	MSFT	Stock	27.105	27.115	27.04	27.07	2498737.0
2011-07-22 11:30:00	MSFT	Stock	27.07	27.15	27.05	27.13	3347808.0
2011-07-22 12:00:00	MSFT	Stock	27.125	27.235	27.09	27.22	2726015.0
2011-07-22 12:30:00	MSFT	Stock	27.22	27.24	27.11	27.222	3280457.0
2011-07-22 13:00:00	MSFT	Stock	27.23	27.3	27.22	27.295	3741108.0
2011-07-22 13:30:00	MSFT	Stock	27.29	27.37	27.282	27.349	3360181.0
2011-07-22 14:00:00	MSFT	Stock	27.34	27.48	27.33	27.47	4544779.0
2011-07-22 14:30:00	MSFT	Stock	27.464	27.49	27.43	27.49	3499252.0

> showing 50 of 73,967 rows — these rows as CSV

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