PREVIEW / stock_30min / 2012-05-24

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-24.parquet
  size:    1.4 MB
  rows:    74,697
  symbols: 3,542

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-05-24 04:00:00	AAPL	Stock	20.3796	20.3796	20.3214	20.3214	32704.0
2012-05-24 04:30:00	AAPL	Stock	20.3214	20.3214	20.3214	20.3214	11900.0
2012-05-24 05:30:00	AAPL	Stock	20.4196	20.4196	20.4196	20.4196	14000.0
2012-05-24 06:00:00	AAPL	Stock	20.4504	20.4643	20.4504	20.4643	37380.0
2012-05-24 06:30:00	AAPL	Stock	20.4643	20.5	20.4643	20.4893	81508.0
2012-05-24 07:00:00	AAPL	Stock	20.4889	20.5325	20.4796	20.4911	327964.0
2012-05-24 07:30:00	AAPL	Stock	20.4911	20.4996	20.4643	20.4786	401240.0
2012-05-24 08:00:00	AAPL	Stock	20.4818	20.5339	20.4511	20.4729	1656312.0
2012-05-24 08:30:00	AAPL	Stock	20.4725	20.505	20.3804	20.5018	3544940.0
2012-05-24 09:00:00	AAPL	Stock	20.5054	20.57	20.4725	20.57	3594556.0
2012-05-24 09:30:00	AAPL	Stock	20.5668	20.5893	20.2161	20.3245	102556804.0
2012-05-24 10:00:00	AAPL	Stock	20.3225	20.4443	20.3075	20.3988	54450620.0
2012-05-24 10:30:00	AAPL	Stock	20.3975	20.4743	20.3646	20.4029	41187804.0
2012-05-24 11:00:00	AAPL	Stock	20.4027	20.4404	20.3714	20.3761	21287028.0
2012-05-24 11:30:00	AAPL	Stock	20.3821	20.3825	20.2357	20.2689	33878908.0
2012-05-24 12:00:00	AAPL	Stock	20.2689	20.3129	20.1964	20.2782	25281760.0
2012-05-24 12:30:00	AAPL	Stock	20.2821	20.3446	20.2236	20.2604	17067792.0
2012-05-24 13:00:00	AAPL	Stock	20.2604	20.3411	20.2393	20.2559	17377276.0
2012-05-24 13:30:00	AAPL	Stock	20.25	20.2954	20.1979	20.2	16457420.0
2012-05-24 14:00:00	AAPL	Stock	20.2071	20.2621	20.1293	20.2036	26326636.0
2012-05-24 14:30:00	AAPL	Stock	20.1976	20.2382	20.0893	20.0971	25889360.0
2012-05-24 15:00:00	AAPL	Stock	20.0971	20.2121	20.0439	20.1739	39172252.0
2012-05-24 15:30:00	AAPL	Stock	20.18	20.2393	20.1161	20.1875	47987688.0
2012-05-24 16:00:00	AAPL	Stock	20.19	20.3001	20.1695	20.2214	8233400.0
2012-05-24 16:30:00	AAPL	Stock	20.2986	20.3714	20.1778	20.2125	1063692.0
2012-05-24 17:00:00	AAPL	Stock	20.2132	20.2132	20.19	20.2057	223804.0
2012-05-24 17:30:00	AAPL	Stock	20.2118	20.2214	20.2089	20.2214	81284.0
2012-05-24 18:00:00	AAPL	Stock	20.2232	20.2232	20.1936	20.1964	93128.0
2012-05-24 18:30:00	AAPL	Stock	20.1964	20.2054	20.1957	20.2054	43120.0
2012-05-24 19:00:00	AAPL	Stock	20.1989	20.1989	20.1429	20.1607	416696.0
2012-05-24 19:30:00	AAPL	Stock	20.1696	20.2211	20.1607	20.2089	112196.0
2012-05-24 06:00:00	MSFT	Stock	29.2	29.2	29.2	29.2	100.0
2012-05-24 06:30:00	MSFT	Stock	29.25	29.25	29.25	29.25	100.0
2012-05-24 07:00:00	MSFT	Stock	29.25	29.25	29.25	29.25	2800.0
2012-05-24 07:30:00	MSFT	Stock	29.2	29.2	29.2	29.2	2000.0
2012-05-24 08:00:00	MSFT	Stock	29.16	29.2	29.13	29.17	9853.0
2012-05-24 08:30:00	MSFT	Stock	29.15	29.2	29.12	29.17	31225.0
2012-05-24 09:00:00	MSFT	Stock	29.18	29.22	29.09	29.15	28901.0
2012-05-24 09:30:00	MSFT	Stock	29.16	29.24	28.92	28.92	5963210.0
2012-05-24 10:00:00	MSFT	Stock	28.92	28.99	28.868	28.932	6321527.0
2012-05-24 10:30:00	MSFT	Stock	28.93	29.11	28.92	29.09	4464395.0
2012-05-24 11:00:00	MSFT	Stock	29.085	29.3	29.035	29.23	3149877.0
2012-05-24 11:30:00	MSFT	Stock	29.23	29.24	29.06	29.11	2529559.0
2012-05-24 12:00:00	MSFT	Stock	29.11	29.12	28.97	29.02	2083202.0
2012-05-24 12:30:00	MSFT	Stock	29.02	29.09	29.0	29.02	2632572.0
2012-05-24 13:00:00	MSFT	Stock	29.02	29.1	28.95	28.98	1656882.0
2012-05-24 13:30:00	MSFT	Stock	28.97	29.0	28.9	28.908	1891410.0
2012-05-24 14:00:00	MSFT	Stock	28.91	28.96	28.87	28.9	2847297.0
2012-05-24 14:30:00	MSFT	Stock	28.91	28.96	28.76	28.778	4207008.0
2012-05-24 15:00:00	MSFT	Stock	28.78	28.99	28.76	28.92	4027405.0

> showing 50 of 74,697 rows — these rows as CSV

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