PREVIEW / stock_30min / 2010-01-08

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-08.parquet
  size:    1.3 MB
  rows:    72,437
  symbols: 3,424

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-01-08 06:00:00	AAPL	Stock	7.5536	7.5536	7.5536	7.5536	2800.0
2010-01-08 06:30:00	AAPL	Stock	7.5529	7.5529	7.5393	7.5393	8400.0
2010-01-08 07:00:00	AAPL	Stock	7.5536	7.5536	7.5536	7.5536	24500.0
2010-01-08 07:30:00	AAPL	Stock	7.5536	7.5543	7.5357	7.5357	75600.0
2010-01-08 08:00:00	AAPL	Stock	7.5421	7.5425	7.5057	7.5357	1000384.0
2010-01-08 08:30:00	AAPL	Stock	7.5357	7.5357	7.4732	7.4957	3386516.0
2010-01-08 09:00:00	AAPL	Stock	7.4964	7.5132	7.4946	7.5118	1781276.0
2010-01-08 09:30:00	AAPL	Stock	7.5107	7.5446	7.4664	7.4936	79408868.0
2010-01-08 10:00:00	AAPL	Stock	7.4939	7.54	7.4924	7.5218	58038092.0
2010-01-08 10:30:00	AAPL	Stock	7.5225	7.5354	7.5057	7.5304	31207652.0
2010-01-08 11:00:00	AAPL	Stock	7.5305	7.561	7.5143	7.5564	34951644.0
2010-01-08 11:30:00	AAPL	Stock	7.5564	7.5639	7.54	7.56	24062136.0
2010-01-08 12:00:00	AAPL	Stock	7.56	7.5614	7.5318	7.5532	20536684.0
2010-01-08 12:30:00	AAPL	Stock	7.5525	7.5582	7.5361	7.5382	18610704.0
2010-01-08 13:00:00	AAPL	Stock	7.5384	7.5443	7.525	7.5332	19814144.0
2010-01-08 13:30:00	AAPL	Stock	7.5345	7.5407	7.5271	7.5312	24063984.0
2010-01-08 14:00:00	AAPL	Stock	7.5307	7.5389	7.5304	7.535	17585960.0
2010-01-08 14:30:00	AAPL	Stock	7.5357	7.5486	7.5279	7.5436	21446236.0
2010-01-08 15:00:00	AAPL	Stock	7.5436	7.5489	7.5296	7.5486	19920544.0
2010-01-08 15:30:00	AAPL	Stock	7.5489	7.5714	7.5386	7.5675	47241096.0
2010-01-08 16:00:00	AAPL	Stock	7.5711	7.5736	7.5104	7.5625	11276244.0
2010-01-08 16:30:00	AAPL	Stock	7.5494	7.565	7.5494	7.5643	126140.0
2010-01-08 17:00:00	AAPL	Stock	7.5564	7.5707	7.5564	7.5693	337176.0
2010-01-08 17:30:00	AAPL	Stock	7.5693	7.5704	7.5686	7.5704	54572.0
2010-01-08 18:00:00	AAPL	Stock	7.5696	7.5707	7.5679	7.5679	395976.0
2010-01-08 18:30:00	AAPL	Stock	7.5679	7.5696	7.5632	7.5632	112000.0
2010-01-08 19:00:00	AAPL	Stock	7.565	7.5657	7.565	7.5657	8400.0
2010-01-08 19:30:00	AAPL	Stock	7.5657	7.5689	7.5657	7.5679	64540.0
2010-01-08 07:00:00	MSFT	Stock	30.39	30.39	30.39	30.39	250.0
2010-01-08 07:30:00	MSFT	Stock	30.41	30.46	30.4	30.4	1650.0
2010-01-08 08:00:00	MSFT	Stock	30.48	30.5	30.48	30.49	5650.0
2010-01-08 08:30:00	MSFT	Stock	30.45	30.47	30.28	30.31	8355.0
2010-01-08 09:00:00	MSFT	Stock	30.32	30.34	30.25	30.28	17204.0
2010-01-08 09:30:00	MSFT	Stock	30.28	30.55	30.24	30.54	7361438.0
2010-01-08 10:00:00	MSFT	Stock	30.54	30.68	30.45	30.655	4680970.0
2010-01-08 10:30:00	MSFT	Stock	30.66	30.68	30.5	30.575	2673642.0
2010-01-08 11:00:00	MSFT	Stock	30.575	30.66	30.51	30.65	2560632.0
2010-01-08 11:30:00	MSFT	Stock	30.645	30.66	30.6	30.65	2831884.0
2010-01-08 12:00:00	MSFT	Stock	30.65	30.79	30.65	30.73	4465819.0
2010-01-08 12:30:00	MSFT	Stock	30.732	30.78	30.45	30.76	2283541.0
2010-01-08 13:00:00	MSFT	Stock	30.76	30.8	30.73	30.8	2252773.0
2010-01-08 13:30:00	MSFT	Stock	30.79	30.83	30.74	30.77	2228707.0
2010-01-08 14:00:00	MSFT	Stock	30.77	30.81	30.75	30.81	1614077.0
2010-01-08 14:30:00	MSFT	Stock	30.81	30.88	30.802	30.85	2629810.0
2010-01-08 15:00:00	MSFT	Stock	30.85	30.86	30.74	30.74	3489570.0
2010-01-08 15:30:00	MSFT	Stock	30.74	30.75	30.61	30.63	6160924.0
2010-01-08 16:00:00	MSFT	Stock	30.66	30.712	30.48	30.66	4128751.0
2010-01-08 16:30:00	MSFT	Stock	30.736	30.736	30.736	30.736	3800.0
2010-01-08 17:00:00	MSFT	Stock	30.62	30.73	30.62	30.73	45024.0
2010-01-08 17:30:00	MSFT	Stock	30.72	30.72	30.72	30.72	221.0

> showing 50 of 72,437 rows — these rows as CSV

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