PREVIEW / stock_30min / 2010-10-19

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-19.parquet
  size:    1.4 MB
  rows:    75,728
  symbols: 3,494

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
2010-10-19 04:00:00	AAPL	Stock	10.7486	10.8186	10.7214	10.7757	135800.0
2010-10-19 04:30:00	AAPL	Stock	10.7629	10.7629	10.7607	10.7618	36400.0
2010-10-19 05:00:00	AAPL	Stock	10.7957	10.81	10.7786	10.81	84616.0
2010-10-19 05:30:00	AAPL	Stock	10.7964	10.81	10.7925	10.8032	75600.0
2010-10-19 06:00:00	AAPL	Stock	10.7918	10.7918	10.7746	10.7746	71400.0
2010-10-19 06:30:00	AAPL	Stock	10.7782	10.7943	10.7718	10.7939	175336.0
2010-10-19 07:00:00	AAPL	Stock	10.7807	10.8054	10.6986	10.8054	1264088.0
2010-10-19 07:30:00	AAPL	Stock	10.8036	10.8086	10.715	10.75	1347976.0
2010-10-19 08:00:00	AAPL	Stock	10.75	10.9207	10.7321	10.9107	18703076.0
2010-10-19 08:30:00	AAPL	Stock	10.9114	11.0207	10.8964	10.8964	32203892.0
2010-10-19 09:00:00	AAPL	Stock	10.8971	10.8986	10.7418	10.835	21599984.0
2010-10-19 09:30:00	AAPL	Stock	10.835	11.0	10.715	10.9821	271421584.0
2010-10-19 10:00:00	AAPL	Stock	10.9832	11.1786	10.9507	11.1433	200310320.0
2010-10-19 10:30:00	AAPL	Stock	11.1467	11.2061	11.1164	11.1329	87342416.0
2010-10-19 11:00:00	AAPL	Stock	11.1332	11.14	11.0504	11.0679	73727332.0
2010-10-19 11:30:00	AAPL	Stock	11.0671	11.1557	11.0661	11.133	54263748.0
2010-10-19 12:00:00	AAPL	Stock	11.135	11.1679	11.1093	11.1244	39087132.0
2010-10-19 12:30:00	AAPL	Stock	11.1246	11.1507	11.1096	11.1454	29527568.0
2010-10-19 13:00:00	AAPL	Stock	11.1461	11.1464	11.0821	11.0825	36067304.0
2010-10-19 13:30:00	AAPL	Stock	11.0821	11.0964	11.0236	11.0381	50022616.0
2010-10-19 14:00:00	AAPL	Stock	11.0382	11.04	10.9529	10.9959	87551156.0
2010-10-19 14:30:00	AAPL	Stock	10.9968	11.0671	10.9846	11.0329	50684396.0
2010-10-19 15:00:00	AAPL	Stock	11.0348	11.0438	10.9714	10.9775	52352468.0
2010-10-19 15:30:00	AAPL	Stock	10.9775	11.0589	10.94	11.0589	85658720.0
2010-10-19 16:00:00	AAPL	Stock	11.0589	11.0604	11.0016	11.0457	11090548.0
2010-10-19 16:30:00	AAPL	Stock	11.0429	11.0536	10.9778	11.025	1001448.0
2010-10-19 17:00:00	AAPL	Stock	11.0286	11.0286	11.0071	11.0071	469140.0
2010-10-19 17:30:00	AAPL	Stock	11.0071	11.0121	10.9925	10.995	1056076.0
2010-10-19 18:00:00	AAPL	Stock	10.9982	11.0536	10.9929	11.0036	1167824.0
2010-10-19 18:30:00	AAPL	Stock	11.0071	11.0071	10.9893	10.9961	410620.0
2010-10-19 19:00:00	AAPL	Stock	10.9896	10.9989	10.9643	10.9643	717528.0
2010-10-19 19:30:00	AAPL	Stock	10.97	10.9725	10.9464	10.9529	1300264.0
2010-10-19 05:00:00	MSFT	Stock	25.29	25.29	25.29	25.29	200.0
2010-10-19 07:00:00	MSFT	Stock	25.32	25.32	25.1	25.2	17250.0
2010-10-19 07:30:00	MSFT	Stock	25.18	25.2	25.01	25.08	60100.0
2010-10-19 08:00:00	MSFT	Stock	25.13	25.27	25.06	25.2	80247.0
2010-10-19 08:30:00	MSFT	Stock	25.2	25.25	25.15	25.2	37065.0
2010-10-19 09:00:00	MSFT	Stock	25.2	25.28	25.11	25.28	178943.0
2010-10-19 09:30:00	MSFT	Stock	25.28	25.37	24.97	25.03	11863470.0
2010-10-19 10:00:00	MSFT	Stock	25.025	25.19	25.0	25.178	5424287.0
2010-10-19 10:30:00	MSFT	Stock	25.172	25.27	25.17	25.185	5394421.0
2010-10-19 11:00:00	MSFT	Stock	25.185	25.19	25.1	25.128	2915354.0
2010-10-19 11:30:00	MSFT	Stock	25.125	25.21	25.122	25.14	3342240.0
2010-10-19 12:00:00	MSFT	Stock	25.145	25.19	25.12	25.122	1873758.0
2010-10-19 12:30:00	MSFT	Stock	25.129	25.15	25.07	25.145	2791403.0
2010-10-19 13:00:00	MSFT	Stock	25.15	25.16	25.09	25.11	1877370.0
2010-10-19 13:30:00	MSFT	Stock	25.12	25.17	25.04	25.07	2596851.0
2010-10-19 14:00:00	MSFT	Stock	25.07	25.07	24.95	25.01	6330226.0
2010-10-19 14:30:00	MSFT	Stock	25.01	25.13	24.991	25.13	3547467.0
2010-10-19 15:00:00	MSFT	Stock	25.12	25.15	25.01	25.01	3951127.0

> showing 50 of 75,728 rows — these rows as CSV

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