PREVIEW / stock_30min / 2009-05-06

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-06.parquet
  size:    1.4 MB
  rows:    75,217
  symbols: 3,363

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-06 07:00:00	AAPL	Stock	4.7143	4.7143	4.7036	4.7036	39844.0
2009-05-06 07:30:00	AAPL	Stock	4.7061	4.7193	4.7036	4.7107	162484.0
2009-05-06 08:00:00	AAPL	Stock	4.7207	4.7496	4.7143	4.7464	454692.0
2009-05-06 08:30:00	AAPL	Stock	4.7464	4.7682	4.7396	4.7629	1886304.0
2009-05-06 09:00:00	AAPL	Stock	4.7607	4.7675	4.7504	4.7618	685580.0
2009-05-06 09:30:00	AAPL	Stock	4.7643	4.7679	4.7207	4.7343	64231076.0
2009-05-06 10:00:00	AAPL	Stock	4.7357	4.7361	4.6671	4.6675	63329784.0
2009-05-06 10:30:00	AAPL	Stock	4.6671	4.6846	4.6507	4.6704	40262908.0
2009-05-06 11:00:00	AAPL	Stock	4.6707	4.6818	4.6582	4.6657	25674572.0
2009-05-06 11:30:00	AAPL	Stock	4.6646	4.6939	4.6554	4.6939	24955224.0
2009-05-06 12:00:00	AAPL	Stock	4.6946	4.705	4.6857	4.6968	25000304.0
2009-05-06 12:30:00	AAPL	Stock	4.6977	4.7	4.6675	4.675	17866856.0
2009-05-06 13:00:00	AAPL	Stock	4.6746	4.685	4.6646	4.6696	19706120.0
2009-05-06 13:30:00	AAPL	Stock	4.6711	4.7039	4.6657	4.7032	26847884.0
2009-05-06 14:00:00	AAPL	Stock	4.7036	4.7496	4.6975	4.7489	39808580.0
2009-05-06 14:30:00	AAPL	Stock	4.7486	4.7564	4.7196	4.7246	42730100.0
2009-05-06 15:00:00	AAPL	Stock	4.725	4.7349	4.7021	4.7168	25786236.0
2009-05-06 15:30:00	AAPL	Stock	4.7161	4.7386	4.7	4.7318	42051800.0
2009-05-06 16:00:00	AAPL	Stock	4.7364	4.7507	4.6921	4.7375	6415136.0
2009-05-06 16:30:00	AAPL	Stock	4.7321	4.7375	4.725	4.7339	377076.0
2009-05-06 17:00:00	AAPL	Stock	4.7321	4.7321	4.7275	4.7318	76076.0
2009-05-06 17:30:00	AAPL	Stock	4.673	4.7321	4.673	4.7321	70868.0
2009-05-06 18:00:00	AAPL	Stock	4.7329	4.7357	4.7275	4.7321	119084.0
2009-05-06 18:30:00	AAPL	Stock	4.7321	4.7321	4.7286	4.7321	31752.0
2009-05-06 19:00:00	AAPL	Stock	4.7321	4.7343	4.73	4.7343	12768.0
2009-05-06 19:30:00	AAPL	Stock	4.7304	4.7304	4.7304	4.7304	2800.0
2009-05-06 08:00:00	MSFT	Stock	19.86	19.86	19.83	19.85	4432.0
2009-05-06 08:30:00	MSFT	Stock	19.92	20.01	19.79	20.01	134851.0
2009-05-06 09:00:00	MSFT	Stock	20.0	20.1	20.0	20.08	244668.0
2009-05-06 09:30:00	MSFT	Stock	20.06	20.07	19.79	19.936	7054491.0
2009-05-06 10:00:00	MSFT	Stock	19.94	19.955	19.65	19.68	4945286.0
2009-05-06 10:30:00	MSFT	Stock	19.682	19.8	19.61	19.75	4544062.0
2009-05-06 11:00:00	MSFT	Stock	19.76	19.85	19.73	19.82	3381098.0
2009-05-06 11:30:00	MSFT	Stock	19.83	19.93	19.805	19.89	3721971.0
2009-05-06 12:00:00	MSFT	Stock	19.89	19.95	19.84	19.95	2369840.0
2009-05-06 12:30:00	MSFT	Stock	19.95	19.95	19.81	19.82	2686557.0
2009-05-06 13:00:00	MSFT	Stock	19.82	19.87	19.73	19.732	2477828.0
2009-05-06 13:30:00	MSFT	Stock	19.73	19.86	19.71	19.85	3403915.0
2009-05-06 14:00:00	MSFT	Stock	19.85	19.92	19.69	19.78	4411195.0
2009-05-06 14:30:00	MSFT	Stock	19.78	19.8	19.71	19.749	4822687.0
2009-05-06 15:00:00	MSFT	Stock	19.745	19.78	19.65	19.69	4056722.0
2009-05-06 15:30:00	MSFT	Stock	19.69	19.8	19.64	19.79	7771707.0
2009-05-06 16:00:00	MSFT	Stock	19.79	19.911	19.7	19.8	2773313.0
2009-05-06 16:30:00	MSFT	Stock	19.79	19.84	19.74	19.78	78370.0
2009-05-06 17:00:00	MSFT	Stock	19.79	19.79	19.73	19.79	19376.0
2009-05-06 17:30:00	MSFT	Stock	19.91	19.91	19.75	19.75	6361.0
2009-05-06 18:00:00	MSFT	Stock	19.75	19.79	19.75	19.79	16853.0
2009-05-06 18:30:00	MSFT	Stock	19.76	19.76	19.75	19.75	750.0
2009-05-06 19:00:00	MSFT	Stock	19.75	19.79	19.75	19.75	1820.0
2009-05-06 19:30:00	MSFT	Stock	19.77	19.8	19.76	19.76	6400.0

> showing 50 of 75,217 rows — these rows as CSV

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