PREVIEW / stock_30min / 2009-05-07

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-07.parquet
  size:    1.3 MB
  rows:    73,107
  symbols: 3,336

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-07 04:30:00	AAPL	Stock	4.7429	4.7429	4.7429	4.7429	2800.0
2009-05-07 06:00:00	AAPL	Stock	4.7607	4.7607	4.7607	4.7607	11200.0
2009-05-07 06:30:00	AAPL	Stock	4.7571	4.7571	4.7571	4.7571	5600.0
2009-05-07 07:00:00	AAPL	Stock	4.7586	4.765	4.7586	4.7632	30800.0
2009-05-07 07:30:00	AAPL	Stock	4.7611	4.7611	4.7611	4.7611	2800.0
2009-05-07 08:00:00	AAPL	Stock	4.7593	4.7607	4.7414	4.7546	361200.0
2009-05-07 08:30:00	AAPL	Stock	4.75	4.7536	4.7414	4.7457	550480.0
2009-05-07 09:00:00	AAPL	Stock	4.7457	4.7457	4.7146	4.7264	773192.0
2009-05-07 09:30:00	AAPL	Stock	4.7261	4.7282	4.6175	4.6264	83780228.0
2009-05-07 10:00:00	AAPL	Stock	4.6239	4.63	4.5804	4.5893	67409104.0
2009-05-07 10:30:00	AAPL	Stock	4.59	4.6268	4.5868	4.6139	35916496.0
2009-05-07 11:00:00	AAPL	Stock	4.6157	4.6243	4.5857	4.6021	26943812.0
2009-05-07 11:30:00	AAPL	Stock	4.6029	4.615	4.595	4.6136	17973088.0
2009-05-07 12:00:00	AAPL	Stock	4.6132	4.6132	4.5889	4.5896	16783844.0
2009-05-07 12:30:00	AAPL	Stock	4.5904	4.6047	4.5896	4.6005	12081440.0
2009-05-07 13:00:00	AAPL	Stock	4.6004	4.6011	4.5857	4.5954	22750700.0
2009-05-07 13:30:00	AAPL	Stock	4.5955	4.6007	4.5682	4.5696	35957292.0
2009-05-07 14:00:00	AAPL	Stock	4.57	4.5886	4.5679	4.5832	27335000.0
2009-05-07 14:30:00	AAPL	Stock	4.5825	4.5929	4.5682	4.5918	36611120.0
2009-05-07 15:00:00	AAPL	Stock	4.5918	4.6104	4.5904	4.5975	39786152.0
2009-05-07 15:30:00	AAPL	Stock	4.5979	4.6225	4.5736	4.6086	66078348.0
2009-05-07 16:00:00	AAPL	Stock	4.6075	4.6196	4.5864	4.6093	21562688.0
2009-05-07 16:30:00	AAPL	Stock	4.6114	4.6114	4.6043	4.6046	571900.0
2009-05-07 17:00:00	AAPL	Stock	4.6096	4.625	4.6096	4.625	114800.0
2009-05-07 17:30:00	AAPL	Stock	4.6275	4.6275	4.6168	4.6271	18480.0
2009-05-07 18:00:00	AAPL	Stock	4.6275	4.6357	4.6093	4.6357	1337784.0
2009-05-07 18:30:00	AAPL	Stock	4.6389	4.6393	4.6293	4.6321	41944.0
2009-05-07 19:00:00	AAPL	Stock	4.6357	4.6393	4.6357	4.6393	8400.0
2009-05-07 19:30:00	AAPL	Stock	4.6375	4.6375	4.6321	4.6339	17052.0
2009-05-07 06:00:00	MSFT	Stock	19.85	20.0	19.85	20.0	1263.0
2009-05-07 07:00:00	MSFT	Stock	19.99	19.99	19.99	19.99	200.0
2009-05-07 07:30:00	MSFT	Stock	19.94	19.94	19.9	19.9	2206.0
2009-05-07 08:00:00	MSFT	Stock	19.9	19.95	19.86	19.86	32995.0
2009-05-07 08:30:00	MSFT	Stock	19.9	19.94	19.86	19.87	16487.0
2009-05-07 09:00:00	MSFT	Stock	19.89	19.96	19.86	19.96	60907.0
2009-05-07 09:30:00	MSFT	Stock	19.95	19.99	19.5	19.51	7619196.0
2009-05-07 10:00:00	MSFT	Stock	19.51	19.54	19.27	19.376	9918790.0
2009-05-07 10:30:00	MSFT	Stock	19.38	19.56	19.335	19.44	4741628.0
2009-05-07 11:00:00	MSFT	Stock	19.44	19.5	19.38	19.4	2549797.0
2009-05-07 11:30:00	MSFT	Stock	19.39	19.48	19.37	19.478	2020901.0
2009-05-07 12:00:00	MSFT	Stock	19.47	19.48	19.31	19.36	2204232.0
2009-05-07 12:30:00	MSFT	Stock	19.35	19.445	19.35	19.435	1782438.0
2009-05-07 13:00:00	MSFT	Stock	19.44	19.44	19.33	19.34	2562716.0
2009-05-07 13:30:00	MSFT	Stock	19.34	19.41	19.32	19.395	2567441.0
2009-05-07 14:00:00	MSFT	Stock	19.37	19.4	19.33	19.385	3031067.0
2009-05-07 14:30:00	MSFT	Stock	19.38	19.385	19.2	19.23	4948464.0
2009-05-07 15:00:00	MSFT	Stock	19.24	19.324	19.22	19.26	5400517.0
2009-05-07 15:30:00	MSFT	Stock	19.25	19.46	19.14	19.37	10249184.0
2009-05-07 16:00:00	MSFT	Stock	19.33	19.55	19.292	19.32	5206475.0
2009-05-07 16:30:00	MSFT	Stock	19.39	19.4	19.32	19.32	82104.0

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

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