PREVIEW / stock_30min / 2012-08-28

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-28.parquet
  size:    1.4 MB
  rows:    73,113
  symbols: 3,441

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-08-28 04:00:00	AAPL	Stock	24.1429	24.2143	24.1429	24.1786	46200.0
2012-08-28 04:30:00	AAPL	Stock	24.2132	24.2343	24.2132	24.2343	55300.0
2012-08-28 05:00:00	AAPL	Stock	24.2325	24.2325	24.2325	24.2325	2800.0
2012-08-28 05:30:00	AAPL	Stock	24.2321	24.2411	24.2321	24.2411	17920.0
2012-08-28 06:00:00	AAPL	Stock	24.2218	24.225	24.2143	24.2143	16800.0
2012-08-28 06:30:00	AAPL	Stock	24.2036	24.2036	24.2036	24.2036	7280.0
2012-08-28 07:00:00	AAPL	Stock	24.1843	24.1964	24.1439	24.1739	170044.0
2012-08-28 07:30:00	AAPL	Stock	24.1696	24.1696	24.1286	24.1429	197988.0
2012-08-28 08:00:00	AAPL	Stock	24.1568	24.2	24.0893	24.1161	1246840.0
2012-08-28 08:30:00	AAPL	Stock	24.1125	24.1207	24.0757	24.0939	442428.0
2012-08-28 09:00:00	AAPL	Stock	24.0871	24.1089	24.0871	24.1071	809956.0
2012-08-28 09:30:00	AAPL	Stock	24.1061	24.125	23.9911	24.0236	56196084.0
2012-08-28 10:00:00	AAPL	Stock	24.0189	24.0779	24.0079	24.0629	25751600.0
2012-08-28 10:30:00	AAPL	Stock	24.0622	24.0711	23.9743	23.9836	24427620.0
2012-08-28 11:00:00	AAPL	Stock	23.9854	24.0179	23.9526	24.0168	20401388.0
2012-08-28 11:30:00	AAPL	Stock	24.0114	24.1311	23.9965	24.1118	23875264.0
2012-08-28 12:00:00	AAPL	Stock	24.1118	24.1339	24.0893	24.1093	16420992.0
2012-08-28 12:30:00	AAPL	Stock	24.109	24.1175	24.0636	24.0964	11328240.0
2012-08-28 13:00:00	AAPL	Stock	24.0957	24.0986	24.0468	24.0554	8468292.0
2012-08-28 13:30:00	AAPL	Stock	24.0582	24.0961	24.0496	24.0661	9954616.0
2012-08-28 14:00:00	AAPL	Stock	24.0654	24.1168	24.0625	24.1104	9516612.0
2012-08-28 14:30:00	AAPL	Stock	24.11	24.125	24.0818	24.1025	9174004.0
2012-08-28 15:00:00	AAPL	Stock	24.1043	24.1464	24.0982	24.1171	15496320.0
2012-08-28 15:30:00	AAPL	Stock	24.1168	24.1171	24.085	24.0982	19947816.0
2012-08-28 16:00:00	AAPL	Stock	24.1	24.1125	24.0013	24.1089	3976308.0
2012-08-28 16:30:00	AAPL	Stock	24.1	24.1129	24.1	24.1107	294448.0
2012-08-28 17:00:00	AAPL	Stock	24.1093	24.1093	24.1004	24.1071	58240.0
2012-08-28 17:30:00	AAPL	Stock	24.1071	24.1125	24.105	24.1071	69664.0
2012-08-28 18:00:00	AAPL	Stock	24.1089	24.1136	24.1071	24.1136	58156.0
2012-08-28 18:30:00	AAPL	Stock	24.1136	24.1136	24.1079	24.1086	56084.0
2012-08-28 19:00:00	AAPL	Stock	24.1089	24.1132	24.1054	24.1132	56448.0
2012-08-28 19:30:00	AAPL	Stock	24.1136	24.1225	24.1046	24.1204	303436.0
2012-08-28 05:30:00	MSFT	Stock	30.67	30.67	30.67	30.67	100.0
2012-08-28 06:00:00	MSFT	Stock	30.93	30.93	30.93	30.93	100.0
2012-08-28 06:30:00	MSFT	Stock	30.85	30.85	30.85	30.85	100.0
2012-08-28 07:00:00	MSFT	Stock	30.8	30.91	30.8	30.85	1400.0
2012-08-28 07:30:00	MSFT	Stock	30.77	30.82	30.75	30.82	2300.0
2012-08-28 08:00:00	MSFT	Stock	30.77	30.9	30.69	30.86	21350.0
2012-08-28 08:30:00	MSFT	Stock	30.86	30.86	30.75	30.8	11000.0
2012-08-28 09:00:00	MSFT	Stock	30.76	30.82	30.69	30.71	24833.0
2012-08-28 09:30:00	MSFT	Stock	30.76	30.8	30.56	30.57	2797532.0
2012-08-28 10:00:00	MSFT	Stock	30.57	30.72	30.52	30.7	3081003.0
2012-08-28 10:30:00	MSFT	Stock	30.71	30.75	30.65	30.66	2011748.0
2012-08-28 11:00:00	MSFT	Stock	30.66	30.71	30.605	30.66	2351736.0
2012-08-28 11:30:00	MSFT	Stock	30.665	30.7	30.64	30.69	1156341.0
2012-08-28 12:00:00	MSFT	Stock	30.7	30.74	30.68	30.71	1470167.0
2012-08-28 12:30:00	MSFT	Stock	30.71	30.72	30.67	30.7	948851.0
2012-08-28 13:00:00	MSFT	Stock	30.71	30.71	30.65	30.664	920401.0
2012-08-28 13:30:00	MSFT	Stock	30.66	30.67	30.62	30.665	752003.0
2012-08-28 14:00:00	MSFT	Stock	30.669	30.71	30.65	30.705	915564.0

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

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