PREVIEW / stock_30min / 2007-09-20

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-09-20.parquet
  size:    1.1 MB
  rows:    64,340
  symbols: 3,123

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
2007-09-20 09:30:00	AAPL	Stock	5.0054	5.0154	4.9757	4.9939	94325924.0
2007-09-20 10:00:00	AAPL	Stock	4.9943	5.0339	4.9896	5.0096	80256064.0
2007-09-20 10:30:00	AAPL	Stock	5.0093	5.0357	5.0018	5.0279	46254488.0
2007-09-20 11:00:00	AAPL	Stock	5.0282	5.0639	5.0196	5.0507	59402140.0
2007-09-20 11:30:00	AAPL	Stock	5.05	5.0529	5.0179	5.0357	38317272.0
2007-09-20 12:00:00	AAPL	Stock	5.0361	5.0479	5.0282	5.0313	35646324.0
2007-09-20 12:30:00	AAPL	Stock	5.0304	5.04	5.025	5.0357	20515852.0
2007-09-20 13:00:00	AAPL	Stock	5.0354	5.0371	5.0157	5.0189	19584824.0
2007-09-20 13:30:00	AAPL	Stock	5.0186	5.03	5.0111	5.0201	27419168.0
2007-09-20 14:00:00	AAPL	Stock	5.02	5.0282	5.0093	5.0171	38985688.0
2007-09-20 14:30:00	AAPL	Stock	5.0168	5.0179	4.9989	5.0079	39979576.0
2007-09-20 15:00:00	AAPL	Stock	5.0082	5.0114	4.9961	5.0086	39981732.0
2007-09-20 15:30:00	AAPL	Stock	5.0071	5.0168	5.0014	5.0093	44131528.0
2007-09-20 16:00:00	AAPL	Stock	5.01	5.0111	5.009	5.0111	8662892.0
2007-09-20 09:30:00	MSFT	Stock	28.44	28.58	28.42	28.47	5993974.0
2007-09-20 10:00:00	MSFT	Stock	28.46	28.52	28.42	28.445	4913487.0
2007-09-20 10:30:00	MSFT	Stock	28.45	28.46	28.4	28.43	3674429.0
2007-09-20 11:00:00	MSFT	Stock	28.43	28.44	28.38	28.41	4581921.0
2007-09-20 11:30:00	MSFT	Stock	28.4	28.43	28.35	28.4	3887916.0
2007-09-20 12:00:00	MSFT	Stock	28.4	28.46	28.36	28.37	3285096.0
2007-09-20 12:30:00	MSFT	Stock	28.36	28.39	28.35	28.36	2980474.0
2007-09-20 13:00:00	MSFT	Stock	28.37	28.38	28.34	28.375	3004876.0
2007-09-20 13:30:00	MSFT	Stock	28.371	28.41	28.34	28.4	2937510.0
2007-09-20 14:00:00	MSFT	Stock	28.395	28.42	28.38	28.38	3652194.0
2007-09-20 14:30:00	MSFT	Stock	28.39	28.45	28.38	28.43	3417420.0
2007-09-20 15:00:00	MSFT	Stock	28.43	28.45	28.4	28.44	4157887.0
2007-09-20 15:30:00	MSFT	Stock	28.44	28.5	28.41	28.42	6370699.0
2007-09-20 16:00:00	MSFT	Stock	28.42	28.44	28.42	28.42	1248656.0
2007-09-20 08:00:00	NVDA	Stock	0.8512	0.8512	0.85	0.85	97800.0
2007-09-20 08:30:00	NVDA	Stock	0.8588	0.8588	0.8588	0.8588	8000.0
2007-09-20 09:00:00	NVDA	Stock	0.8592	0.8625	0.8588	0.859	140000.0
2007-09-20 09:30:00	NVDA	Stock	0.8595	0.8688	0.8445	0.8515	52561800.0
2007-09-20 10:00:00	NVDA	Stock	0.8515	0.8592	0.8488	0.8512	29541560.0
2007-09-20 10:30:00	NVDA	Stock	0.8515	0.8568	0.8482	0.8525	16786440.0
2007-09-20 11:00:00	NVDA	Stock	0.8523	0.8552	0.8505	0.852	20342920.0
2007-09-20 11:30:00	NVDA	Stock	0.852	0.8525	0.846	0.85	14803600.0
2007-09-20 12:00:00	NVDA	Stock	0.85	0.8555	0.8485	0.8523	24796520.0
2007-09-20 12:30:00	NVDA	Stock	0.8523	0.8562	0.851	0.8548	11679480.0
2007-09-20 13:00:00	NVDA	Stock	0.8548	0.8562	0.8518	0.8535	11953800.0
2007-09-20 13:30:00	NVDA	Stock	0.8538	0.8552	0.8518	0.8545	14613440.0
2007-09-20 14:00:00	NVDA	Stock	0.8548	0.8562	0.8538	0.855	14004800.0
2007-09-20 14:30:00	NVDA	Stock	0.8548	0.8562	0.853	0.855	20553280.0
2007-09-20 15:00:00	NVDA	Stock	0.855	0.8585	0.8532	0.8572	25664800.0
2007-09-20 15:30:00	NVDA	Stock	0.8572	0.8572	0.853	0.854	33247600.0
2007-09-20 16:00:00	NVDA	Stock	0.854	0.8565	0.854	0.8562	7258000.0
2007-09-20 16:30:00	NVDA	Stock	0.8562	0.8562	0.8562	0.8562	20080.0
2007-09-20 17:30:00	NVDA	Stock	0.8562	0.8562	0.8562	0.8562	48000.0
2007-09-20 18:00:00	NVDA	Stock	0.8565	0.8565	0.8565	0.8565	7080.0
2007-09-20 19:30:00	NVDA	Stock	0.8538	0.8538	0.8538	0.8538	43040.0
2007-09-20 06:30:00	AMZN	Stock	4.4725	4.4725	4.47	4.47	10000.0

> showing 50 of 64,340 rows — these rows as CSV

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