PREVIEW / stock_30min / 2010-02-01

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-01.parquet
  size:    1.4 MB
  rows:    73,169
  symbols: 3,445

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-02-01 04:00:00	AAPL	Stock	6.8718	6.9007	6.8718	6.9007	16800.0
2010-02-01 04:30:00	AAPL	Stock	6.8932	6.8932	6.8932	6.8932	2800.0
2010-02-01 05:30:00	AAPL	Stock	6.9004	6.9082	6.8939	6.9082	36400.0
2010-02-01 06:00:00	AAPL	Stock	6.9107	6.9107	6.9007	6.9036	33040.0
2010-02-01 06:30:00	AAPL	Stock	6.9096	6.9096	6.9096	6.9096	8400.0
2010-02-01 07:00:00	AAPL	Stock	6.9054	6.9082	6.8839	6.8839	176456.0
2010-02-01 07:30:00	AAPL	Stock	6.8861	6.8979	6.8664	6.8918	508620.0
2010-02-01 08:00:00	AAPL	Stock	6.8761	6.8886	6.8361	6.8454	2702924.0
2010-02-01 08:30:00	AAPL	Stock	6.8457	6.8675	6.8393	6.8396	2097088.0
2010-02-01 09:00:00	AAPL	Stock	6.8404	6.8768	6.8357	6.8732	2322236.0
2010-02-01 09:30:00	AAPL	Stock	6.8707	7.0	6.8321	6.9354	142674224.0
2010-02-01 10:00:00	AAPL	Stock	6.935	6.9768	6.9029	6.9393	96522748.0
2010-02-01 10:30:00	AAPL	Stock	6.9411	6.9535	6.8486	6.8632	96732916.0
2010-02-01 11:00:00	AAPL	Stock	6.8642	6.946	6.8464	6.9311	66731140.0
2010-02-01 11:30:00	AAPL	Stock	6.9307	6.9371	6.8861	6.8911	29968652.0
2010-02-01 12:00:00	AAPL	Stock	6.8911	6.9179	6.885	6.9061	24091368.0
2010-02-01 12:30:00	AAPL	Stock	6.9064	6.9493	6.9	6.9332	30842056.0
2010-02-01 13:00:00	AAPL	Stock	6.9335	6.9571	6.9175	6.9431	25213468.0
2010-02-01 13:30:00	AAPL	Stock	6.9422	6.9554	6.9218	6.9457	28987868.0
2010-02-01 14:00:00	AAPL	Stock	6.9457	6.9489	6.9132	6.9204	25047372.0
2010-02-01 14:30:00	AAPL	Stock	6.9214	6.9375	6.9021	6.9054	28479892.0
2010-02-01 15:00:00	AAPL	Stock	6.9061	6.9282	6.8764	6.9225	48230308.0
2010-02-01 15:30:00	AAPL	Stock	6.9236	6.9539	6.9236	6.9537	74108636.0
2010-02-01 16:00:00	AAPL	Stock	6.9539	6.9575	6.9207	6.9554	12329296.0
2010-02-01 16:30:00	AAPL	Stock	6.9216	6.9546	6.9211	6.9546	796124.0
2010-02-01 17:00:00	AAPL	Stock	6.8953	6.9539	6.8953	6.9471	224084.0
2010-02-01 17:30:00	AAPL	Stock	6.9471	6.9546	6.945	6.95	287588.0
2010-02-01 18:00:00	AAPL	Stock	6.9486	6.9546	6.9482	6.9514	292964.0
2010-02-01 18:30:00	AAPL	Stock	6.9489	6.9554	6.9482	6.9529	107604.0
2010-02-01 19:00:00	AAPL	Stock	6.9536	6.9568	6.9536	6.9568	124516.0
2010-02-01 19:30:00	AAPL	Stock	6.9568	6.9629	6.9554	6.9607	150052.0
2010-02-01 06:30:00	MSFT	Stock	28.38	28.38	28.35	28.35	800.0
2010-02-01 07:00:00	MSFT	Stock	28.37	28.37	28.34	28.35	2950.0
2010-02-01 07:30:00	MSFT	Stock	28.34	28.35	28.34	28.35	1250.0
2010-02-01 08:00:00	MSFT	Stock	28.34	28.5	28.18	28.4	113655.0
2010-02-01 08:30:00	MSFT	Stock	28.4	28.51	28.18	28.46	235712.0
2010-02-01 09:00:00	MSFT	Stock	28.46	28.46	28.18	28.4	38123.0
2010-02-01 09:30:00	MSFT	Stock	28.4	28.455	28.18	28.351	10796325.0
2010-02-01 10:00:00	MSFT	Stock	28.36	28.39	27.96	28.1	15915141.0
2010-02-01 10:30:00	MSFT	Stock	28.11	28.2	27.97	27.975	6942329.0
2010-02-01 11:00:00	MSFT	Stock	27.97	28.11	27.92	28.05	7222039.0
2010-02-01 11:30:00	MSFT	Stock	28.05	28.2	28.03	28.13	4020009.0
2010-02-01 12:00:00	MSFT	Stock	28.13	28.3	28.11	28.29	3743499.0
2010-02-01 12:30:00	MSFT	Stock	28.292	28.37	28.21	28.35	7406891.0
2010-02-01 13:00:00	MSFT	Stock	28.35	28.4	28.27	28.4	2998595.0
2010-02-01 13:30:00	MSFT	Stock	28.392	28.44	28.34	28.4	3140578.0
2010-02-01 14:00:00	MSFT	Stock	28.4	28.44	28.35	28.4	2623773.0
2010-02-01 14:30:00	MSFT	Stock	28.4	28.48	28.37	28.45	3952976.0
2010-02-01 15:00:00	MSFT	Stock	28.45	28.48	28.27	28.275	4311411.0
2010-02-01 15:30:00	MSFT	Stock	28.275	28.43	28.26	28.41	6967721.0

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

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