PREVIEW / stock_30min / 2012-09-19

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-19.parquet
  size:    1.4 MB
  rows:    76,302
  symbols: 3,472

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-09-19 04:00:00	AAPL	Stock	25.1429	25.1429	25.1071	25.1071	66108.0
2012-09-19 04:30:00	AAPL	Stock	25.1071	25.1079	25.0957	25.1057	33208.0
2012-09-19 05:00:00	AAPL	Stock	25.0714	25.0989	25.0714	25.0989	5600.0
2012-09-19 05:30:00	AAPL	Stock	25.0989	25.0989	25.0893	25.0911	23100.0
2012-09-19 06:00:00	AAPL	Stock	25.0982	25.0982	25.0982	25.0982	4704.0
2012-09-19 06:30:00	AAPL	Stock	25.0964	25.0982	25.0857	25.0857	9520.0
2012-09-19 07:00:00	AAPL	Stock	25.0929	25.0929	25.0357	25.0357	320096.0
2012-09-19 07:30:00	AAPL	Stock	25.0429	25.0482	25.0286	25.0286	102144.0
2012-09-19 08:00:00	AAPL	Stock	25.0343	25.0714	24.9929	25.0075	1384376.0
2012-09-19 08:30:00	AAPL	Stock	25.0071	25.0532	25.0071	25.0532	1101184.0
2012-09-19 09:00:00	AAPL	Stock	25.0532	25.0532	24.9964	25.0089	2535736.0
2012-09-19 09:30:00	AAPL	Stock	25.0164	25.125	24.9846	25.0644	59907316.0
2012-09-19 10:00:00	AAPL	Stock	25.0714	25.0961	25.0321	25.0367	33692260.0
2012-09-19 10:30:00	AAPL	Stock	25.0343	25.0639	25.0039	25.0482	23005472.0
2012-09-19 11:00:00	AAPL	Stock	25.0481	25.0671	25.0171	25.0204	15146628.0
2012-09-19 11:30:00	AAPL	Stock	25.02	25.0536	24.9911	25.0329	20323828.0
2012-09-19 12:00:00	AAPL	Stock	25.035	25.0818	25.0282	25.0818	13917848.0
2012-09-19 12:30:00	AAPL	Stock	25.0818	25.0857	25.0479	25.0518	12115208.0
2012-09-19 13:00:00	AAPL	Stock	25.0563	25.0586	25.0362	25.0475	8440600.0
2012-09-19 13:30:00	AAPL	Stock	25.0464	25.0666	25.0357	25.0661	8342544.0
2012-09-19 14:00:00	AAPL	Stock	25.0654	25.1014	25.0639	25.0939	16419760.0
2012-09-19 14:30:00	AAPL	Stock	25.0961	25.1171	25.0839	25.1149	16325036.0
2012-09-19 15:00:00	AAPL	Stock	25.113	25.1425	25.0964	25.1361	24227280.0
2012-09-19 15:30:00	AAPL	Stock	25.1361	25.1361	25.0621	25.0776	34299860.0
2012-09-19 16:00:00	AAPL	Stock	25.075	25.0871	25.0464	25.0571	22598212.0
2012-09-19 16:30:00	AAPL	Stock	25.0571	25.1267	25.0486	25.0536	1569344.0
2012-09-19 17:00:00	AAPL	Stock	25.0572	25.0625	25.0411	25.0532	333452.0
2012-09-19 17:30:00	AAPL	Stock	25.0493	25.075	25.0432	25.0443	116676.0
2012-09-19 18:00:00	AAPL	Stock	25.0464	25.0493	25.0393	25.0493	144172.0
2012-09-19 18:30:00	AAPL	Stock	25.0454	25.0532	25.0454	25.0457	27440.0
2012-09-19 19:00:00	AAPL	Stock	25.0457	25.0604	25.0457	25.0604	107100.0
2012-09-19 19:30:00	AAPL	Stock	25.0536	25.06	25.0493	25.06	161980.0
2012-09-19 07:00:00	MSFT	Stock	31.15	31.19	31.14	31.14	3250.0
2012-09-19 07:30:00	MSFT	Stock	31.1	31.1	31.1	31.1	225.0
2012-09-19 08:00:00	MSFT	Stock	31.15	31.15	31.03	31.13	25193.0
2012-09-19 08:30:00	MSFT	Stock	31.13	31.13	31.07	31.07	50775.0
2012-09-19 09:00:00	MSFT	Stock	31.08	31.13	31.04	31.06	106006.0
2012-09-19 09:30:00	MSFT	Stock	31.07	31.18	31.06	31.1	4647958.0
2012-09-19 10:00:00	MSFT	Stock	31.09	31.18	31.09	31.15	3057453.0
2012-09-19 10:30:00	MSFT	Stock	31.14	31.16	31.08	31.12	4043055.0
2012-09-19 11:00:00	MSFT	Stock	31.12	31.19	31.1	31.18	4067882.0
2012-09-19 11:30:00	MSFT	Stock	31.18	31.19	31.13	31.14	1654403.0
2012-09-19 12:00:00	MSFT	Stock	31.13	31.17	31.105	31.17	1677954.0
2012-09-19 12:30:00	MSFT	Stock	31.16	31.18	31.14	31.146	1379787.0
2012-09-19 13:00:00	MSFT	Stock	31.145	31.155	31.13	31.14	984935.0
2012-09-19 13:30:00	MSFT	Stock	31.145	31.16	31.1	31.13	1405140.0
2012-09-19 14:00:00	MSFT	Stock	31.13	31.16	31.12	31.14	961477.0
2012-09-19 14:30:00	MSFT	Stock	31.14	31.15	31.13	31.13	2242451.0
2012-09-19 15:00:00	MSFT	Stock	31.138	31.14	31.09	31.13	4782532.0
2012-09-19 15:30:00	MSFT	Stock	31.12	31.13	31.04	31.06	8139907.0

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

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