PREVIEW / stock_30min / 2009-08-27

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-08-27.parquet
  size:    1.3 MB
  rows:    69,955
  symbols: 3,356

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-08-27 06:30:00	AAPL	Stock	5.9993	5.9993	5.9993	5.9993	2800.0
2009-08-27 07:00:00	AAPL	Stock	5.9961	6.0036	5.9929	6.0036	28728.0
2009-08-27 07:30:00	AAPL	Stock	6.0082	6.0268	6.0	6.0036	109200.0
2009-08-27 08:00:00	AAPL	Stock	6.005	6.0268	6.0	6.025	645008.0
2009-08-27 08:30:00	AAPL	Stock	6.0232	6.0411	6.0182	6.0371	1299844.0
2009-08-27 09:00:00	AAPL	Stock	6.0375	6.0389	6.0132	6.025	752892.0
2009-08-27 09:30:00	AAPL	Stock	6.0261	6.0286	5.9268	5.9289	70261128.0
2009-08-27 10:00:00	AAPL	Stock	5.9282	5.9282	5.8868	5.9118	52258052.0
2009-08-27 10:30:00	AAPL	Stock	5.9129	5.9207	5.8986	5.9057	23894584.0
2009-08-27 11:00:00	AAPL	Stock	5.9054	5.9404	5.8971	5.9393	24822868.0
2009-08-27 11:30:00	AAPL	Stock	5.9396	5.9396	5.9194	5.9375	16392936.0
2009-08-27 12:00:00	AAPL	Stock	5.9368	5.9461	5.9325	5.9449	13925828.0
2009-08-27 12:30:00	AAPL	Stock	5.9457	5.9582	5.9434	5.9542	16768024.0
2009-08-27 13:00:00	AAPL	Stock	5.9539	5.9738	5.9532	5.9707	20954752.0
2009-08-27 13:30:00	AAPL	Stock	5.9704	6.0264	5.97	6.0189	45625076.0
2009-08-27 14:00:00	AAPL	Stock	6.0189	6.0414	6.0189	6.0296	34261500.0
2009-08-27 14:30:00	AAPL	Stock	6.03	6.0532	6.0243	6.0268	35401072.0
2009-08-27 15:00:00	AAPL	Stock	6.0268	6.0414	6.0164	6.0186	25622072.0
2009-08-27 15:30:00	AAPL	Stock	6.0186	6.0561	6.0157	6.0514	49390740.0
2009-08-27 16:00:00	AAPL	Stock	6.0514	6.0593	5.9777	6.0564	7166908.0
2009-08-27 16:30:00	AAPL	Stock	6.0564	6.0568	6.0539	6.055	196140.0
2009-08-27 17:00:00	AAPL	Stock	6.055	6.0675	6.0514	6.0675	492072.0
2009-08-27 17:30:00	AAPL	Stock	6.0675	6.0779	6.0614	6.0779	527408.0
2009-08-27 18:00:00	AAPL	Stock	6.0779	6.0836	6.0768	6.08	569408.0
2009-08-27 18:30:00	AAPL	Stock	6.0804	6.0807	6.075	6.0768	89348.0
2009-08-27 19:00:00	AAPL	Stock	6.0768	6.0814	6.0718	6.0779	65380.0
2009-08-27 19:30:00	AAPL	Stock	6.0771	6.0807	6.0725	6.0807	129920.0
2009-08-27 08:00:00	MSFT	Stock	24.46	24.47	24.46	24.47	1563.0
2009-08-27 08:30:00	MSFT	Stock	24.47	24.47	24.43	24.43	2750.0
2009-08-27 09:00:00	MSFT	Stock	24.46	24.51	24.35	24.4	117808.0
2009-08-27 09:30:00	MSFT	Stock	24.41	24.58	24.4	24.43	4196345.0
2009-08-27 10:00:00	MSFT	Stock	24.43	24.43	24.33	24.395	3431053.0
2009-08-27 10:30:00	MSFT	Stock	24.41	24.43	24.3	24.3	2331709.0
2009-08-27 11:00:00	MSFT	Stock	24.3	24.39	24.3	24.34	1726478.0
2009-08-27 11:30:00	MSFT	Stock	24.34	24.39	24.32	24.39	1772161.0
2009-08-27 12:00:00	MSFT	Stock	24.38	24.56	24.38	24.56	2502273.0
2009-08-27 12:30:00	MSFT	Stock	24.56	24.59	24.52	24.58	3106820.0
2009-08-27 13:00:00	MSFT	Stock	24.59	24.63	24.57	24.57	2877329.0
2009-08-27 13:30:00	MSFT	Stock	24.571	24.72	24.56	24.71	3304150.0
2009-08-27 14:00:00	MSFT	Stock	24.71	24.77	24.67	24.72	3884567.0
2009-08-27 14:30:00	MSFT	Stock	24.73	24.78	24.695	24.73	3679032.0
2009-08-27 15:00:00	MSFT	Stock	24.74	24.78	24.63	24.64	2636356.0
2009-08-27 15:30:00	MSFT	Stock	24.65	24.75	24.62	24.7	6262901.0
2009-08-27 16:00:00	MSFT	Stock	24.7	24.75	24.569	24.74	1567651.0
2009-08-27 16:30:00	MSFT	Stock	24.73	24.73	24.67	24.67	1720.0
2009-08-27 17:00:00	MSFT	Stock	24.67	24.79	24.67	24.79	84940.0
2009-08-27 17:30:00	MSFT	Stock	24.79	24.79	24.72	24.76	8900.0
2009-08-27 18:00:00	MSFT	Stock	24.69	24.79	24.69	24.78	17168.0
2009-08-27 18:30:00	MSFT	Stock	24.76	24.79	24.76	24.79	10600.0
2009-08-27 19:00:00	MSFT	Stock	24.75	24.79	24.75	24.79	600.0

> showing 50 of 69,955 rows — these rows as CSV

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