PREVIEW / stock_30min / 2011-05-27

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-27.parquet
  size:    1.4 MB
  rows:    73,753
  symbols: 3,534

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-05-27 05:00:00	AAPL	Stock	11.9732	11.9732	11.9732	11.9732	2800.0
2011-05-27 07:00:00	AAPL	Stock	11.9889	11.9889	11.9889	11.9889	2800.0
2011-05-27 07:30:00	AAPL	Stock	11.9804	11.9804	11.9804	11.9804	5600.0
2011-05-27 08:00:00	AAPL	Stock	11.9714	11.995	11.9714	11.9861	148064.0
2011-05-27 08:30:00	AAPL	Stock	11.9946	12.0	11.9857	11.9857	310492.0
2011-05-27 09:00:00	AAPL	Stock	11.9893	11.9918	11.96	11.96	571172.0
2011-05-27 09:30:00	AAPL	Stock	11.9571	11.9818	11.9396	11.9607	30813216.0
2011-05-27 10:00:00	AAPL	Stock	11.9607	12.015	11.95	12.01	22835372.0
2011-05-27 10:30:00	AAPL	Stock	12.01	12.055	12.0	12.0397	24118360.0
2011-05-27 11:00:00	AAPL	Stock	12.0393	12.0446	12.0268	12.0346	15177848.0
2011-05-27 11:30:00	AAPL	Stock	12.0343	12.0357	12.0211	12.0304	9462432.0
2011-05-27 12:00:00	AAPL	Stock	12.03	12.0314	12.0218	12.0286	9422588.0
2011-05-27 12:30:00	AAPL	Stock	12.0284	12.0368	12.0254	12.0257	6523468.0
2011-05-27 13:00:00	AAPL	Stock	12.0254	12.0296	12.0132	12.0207	8698200.0
2011-05-27 13:30:00	AAPL	Stock	12.0207	12.0221	12.0101	12.0107	7039312.0
2011-05-27 14:00:00	AAPL	Stock	12.0104	12.0189	12.0039	12.008	5873308.0
2011-05-27 14:30:00	AAPL	Stock	12.0079	12.0179	11.9846	11.9882	11656792.0
2011-05-27 15:00:00	AAPL	Stock	11.9896	12.0125	11.9825	12.01	11879532.0
2011-05-27 15:30:00	AAPL	Stock	12.0095	12.0582	12.0032	12.0489	30430064.0
2011-05-27 16:00:00	AAPL	Stock	12.0489	12.0543	11.9946	12.0504	5023004.0
2011-05-27 16:30:00	AAPL	Stock	12.0464	12.0625	12.0097	12.0625	289296.0
2011-05-27 17:00:00	AAPL	Stock	12.05	12.0589	12.0439	12.0439	61712.0
2011-05-27 17:30:00	AAPL	Stock	12.0489	12.0536	12.0486	12.0536	36148.0
2011-05-27 18:00:00	AAPL	Stock	12.0504	12.0504	12.05	12.05	29120.0
2011-05-27 18:30:00	AAPL	Stock	12.0529	12.0536	12.05	12.05	15204.0
2011-05-27 19:00:00	AAPL	Stock	12.05	12.0536	12.05	12.0536	21728.0
2011-05-27 19:30:00	AAPL	Stock	12.0486	12.0518	12.0486	12.0518	14000.0
2011-05-27 08:00:00	MSFT	Stock	24.72	24.78	24.69	24.78	3800.0
2011-05-27 08:30:00	MSFT	Stock	24.78	24.83	24.7	24.76	7000.0
2011-05-27 09:00:00	MSFT	Stock	24.76	24.76	24.62	24.66	80431.0
2011-05-27 09:30:00	MSFT	Stock	24.67	24.78	24.65	24.7	6733328.0
2011-05-27 10:00:00	MSFT	Stock	24.7	24.75	24.65	24.74	6012990.0
2011-05-27 10:30:00	MSFT	Stock	24.74	24.77	24.72	24.77	2407652.0
2011-05-27 11:00:00	MSFT	Stock	24.76	24.81	24.74	24.75	3991059.0
2011-05-27 11:30:00	MSFT	Stock	24.755	24.79	24.73	24.765	1830665.0
2011-05-27 12:00:00	MSFT	Stock	24.765	24.8	24.75	24.795	1955141.0
2011-05-27 12:30:00	MSFT	Stock	24.796	24.88	24.79	24.865	3092871.0
2011-05-27 13:00:00	MSFT	Stock	24.86	24.87	24.81	24.86	3010662.0
2011-05-27 13:30:00	MSFT	Stock	24.86	24.9	24.79	24.89	3313114.0
2011-05-27 14:00:00	MSFT	Stock	24.895	24.9	24.83	24.84	2113737.0
2011-05-27 14:30:00	MSFT	Stock	24.84	24.88	24.79	24.8	3092158.0
2011-05-27 15:00:00	MSFT	Stock	24.81	24.86	24.79	24.835	3127619.0
2011-05-27 15:30:00	MSFT	Stock	24.835	24.84	24.75	24.76	7049539.0
2011-05-27 16:00:00	MSFT	Stock	24.76	24.81	24.19	24.76	1668705.0
2011-05-27 16:30:00	MSFT	Stock	24.838	24.838	24.81	24.815	30750.0
2011-05-27 17:00:00	MSFT	Stock	24.67	24.83	24.67	24.8	5910.0
2011-05-27 17:30:00	MSFT	Stock	24.83	24.83	24.83	24.83	1000.0
2011-05-27 18:00:00	MSFT	Stock	24.76	24.81	24.76	24.81	6796.0
2011-05-27 18:30:00	MSFT	Stock	24.79	24.79	24.79	24.79	1100.0
2011-05-27 19:00:00	MSFT	Stock	24.8	24.81	24.8	24.81	692.0

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

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