PREVIEW / stock_30min / 2009-05-26

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-26.parquet
  size:    1.3 MB
  rows:    73,181
  symbols: 3,353

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
2009-05-26 04:00:00	AAPL	Stock	4.3843	4.3843	4.3843	4.3843	2800.0
2009-05-26 05:00:00	AAPL	Stock	4.3836	4.4464	4.3836	4.4286	157556.0
2009-05-26 06:00:00	AAPL	Stock	4.4536	4.4561	4.4536	4.4561	21000.0
2009-05-26 06:30:00	AAPL	Stock	4.4643	4.4643	4.4554	4.4643	331800.0
2009-05-26 07:00:00	AAPL	Stock	4.4643	4.4839	4.4643	4.4782	269500.0
2009-05-26 07:30:00	AAPL	Stock	4.475	4.4804	4.4664	4.4714	729204.0
2009-05-26 08:00:00	AAPL	Stock	4.4696	4.4918	4.4661	4.4736	2716028.0
2009-05-26 08:30:00	AAPL	Stock	4.4743	4.4743	4.4571	4.465	1602944.0
2009-05-26 09:00:00	AAPL	Stock	4.4654	4.47	4.4511	4.4557	1636376.0
2009-05-26 09:30:00	AAPL	Stock	4.4557	4.5621	4.4471	4.5518	112183876.0
2009-05-26 10:00:00	AAPL	Stock	4.5518	4.6118	4.5505	4.5971	83744724.0
2009-05-26 10:30:00	AAPL	Stock	4.5971	4.6179	4.5925	4.6093	40766684.0
2009-05-26 11:00:00	AAPL	Stock	4.6093	4.625	4.6043	4.6225	37141132.0
2009-05-26 11:30:00	AAPL	Stock	4.6229	4.6368	4.6143	4.6196	37042432.0
2009-05-26 12:00:00	AAPL	Stock	4.6196	4.6346	4.6114	4.6318	26515160.0
2009-05-26 12:30:00	AAPL	Stock	4.6311	4.6393	4.6236	4.6364	21708904.0
2009-05-26 13:00:00	AAPL	Stock	4.6368	4.6568	4.6343	4.6564	36286740.0
2009-05-26 13:30:00	AAPL	Stock	4.6564	4.6718	4.6489	4.6696	28486612.0
2009-05-26 14:00:00	AAPL	Stock	4.67	4.6725	4.6461	4.6493	32355400.0
2009-05-26 14:30:00	AAPL	Stock	4.6486	4.6652	4.6432	4.6446	31844568.0
2009-05-26 15:00:00	AAPL	Stock	4.6444	4.6625	4.6404	4.6468	43076320.0
2009-05-26 15:30:00	AAPL	Stock	4.6464	4.6711	4.6432	4.6696	76116096.0
2009-05-26 16:00:00	AAPL	Stock	4.6696	4.6743	4.6117	4.6707	15213100.0
2009-05-26 16:30:00	AAPL	Stock	4.6689	4.6736	4.6686	4.6736	636636.0
2009-05-26 17:00:00	AAPL	Stock	4.6732	4.6786	4.6732	4.6757	819896.0
2009-05-26 17:30:00	AAPL	Stock	4.6307	4.6779	4.6307	4.6754	586852.0
2009-05-26 18:00:00	AAPL	Stock	4.6707	4.6836	4.6707	4.6825	2388148.0
2009-05-26 18:30:00	AAPL	Stock	4.6821	4.6871	4.6807	4.6839	337092.0
2009-05-26 19:00:00	AAPL	Stock	4.6832	4.6871	4.6832	4.6871	168700.0
2009-05-26 19:30:00	AAPL	Stock	4.6889	4.7	4.6857	4.6964	880460.0
2009-05-26 07:00:00	MSFT	Stock	19.7	19.79	19.7	19.79	1400.0
2009-05-26 08:00:00	MSFT	Stock	19.75	19.82	19.75	19.75	4387.0
2009-05-26 08:30:00	MSFT	Stock	19.75	19.75	19.65	19.66	7623.0
2009-05-26 09:00:00	MSFT	Stock	19.63	19.65	19.43	19.49	93256.0
2009-05-26 09:30:00	MSFT	Stock	19.52	19.99	19.45	19.98	5362591.0
2009-05-26 10:00:00	MSFT	Stock	20.0	20.25	19.98	20.17	6356020.0
2009-05-26 10:30:00	MSFT	Stock	20.16	20.29	20.14	20.19	3909194.0
2009-05-26 11:00:00	MSFT	Stock	20.2	20.26	20.15	20.19	2402126.0
2009-05-26 11:30:00	MSFT	Stock	20.18	20.35	20.18	20.3	2892372.0
2009-05-26 12:00:00	MSFT	Stock	20.3	20.37	20.26	20.352	2158292.0
2009-05-26 12:30:00	MSFT	Stock	20.35	20.421	20.32	20.39	1972558.0
2009-05-26 13:00:00	MSFT	Stock	20.39	20.45	20.38	20.39	2270340.0
2009-05-26 13:30:00	MSFT	Stock	20.39	20.44	20.33	20.42	1510382.0
2009-05-26 14:00:00	MSFT	Stock	20.43	20.45	20.32	20.35	2024179.0
2009-05-26 14:30:00	MSFT	Stock	20.35	20.44	20.33	20.35	1702651.0
2009-05-26 15:00:00	MSFT	Stock	20.36	20.4	20.29	20.35	2746990.0
2009-05-26 15:30:00	MSFT	Stock	20.36	20.4	20.22	20.35	6128161.0
2009-05-26 16:00:00	MSFT	Stock	20.36	20.368	20.213	20.254	2526362.0
2009-05-26 16:30:00	MSFT	Stock	20.34	20.34	20.32	20.33	82194.0
2009-05-26 17:00:00	MSFT	Stock	20.31	20.33	20.31	20.33	200.0

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

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