PREVIEW / stock_30min / 2012-04-12

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-12.parquet
  size:    1.4 MB
  rows:    76,075
  symbols: 3,515

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-04-12 04:00:00	AAPL	Stock	22.4643	22.4643	22.3964	22.3964	28000.0
2012-04-12 04:30:00	AAPL	Stock	22.4282	22.4286	22.4196	22.4214	79800.0
2012-04-12 05:00:00	AAPL	Stock	22.4214	22.4282	22.3968	22.3968	42000.0
2012-04-12 05:30:00	AAPL	Stock	22.3968	22.4332	22.3968	22.4332	16800.0
2012-04-12 06:00:00	AAPL	Stock	22.4089	22.41	22.4089	22.41	11200.0
2012-04-12 06:30:00	AAPL	Stock	22.4375	22.45	22.4289	22.45	19600.0
2012-04-12 07:00:00	AAPL	Stock	22.4429	22.4621	22.375	22.4089	370440.0
2012-04-12 07:30:00	AAPL	Stock	22.4339	22.4857	22.4336	22.4732	377076.0
2012-04-12 08:00:00	AAPL	Stock	22.4786	22.4964	22.3889	22.4054	1804768.0
2012-04-12 08:30:00	AAPL	Stock	22.4086	22.4086	22.2218	22.2971	3698100.0
2012-04-12 09:00:00	AAPL	Stock	22.2968	22.3389	22.2768	22.3214	1610784.0
2012-04-12 09:30:00	AAPL	Stock	22.3214	22.4896	22.1936	22.4293	96038936.0
2012-04-12 10:00:00	AAPL	Stock	22.4311	22.4875	22.3579	22.4636	57018220.0
2012-04-12 10:30:00	AAPL	Stock	22.4645	22.5475	22.4411	22.4714	50463560.0
2012-04-12 11:00:00	AAPL	Stock	22.475	22.4982	22.3682	22.3799	35188020.0
2012-04-12 11:30:00	AAPL	Stock	22.3761	22.4129	22.3304	22.4004	34283452.0
2012-04-12 12:00:00	AAPL	Stock	22.3968	22.4196	22.3293	22.3593	19414220.0
2012-04-12 12:30:00	AAPL	Stock	22.358	22.3818	22.3164	22.3429	24363556.0
2012-04-12 13:00:00	AAPL	Stock	22.3429	22.3489	22.2143	22.2265	39686416.0
2012-04-12 13:30:00	AAPL	Stock	22.225	22.2571	22.1682	22.2064	64159424.0
2012-04-12 14:00:00	AAPL	Stock	22.2057	22.2536	22.2014	22.2104	31022740.0
2012-04-12 14:30:00	AAPL	Stock	22.2121	22.3214	22.1607	22.2671	45513076.0
2012-04-12 15:00:00	AAPL	Stock	22.267	22.2839	22.1836	22.207	36367548.0
2012-04-12 15:30:00	AAPL	Stock	22.2075	22.2889	22.1779	22.2339	56554736.0
2012-04-12 16:00:00	AAPL	Stock	22.2343	22.438	22.2071	22.2214	9849560.0
2012-04-12 16:30:00	AAPL	Stock	22.2204	22.2418	22.2043	22.2418	1826020.0
2012-04-12 17:00:00	AAPL	Stock	22.2343	22.2418	22.1964	22.2054	647108.0
2012-04-12 17:30:00	AAPL	Stock	22.2018	22.2064	22.1918	22.2036	275996.0
2012-04-12 18:00:00	AAPL	Stock	22.2082	22.2196	22.2036	22.2071	255248.0
2012-04-12 18:30:00	AAPL	Stock	22.2104	22.2104	22.1786	22.1839	465836.0
2012-04-12 19:00:00	AAPL	Stock	22.1796	22.1964	22.1643	22.1882	175812.0
2012-04-12 19:30:00	AAPL	Stock	22.1871	22.2046	22.1786	22.1936	376124.0
2012-04-12 07:00:00	MSFT	Stock	30.45	30.5	30.45	30.5	3200.0
2012-04-12 07:30:00	MSFT	Stock	30.5	30.54	30.5	30.5	5800.0
2012-04-12 08:00:00	MSFT	Stock	30.52	30.52	30.48	30.5	5495.0
2012-04-12 08:30:00	MSFT	Stock	30.48	30.51	30.42	30.48	9792.0
2012-04-12 09:00:00	MSFT	Stock	30.48	30.5	30.34	30.49	32377.0
2012-04-12 09:30:00	MSFT	Stock	30.49	30.7	30.42	30.64	4785314.0
2012-04-12 10:00:00	MSFT	Stock	30.64	30.77	30.53	30.73	4025977.0
2012-04-12 10:30:00	MSFT	Stock	30.722	30.98	30.72	30.88	3159810.0
2012-04-12 11:00:00	MSFT	Stock	30.88	30.93	30.83	30.895	2852766.0
2012-04-12 11:30:00	MSFT	Stock	30.895	30.96	30.86	30.95	1915580.0
2012-04-12 12:00:00	MSFT	Stock	30.96	30.97	30.88	30.936	1531250.0
2012-04-12 12:30:00	MSFT	Stock	30.935	30.99	30.93	30.935	2572625.0
2012-04-12 13:00:00	MSFT	Stock	30.93	30.94	30.89	30.93	1529935.0
2012-04-12 13:30:00	MSFT	Stock	30.93	30.99	30.92	30.96	1936137.0
2012-04-12 14:00:00	MSFT	Stock	30.95	31.03	30.94	31.001	1947993.0
2012-04-12 14:30:00	MSFT	Stock	31.01	31.03	30.97	30.995	1574814.0
2012-04-12 15:00:00	MSFT	Stock	30.995	31.02	30.98	30.99	1426001.0
2012-04-12 15:30:00	MSFT	Stock	30.99	31.04	30.97	30.99	6467917.0

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

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