PREVIEW / stock_30min / 2011-02-07

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-07.parquet
  size:    1.4 MB
  rows:    76,881
  symbols: 3,537

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
2011-02-07 04:00:00	AAPL	Stock	12.3929	12.4643	12.3929	12.4643	16800.0
2011-02-07 04:30:00	AAPL	Stock	12.4643	12.49	12.4643	12.4736	38920.0
2011-02-07 05:00:00	AAPL	Stock	12.4714	12.4714	12.4714	12.4714	14000.0
2011-02-07 05:30:00	AAPL	Stock	12.4546	12.4575	12.4546	12.4575	5600.0
2011-02-07 06:00:00	AAPL	Stock	12.4554	12.4554	12.4411	12.4411	22400.0
2011-02-07 06:30:00	AAPL	Stock	12.4321	12.4421	12.4321	12.4421	14000.0
2011-02-07 07:00:00	AAPL	Stock	12.4429	12.4464	12.4246	12.4282	123060.0
2011-02-07 07:30:00	AAPL	Stock	12.4282	12.4286	12.4111	12.4214	189000.0
2011-02-07 08:00:00	AAPL	Stock	12.425	12.4589	12.4143	12.4382	2239916.0
2011-02-07 08:30:00	AAPL	Stock	12.4386	12.4589	12.4386	12.45	1279516.0
2011-02-07 09:00:00	AAPL	Stock	12.4496	12.4532	12.4161	12.4246	1338232.0
2011-02-07 09:30:00	AAPL	Stock	12.4221	12.4986	12.4154	12.4982	74079600.0
2011-02-07 10:00:00	AAPL	Stock	12.4982	12.5714	12.495	12.5611	76493620.0
2011-02-07 10:30:00	AAPL	Stock	12.5611	12.5686	12.5461	12.5507	26386892.0
2011-02-07 11:00:00	AAPL	Stock	12.5521	12.6071	12.5511	12.5943	44966768.0
2011-02-07 11:30:00	AAPL	Stock	12.5957	12.6132	12.5854	12.5925	25475744.0
2011-02-07 12:00:00	AAPL	Stock	12.5915	12.5993	12.5779	12.5896	16574096.0
2011-02-07 12:30:00	AAPL	Stock	12.5896	12.6161	12.5868	12.6	23510900.0
2011-02-07 13:00:00	AAPL	Stock	12.6007	12.6139	12.5975	12.61	11439764.0
2011-02-07 13:30:00	AAPL	Stock	12.61	12.6114	12.5957	12.6039	12895400.0
2011-02-07 14:00:00	AAPL	Stock	12.6039	12.6089	12.5814	12.5832	14149940.0
2011-02-07 14:30:00	AAPL	Stock	12.5832	12.5914	12.5311	12.5457	32184488.0
2011-02-07 15:00:00	AAPL	Stock	12.5454	12.5571	12.515	12.5496	34725040.0
2011-02-07 15:30:00	AAPL	Stock	12.5496	12.5729	12.54	12.5668	40146092.0
2011-02-07 16:00:00	AAPL	Stock	12.5671	12.5807	12.551	12.57	38841488.0
2011-02-07 16:30:00	AAPL	Stock	12.5671	12.5711	12.4234	12.5646	557424.0
2011-02-07 17:00:00	AAPL	Stock	12.5657	12.5711	12.5657	12.5711	82600.0
2011-02-07 17:30:00	AAPL	Stock	12.5714	12.5714	12.5686	12.5711	93520.0
2011-02-07 18:00:00	AAPL	Stock	12.5711	12.575	12.5671	12.5725	251356.0
2011-02-07 18:30:00	AAPL	Stock	12.5714	12.5725	12.5682	12.5682	82544.0
2011-02-07 19:00:00	AAPL	Stock	12.5696	12.5725	12.5689	12.5689	91616.0
2011-02-07 19:30:00	AAPL	Stock	12.5725	12.5821	12.5711	12.5804	327236.0
2011-02-07 05:00:00	MSFT	Stock	27.84	27.85	27.84	27.85	800.0
2011-02-07 07:00:00	MSFT	Stock	27.85	27.93	27.85	27.92	3760.0
2011-02-07 07:30:00	MSFT	Stock	27.91	27.91	27.86	27.87	1360.0
2011-02-07 08:00:00	MSFT	Stock	27.87	27.9	27.77	27.89	17318.0
2011-02-07 08:30:00	MSFT	Stock	27.89	27.9	27.85	27.87	15578.0
2011-02-07 09:00:00	MSFT	Stock	27.87	27.89	27.8	27.8	32931.0
2011-02-07 09:30:00	MSFT	Stock	27.8	28.16	27.79	28.16	8456980.0
2011-02-07 10:00:00	MSFT	Stock	28.16	28.23	28.12	28.12	5491997.0
2011-02-07 10:30:00	MSFT	Stock	28.12	28.2	28.08	28.2	4769321.0
2011-02-07 11:00:00	MSFT	Stock	28.195	28.21	28.15	28.184	5744381.0
2011-02-07 11:30:00	MSFT	Stock	28.18	28.25	28.18	28.24	4568008.0
2011-02-07 12:00:00	MSFT	Stock	28.23	28.27	28.18	28.24	3776318.0
2011-02-07 12:30:00	MSFT	Stock	28.24	28.34	28.23	28.243	3966585.0
2011-02-07 13:00:00	MSFT	Stock	28.24	28.32	28.24	28.26	3547478.0
2011-02-07 13:30:00	MSFT	Stock	28.262	28.27	28.21	28.255	3235299.0
2011-02-07 14:00:00	MSFT	Stock	28.26	28.27	28.24	28.26	1991781.0
2011-02-07 14:30:00	MSFT	Stock	28.257	28.26	28.18	28.225	3236434.0
2011-02-07 15:00:00	MSFT	Stock	28.235	28.26	28.19	28.258	4343288.0

> showing 50 of 76,881 rows — these rows as CSV

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