PREVIEW / stock_30min / 2009-09-18

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-09-18.parquet
  size:    1.4 MB
  rows:    75,110
  symbols: 3,400

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-09-18 06:30:00	AAPL	Stock	6.5714	6.6214	6.5543	6.6143	372344.0
2009-09-18 07:00:00	AAPL	Stock	6.6054	6.6182	6.6036	6.6036	373436.0
2009-09-18 07:30:00	AAPL	Stock	6.5993	6.625	6.5993	6.6125	204680.0
2009-09-18 08:00:00	AAPL	Stock	6.6082	6.6182	6.5936	6.6107	1699208.0
2009-09-18 08:30:00	AAPL	Stock	6.6139	6.6321	6.6139	6.6289	1516312.0
2009-09-18 09:00:00	AAPL	Stock	6.63	6.6389	6.6196	6.6375	3170496.0
2009-09-18 09:30:00	AAPL	Stock	6.6379	6.6625	6.6236	6.6557	174737780.0
2009-09-18 10:00:00	AAPL	Stock	6.6561	6.6575	6.6021	6.6125	69286364.0
2009-09-18 10:30:00	AAPL	Stock	6.6111	6.6368	6.6054	6.6309	41582240.0
2009-09-18 11:00:00	AAPL	Stock	6.63	6.6393	6.6225	6.6225	28974232.0
2009-09-18 11:30:00	AAPL	Stock	6.6236	6.6304	6.6136	6.6143	21289352.0
2009-09-18 12:00:00	AAPL	Stock	6.6146	6.6225	6.6021	6.6057	25549244.0
2009-09-18 12:30:00	AAPL	Stock	6.6061	6.6271	6.6046	6.6236	18282124.0
2009-09-18 13:00:00	AAPL	Stock	6.6236	6.6268	6.6132	6.6206	21087752.0
2009-09-18 13:30:00	AAPL	Stock	6.6207	6.625	6.6164	6.62	15878604.0
2009-09-18 14:00:00	AAPL	Stock	6.6196	6.6339	6.615	6.6164	25034772.0
2009-09-18 14:30:00	AAPL	Stock	6.6161	6.6171	6.6021	6.6029	25620952.0
2009-09-18 15:00:00	AAPL	Stock	6.6029	6.6161	6.6021	6.6136	31198580.0
2009-09-18 15:30:00	AAPL	Stock	6.6136	6.615	6.5986	6.6075	60577468.0
2009-09-18 16:00:00	AAPL	Stock	6.6075	6.6274	6.6036	6.6074	16346624.0
2009-09-18 16:30:00	AAPL	Stock	6.6084	6.6254	6.6057	6.6071	1711584.0
2009-09-18 17:00:00	AAPL	Stock	6.6112	6.63	6.6054	6.6107	1104712.0
2009-09-18 17:30:00	AAPL	Stock	6.6057	6.6071	6.6054	6.6064	103012.0
2009-09-18 18:00:00	AAPL	Stock	6.6064	6.6082	6.6036	6.6068	282352.0
2009-09-18 18:30:00	AAPL	Stock	6.6071	6.6071	6.6032	6.6054	32508.0
2009-09-18 19:00:00	AAPL	Stock	6.6029	6.6036	6.6025	6.6029	31920.0
2009-09-18 19:30:00	AAPL	Stock	6.6104	6.6107	6.6071	6.61	41664.0
2009-09-18 08:00:00	MSFT	Stock	25.35	25.37	25.31	25.33	4785.0
2009-09-18 08:30:00	MSFT	Stock	25.3	25.3	25.3	25.3	4300.0
2009-09-18 09:00:00	MSFT	Stock	25.3	25.48	25.3	25.47	80747.0
2009-09-18 09:30:00	MSFT	Stock	25.46	25.48	25.35	25.39	4937746.0
2009-09-18 10:00:00	MSFT	Stock	25.39	25.4	25.21	25.28	4056296.0
2009-09-18 10:30:00	MSFT	Stock	25.29	25.38	25.26	25.35	3086054.0
2009-09-18 11:00:00	MSFT	Stock	25.35	25.37	25.29	25.3	1979940.0
2009-09-18 11:30:00	MSFT	Stock	25.3	25.31	25.22	25.22	1870214.0
2009-09-18 12:00:00	MSFT	Stock	25.22	25.31	25.2	25.28	1647465.0
2009-09-18 12:30:00	MSFT	Stock	25.28	25.38	25.27	25.38	1249465.0
2009-09-18 13:00:00	MSFT	Stock	25.38	25.4	25.1	25.38	1430032.0
2009-09-18 13:30:00	MSFT	Stock	25.38	25.42	25.35	25.4	1922795.0
2009-09-18 14:00:00	MSFT	Stock	25.4	25.45	25.4	25.42	1547306.0
2009-09-18 14:30:00	MSFT	Stock	25.42	25.43	25.33	25.33	1956871.0
2009-09-18 15:00:00	MSFT	Stock	25.33	25.44	25.33	25.429	2238535.0
2009-09-18 15:30:00	MSFT	Stock	25.42	25.43	25.23	25.26	8784411.0
2009-09-18 16:00:00	MSFT	Stock	25.25	25.375	25.22	25.247	11489639.0
2009-09-18 16:30:00	MSFT	Stock	25.25	25.358	25.24	25.258	3052867.0
2009-09-18 17:00:00	MSFT	Stock	25.3	25.363	25.183	25.26	69410.0
2009-09-18 17:30:00	MSFT	Stock	25.26	25.28	25.23	25.28	11167.0
2009-09-18 19:00:00	MSFT	Stock	25.28	25.39	25.28	25.37	9907.0
2009-09-18 19:30:00	MSFT	Stock	25.26	25.3	25.24	25.26	4176.0
2009-09-18 08:30:00	NVDA	Stock	0.3838	0.3838	0.3838	0.3838	20000.0

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

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