PREVIEW / stock_30min / 2013-06-03

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-03.parquet
  size:    1.6 MB
  rows:    81,377
  symbols: 3,513

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
2013-06-03 04:00:00	AAPL	Stock	16.0357	16.0357	16.0261	16.0357	14000.0
2013-06-03 04:30:00	AAPL	Stock	16.0214	16.0214	16.0214	16.0214	5600.0
2013-06-03 05:00:00	AAPL	Stock	16.0136	16.0357	16.0136	16.0321	11200.0
2013-06-03 05:30:00	AAPL	Stock	16.0696	16.0786	16.0696	16.0786	39200.0
2013-06-03 06:00:00	AAPL	Stock	16.0893	16.0893	16.0714	16.0714	8400.0
2013-06-03 06:30:00	AAPL	Stock	16.0893	16.1354	16.0893	16.1354	25816.0
2013-06-03 07:00:00	AAPL	Stock	16.1357	16.1596	16.1357	16.1518	456288.0
2013-06-03 07:30:00	AAPL	Stock	16.1546	16.1679	16.1357	16.1525	579348.0
2013-06-03 08:00:00	AAPL	Stock	16.1443	16.1643	16.06	16.1075	1890840.0
2013-06-03 08:30:00	AAPL	Stock	16.1071	16.1393	16.1036	16.1368	1182104.0
2013-06-03 09:00:00	AAPL	Stock	16.1336	16.1554	16.0964	16.1075	1493436.0
2013-06-03 09:30:00	AAPL	Stock	16.1071	16.1557	15.8964	15.9943	68979876.0
2013-06-03 10:00:00	AAPL	Stock	15.9982	16.0582	15.9554	15.9696	45097332.0
2013-06-03 10:30:00	AAPL	Stock	15.9686	15.9971	15.88	15.8986	30897608.0
2013-06-03 11:00:00	AAPL	Stock	15.8943	15.9164	15.8357	15.8546	32597852.0
2013-06-03 11:30:00	AAPL	Stock	15.8529	15.8918	15.8029	15.8843	25110708.0
2013-06-03 12:00:00	AAPL	Stock	15.8843	15.8914	15.8244	15.8414	13857396.0
2013-06-03 12:30:00	AAPL	Stock	15.8414	15.9286	15.8157	15.9243	18397092.0
2013-06-03 13:00:00	AAPL	Stock	15.9243	15.9779	15.9061	15.9308	21071568.0
2013-06-03 13:30:00	AAPL	Stock	15.9339	15.9446	15.8914	15.9086	12079536.0
2013-06-03 14:00:00	AAPL	Stock	15.9082	15.9632	15.8989	15.9308	13476820.0
2013-06-03 14:30:00	AAPL	Stock	15.9304	15.9893	15.9143	15.9525	13764464.0
2013-06-03 15:00:00	AAPL	Stock	15.9557	16.03	15.9464	16.0251	21325276.0
2013-06-03 15:30:00	AAPL	Stock	16.0271	16.0989	16.0079	16.0979	36129576.0
2013-06-03 16:00:00	AAPL	Stock	16.0971	16.1036	15.8446	16.0987	8612660.0
2013-06-03 16:30:00	AAPL	Stock	16.0979	16.1004	16.0893	16.0968	290276.0
2013-06-03 17:00:00	AAPL	Stock	16.0993	16.1193	16.0979	16.1168	555436.0
2013-06-03 17:30:00	AAPL	Stock	16.1161	16.1161	16.1107	16.1107	30800.0
2013-06-03 18:00:00	AAPL	Stock	16.1143	16.125	16.1114	16.125	193312.0
2013-06-03 18:30:00	AAPL	Stock	16.1239	16.1339	16.1071	16.1314	191324.0
2013-06-03 19:00:00	AAPL	Stock	16.125	16.125	16.0982	16.1071	210560.0
2013-06-03 19:30:00	AAPL	Stock	16.1064	16.125	16.1054	16.1168	54600.0
2013-06-03 04:00:00	MSFT	Stock	34.85	34.85	34.85	34.85	2000.0
2013-06-03 05:00:00	MSFT	Stock	34.85	34.85	34.85	34.85	1800.0
2013-06-03 05:30:00	MSFT	Stock	34.85	34.96	34.5	34.5	6990.0
2013-06-03 06:00:00	MSFT	Stock	34.84	34.87	34.84	34.87	2300.0
2013-06-03 06:30:00	MSFT	Stock	34.87	34.95	34.87	34.95	652.0
2013-06-03 07:00:00	MSFT	Stock	34.9	34.94	34.9	34.94	3600.0
2013-06-03 07:30:00	MSFT	Stock	34.94	35.15	34.94	35.15	24570.0
2013-06-03 08:00:00	MSFT	Stock	35.11	35.15	35.05	35.11	33434.0
2013-06-03 08:30:00	MSFT	Stock	35.09	35.09	35.01	35.05	24408.0
2013-06-03 09:00:00	MSFT	Stock	35.02	35.05	34.86	34.93	139611.0
2013-06-03 09:30:00	MSFT	Stock	34.93	34.99	34.83	34.9	5405945.0
2013-06-03 10:00:00	MSFT	Stock	34.89	35.13	34.87	35.11	5191206.0
2013-06-03 10:30:00	MSFT	Stock	35.115	35.25	35.045	35.235	4214080.0
2013-06-03 11:00:00	MSFT	Stock	35.235	35.27	35.1	35.14	3540514.0
2013-06-03 11:30:00	MSFT	Stock	35.13	35.185	35.04	35.14	2701014.0
2013-06-03 12:00:00	MSFT	Stock	35.14	35.175	35.045	35.11	2457523.0
2013-06-03 12:30:00	MSFT	Stock	35.11	35.16	35.07	35.135	1515419.0
2013-06-03 13:00:00	MSFT	Stock	35.135	35.26	35.11	35.205	2054858.0

> showing 50 of 81,377 rows — these rows as CSV

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