PREVIEW / stock_30min / 2010-05-12

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-12.parquet
  size:    1.4 MB
  rows:    76,905
  symbols: 3,494

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
2010-05-12 04:00:00	AAPL	Stock	9.1614	9.1786	9.1614	9.1786	16380.0
2010-05-12 04:30:00	AAPL	Stock	9.1786	9.1786	9.1518	9.1518	5600.0
2010-05-12 05:00:00	AAPL	Stock	9.1607	9.1607	9.1607	9.1607	5600.0
2010-05-12 05:30:00	AAPL	Stock	9.1607	9.1821	9.1525	9.1821	11144.0
2010-05-12 06:30:00	AAPL	Stock	9.1871	9.1871	9.1871	9.1871	2800.0
2010-05-12 07:00:00	AAPL	Stock	9.1836	9.2071	9.1768	9.1961	380184.0
2010-05-12 07:30:00	AAPL	Stock	9.1964	9.2429	9.1964	9.2321	656824.0
2010-05-12 08:00:00	AAPL	Stock	9.2293	9.2325	9.2079	9.2243	2285864.0
2010-05-12 08:30:00	AAPL	Stock	9.2286	9.2482	9.2179	9.2357	3456656.0
2010-05-12 09:00:00	AAPL	Stock	9.2361	9.2646	9.2268	9.2529	2640708.0
2010-05-12 09:30:00	AAPL	Stock	9.2496	9.3493	9.2393	9.3393	111686316.0
2010-05-12 10:00:00	AAPL	Stock	9.3389	9.3675	9.3257	9.3639	61516812.0
2010-05-12 10:30:00	AAPL	Stock	9.3625	9.3882	9.35	9.3796	59743124.0
2010-05-12 11:00:00	AAPL	Stock	9.3779	9.3975	9.3489	9.3525	56232232.0
2010-05-12 11:30:00	AAPL	Stock	9.3525	9.3696	9.3182	9.3547	42617736.0
2010-05-12 12:00:00	AAPL	Stock	9.3546	9.3807	9.3536	9.3729	23678228.0
2010-05-12 12:30:00	AAPL	Stock	9.3716	9.3836	9.36	9.3625	24508876.0
2010-05-12 13:00:00	AAPL	Stock	9.3646	9.3679	9.3425	9.3568	29728188.0
2010-05-12 13:30:00	AAPL	Stock	9.3585	9.37	9.3039	9.3153	61525352.0
2010-05-12 14:00:00	AAPL	Stock	9.3136	9.3475	9.3	9.3475	41061076.0
2010-05-12 14:30:00	AAPL	Stock	9.3475	9.365	9.34	9.3564	32996684.0
2010-05-12 15:00:00	AAPL	Stock	9.3564	9.3707	9.3307	9.3346	39398772.0
2010-05-12 15:30:00	AAPL	Stock	9.3343	9.36	9.3218	9.36	48554240.0
2010-05-12 16:00:00	AAPL	Stock	9.3604	9.3643	9.1614	9.3536	7696220.0
2010-05-12 16:30:00	AAPL	Stock	9.3604	9.3604	9.3397	9.3489	1333024.0
2010-05-12 17:00:00	AAPL	Stock	9.3489	9.3536	9.3446	9.3536	155260.0
2010-05-12 17:30:00	AAPL	Stock	9.3536	9.3571	9.3521	9.3571	117908.0
2010-05-12 18:00:00	AAPL	Stock	9.3586	9.3643	9.3568	9.3568	219436.0
2010-05-12 18:30:00	AAPL	Stock	9.3579	9.3618	9.3525	9.3571	207144.0
2010-05-12 19:00:00	AAPL	Stock	9.3536	9.3571	9.3536	9.3536	64792.0
2010-05-12 19:30:00	AAPL	Stock	9.3571	9.3643	9.3571	9.3643	227360.0
2010-05-12 07:00:00	MSFT	Stock	28.97	28.99	28.97	28.98	2800.0
2010-05-12 07:30:00	MSFT	Stock	28.97	28.98	28.97	28.98	1909.0
2010-05-12 08:00:00	MSFT	Stock	29.01	29.08	28.97	29.07	17100.0
2010-05-12 08:30:00	MSFT	Stock	29.08	29.17	29.02	29.16	56938.0
2010-05-12 09:00:00	MSFT	Stock	29.16	29.2	28.99	28.99	93322.0
2010-05-12 09:30:00	MSFT	Stock	28.99	29.23	28.92	29.19	4093067.0
2010-05-12 10:00:00	MSFT	Stock	29.198	29.3	29.08	29.25	4188305.0
2010-05-12 10:30:00	MSFT	Stock	29.252	29.35	29.14	29.3	3643665.0
2010-05-12 11:00:00	MSFT	Stock	29.3	29.38	29.18	29.22	3525148.0
2010-05-12 11:30:00	MSFT	Stock	29.21	29.34	29.189	29.33	4123605.0
2010-05-12 12:00:00	MSFT	Stock	29.33	29.35	29.2	29.299	1588675.0
2010-05-12 12:30:00	MSFT	Stock	29.29	29.4	29.26	29.39	2222896.0
2010-05-12 13:00:00	MSFT	Stock	29.382	29.44	29.31	29.42	3123074.0
2010-05-12 13:30:00	MSFT	Stock	29.42	29.47	29.36	29.37	2838253.0
2010-05-12 14:00:00	MSFT	Stock	29.37	29.49	29.36	29.48	2349244.0
2010-05-12 14:30:00	MSFT	Stock	29.49	29.5	29.4	29.472	1922853.0
2010-05-12 15:00:00	MSFT	Stock	29.475	29.58	29.44	29.517	3645299.0
2010-05-12 15:30:00	MSFT	Stock	29.51	29.54	29.42	29.44	7093677.0
2010-05-12 16:00:00	MSFT	Stock	29.44	29.5	28.87	29.44	1743266.0

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

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