PREVIEW / stock_30min / 2007-10-09

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-09.parquet
  size:    1.2 MB
  rows:    67,774
  symbols: 3,136

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
2007-10-09 05:30:00	AAPL	Stock	6.0157	6.0157	6.0157	6.0157	22400.0
2007-10-09 06:00:00	AAPL	Stock	6.0371	6.0371	6.0179	6.0268	47124.0
2007-10-09 06:30:00	AAPL	Stock	6.0268	6.0339	6.0268	6.0307	84000.0
2007-10-09 07:00:00	AAPL	Stock	6.0346	6.0532	6.0346	6.0393	588980.0
2007-10-09 07:30:00	AAPL	Stock	6.0357	6.0446	6.0357	6.0393	508200.0
2007-10-09 08:00:00	AAPL	Stock	6.0429	6.0704	6.0357	6.0604	6064548.0
2007-10-09 08:30:00	AAPL	Stock	6.0604	6.0839	6.0589	6.0821	6636784.0
2007-10-09 09:00:00	AAPL	Stock	6.0818	6.1032	5.9968	6.0754	16143372.0
2007-10-09 09:30:00	AAPL	Stock	6.0786	6.1111	6.0107	6.0329	208706904.0
2007-10-09 10:00:00	AAPL	Stock	6.0321	6.0332	5.9529	5.9964	158347056.0
2007-10-09 10:30:00	AAPL	Stock	5.9964	6.0039	5.9543	5.9996	80640112.0
2007-10-09 11:00:00	AAPL	Stock	6.0	6.0607	5.975	6.0239	78151696.0
2007-10-09 11:30:00	AAPL	Stock	6.0236	6.0268	5.9993	6.0223	50679076.0
2007-10-09 12:00:00	AAPL	Stock	6.0223	6.0223	6.0039	6.0075	22034740.0
2007-10-09 12:30:00	AAPL	Stock	6.0071	6.0129	5.9796	6.0036	75344472.0
2007-10-09 13:00:00	AAPL	Stock	6.0036	6.0154	5.9732	5.9793	59628800.0
2007-10-09 13:30:00	AAPL	Stock	5.9793	5.9871	5.9571	5.9818	58530080.0
2007-10-09 14:00:00	AAPL	Stock	5.9818	6.0214	5.9743	6.0075	82296368.0
2007-10-09 14:30:00	AAPL	Stock	6.0075	6.0304	6.0007	6.0121	59628268.0
2007-10-09 15:00:00	AAPL	Stock	6.0118	6.0214	5.9964	6.0153	52680628.0
2007-10-09 15:30:00	AAPL	Stock	6.0151	6.0154	5.9825	5.9971	71414840.0
2007-10-09 16:00:00	AAPL	Stock	5.9961	6.0337	5.9857	5.9954	13698972.0
2007-10-09 16:30:00	AAPL	Stock	5.9954	5.9971	5.9882	5.995	1218168.0
2007-10-09 17:00:00	AAPL	Stock	5.9939	5.9971	5.9893	5.995	748692.0
2007-10-09 17:30:00	AAPL	Stock	6.0207	6.0207	5.9839	5.9861	684824.0
2007-10-09 18:00:00	AAPL	Stock	5.995	5.995	5.975	5.9771	767564.0
2007-10-09 18:30:00	AAPL	Stock	5.975	5.9857	5.975	5.9818	263760.0
2007-10-09 19:00:00	AAPL	Stock	5.9804	5.9821	5.9761	5.9768	160496.0
2007-10-09 19:30:00	AAPL	Stock	5.9768	6.0018	5.975	5.9818	349384.0
2007-10-09 07:30:00	MSFT	Stock	30.0	30.0	30.0	30.0	900.0
2007-10-09 08:00:00	MSFT	Stock	29.95	30.11	29.94	30.1	66215.0
2007-10-09 08:30:00	MSFT	Stock	30.11	30.18	30.1	30.15	250252.0
2007-10-09 09:00:00	MSFT	Stock	30.15	30.3	29.84	30.02	1773565.0
2007-10-09 09:30:00	MSFT	Stock	30.02	30.24	30.0	30.23	10914829.0
2007-10-09 10:00:00	MSFT	Stock	30.22	30.38	30.21	30.38	6682594.0
2007-10-09 10:30:00	MSFT	Stock	30.38	30.39	30.27	30.36	4360029.0
2007-10-09 11:00:00	MSFT	Stock	30.36	30.38	30.25	30.29	3603159.0
2007-10-09 11:30:00	MSFT	Stock	30.29	30.32	30.25	30.32	2388016.0
2007-10-09 12:00:00	MSFT	Stock	30.32	30.33	30.25	30.29	1894357.0
2007-10-09 12:30:00	MSFT	Stock	30.289	30.29	30.15	30.183	2943258.0
2007-10-09 13:00:00	MSFT	Stock	30.19	30.23	30.17	30.21	2052876.0
2007-10-09 13:30:00	MSFT	Stock	30.2	30.25	30.16	30.21	1968297.0
2007-10-09 14:00:00	MSFT	Stock	30.21	30.3	30.19	30.23	2999936.0
2007-10-09 14:30:00	MSFT	Stock	30.23	30.26	30.19	30.19	4871555.0
2007-10-09 15:00:00	MSFT	Stock	30.2	30.23	30.11	30.22	5563119.0
2007-10-09 15:30:00	MSFT	Stock	30.22	30.23	30.04	30.1	8089906.0
2007-10-09 16:00:00	MSFT	Stock	30.09	30.31	30.049	30.1	2479207.0
2007-10-09 16:30:00	MSFT	Stock	30.1	30.191	30.08	30.1	451259.0
2007-10-09 17:00:00	MSFT	Stock	30.1	30.206	30.08	30.12	295170.0
2007-10-09 17:30:00	MSFT	Stock	30.28	30.28	30.1	30.1	87968.0

> showing 50 of 67,774 rows — these rows as CSV

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