PREVIEW / stock_30min / 2012-07-03

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-03.parquet
  size:    926 KB
  rows:    45,138
  symbols: 3,440

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
2012-07-03 04:00:00	AAPL	Stock	21.1789	21.2143	21.1789	21.2071	37800.0
2012-07-03 04:30:00	AAPL	Stock	21.2054	21.2379	21.2054	21.2143	58800.0
2012-07-03 05:00:00	AAPL	Stock	21.2111	21.2357	21.2111	21.2357	11200.0
2012-07-03 05:30:00	AAPL	Stock	21.2071	21.2071	21.2071	21.2071	2800.0
2012-07-03 06:00:00	AAPL	Stock	21.2214	21.2214	21.2089	21.2089	8400.0
2012-07-03 06:30:00	AAPL	Stock	21.2143	21.2143	21.2089	21.2143	42420.0
2012-07-03 07:00:00	AAPL	Stock	21.2143	21.2232	21.2054	21.2071	84000.0
2012-07-03 07:30:00	AAPL	Stock	21.2004	21.2486	21.1857	21.2446	360304.0
2012-07-03 08:00:00	AAPL	Stock	21.2321	21.2539	21.1857	21.24	1053808.0
2012-07-03 08:30:00	AAPL	Stock	21.2457	21.2607	21.2371	21.2429	1214444.0
2012-07-03 09:00:00	AAPL	Stock	21.2464	21.2629	21.2418	21.2461	1383816.0
2012-07-03 09:30:00	AAPL	Stock	21.2457	21.3343	21.2143	21.3289	61699372.0
2012-07-03 10:00:00	AAPL	Stock	21.3282	21.3642	21.3086	21.3477	39795028.0
2012-07-03 10:30:00	AAPL	Stock	21.3482	21.4089	21.3357	21.3867	31145268.0
2012-07-03 11:00:00	AAPL	Stock	21.3875	21.4286	21.3814	21.4221	29811544.0
2012-07-03 11:30:00	AAPL	Stock	21.4218	21.4253	21.3768	21.39	23034592.0
2012-07-03 12:00:00	AAPL	Stock	21.3921	21.4104	21.3786	21.3979	14685328.0
2012-07-03 12:30:00	AAPL	Stock	21.3982	21.4136	21.3714	21.4071	30429616.0
2012-07-03 13:00:00	AAPL	Stock	21.4075	21.4143	21.3964	21.4125	4181660.0
2012-07-03 13:30:00	AAPL	Stock	21.4118	21.4125	21.4046	21.4046	293384.0
2012-07-03 14:00:00	AAPL	Stock	21.4075	21.4118	21.4054	21.4118	163996.0
2012-07-03 14:30:00	AAPL	Stock	21.4093	21.4125	21.4046	21.4046	73472.0
2012-07-03 15:00:00	AAPL	Stock	21.405	21.4107	21.405	21.4107	101500.0
2012-07-03 15:30:00	AAPL	Stock	21.4104	21.4104	21.4071	21.4089	44044.0
2012-07-03 16:00:00	AAPL	Stock	21.4064	21.4064	21.4064	21.4064	9800.0
2012-07-03 16:30:00	AAPL	Stock	21.4039	21.4107	21.4036	21.4071	195636.0
2012-07-03 05:30:00	MSFT	Stock	29.99	29.99	29.99	29.99	100.0
2012-07-03 06:30:00	MSFT	Stock	30.06	30.11	30.06	30.11	200.0
2012-07-03 07:00:00	MSFT	Stock	30.11	30.19	30.05	30.06	14192.0
2012-07-03 07:30:00	MSFT	Stock	30.09	30.14	30.07	30.14	3995.0
2012-07-03 08:00:00	MSFT	Stock	30.14	30.34	30.07	30.33	61836.0
2012-07-03 08:30:00	MSFT	Stock	30.33	30.35	30.11	30.18	36748.0
2012-07-03 09:00:00	MSFT	Stock	30.18	30.26	30.12	30.19	73352.0
2012-07-03 09:30:00	MSFT	Stock	30.23	30.46	30.17	30.311	3685056.0
2012-07-03 10:00:00	MSFT	Stock	30.32	30.46	30.312	30.45	2124805.0
2012-07-03 10:30:00	MSFT	Stock	30.455	30.53	30.45	30.49	1997105.0
2012-07-03 11:00:00	MSFT	Stock	30.49	30.64	30.47	30.63	2515826.0
2012-07-03 11:30:00	MSFT	Stock	30.63	30.63	30.54	30.54	2026382.0
2012-07-03 12:00:00	MSFT	Stock	30.55	30.69	30.545	30.68	1827053.0
2012-07-03 12:30:00	MSFT	Stock	30.67	30.76	30.595	30.76	5183068.0
2012-07-03 13:00:00	MSFT	Stock	30.76	30.79	30.528	30.76	1124034.0
2012-07-03 13:30:00	MSFT	Stock	30.76	30.76	30.71	30.72	6354.0
2012-07-03 14:00:00	MSFT	Stock	30.76	30.76	30.71	30.71	18849.0
2012-07-03 14:30:00	MSFT	Stock	30.68	30.71	30.67	30.71	1093.0
2012-07-03 15:00:00	MSFT	Stock	30.71	30.71	30.71	30.71	1750.0
2012-07-03 15:30:00	MSFT	Stock	30.71	30.75	30.71	30.75	600.0
2012-07-03 16:30:00	MSFT	Stock	30.65	30.65	30.64	30.64	495.0
2012-07-03 07:00:00	NVDA	Stock	0.3402	0.3402	0.3402	0.3402	6000.0
2012-07-03 07:30:00	NVDA	Stock	0.3378	0.3378	0.3378	0.3378	8000.0
2012-07-03 08:00:00	NVDA	Stock	0.3375	0.3388	0.3375	0.3375	174000.0

> showing 50 of 45,138 rows — these rows as CSV

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