PREVIEW / stock_30min / 2009-03-26

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-03-26.parquet
  size:    1.3 MB
  rows:    71,769
  symbols: 3,307

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-03-26 08:00:00	AAPL	Stock	3.8214	3.8496	3.8214	3.8339	419664.0
2009-03-26 08:30:00	AAPL	Stock	3.8339	3.8457	3.8286	3.8446	825720.0
2009-03-26 09:00:00	AAPL	Stock	3.8464	3.8571	3.8457	3.8571	1200920.0
2009-03-26 09:30:00	AAPL	Stock	3.8511	3.8829	3.8421	3.8693	69271272.0
2009-03-26 10:00:00	AAPL	Stock	3.8696	3.9043	3.8514	3.8521	60613420.0
2009-03-26 10:30:00	AAPL	Stock	3.8525	3.8832	3.8436	3.8829	37219504.0
2009-03-26 11:00:00	AAPL	Stock	3.8829	3.9018	3.8682	3.8782	39850440.0
2009-03-26 11:30:00	AAPL	Stock	3.8779	3.8964	3.8764	3.8864	26369476.0
2009-03-26 12:00:00	AAPL	Stock	3.8871	3.905	3.8793	3.9014	28022960.0
2009-03-26 12:30:00	AAPL	Stock	3.9014	3.9025	3.8696	3.8734	26329436.0
2009-03-26 13:00:00	AAPL	Stock	3.8736	3.9054	3.8725	3.8975	38263764.0
2009-03-26 13:30:00	AAPL	Stock	3.8971	3.9043	3.8821	3.8946	34049904.0
2009-03-26 14:00:00	AAPL	Stock	3.8936	3.9107	3.8932	3.8979	39176368.0
2009-03-26 14:30:00	AAPL	Stock	3.8979	3.9046	3.8811	3.8818	42301420.0
2009-03-26 15:00:00	AAPL	Stock	3.8821	3.9107	3.8786	3.9062	37623096.0
2009-03-26 15:30:00	AAPL	Stock	3.9064	3.9279	3.89	3.9239	89841444.0
2009-03-26 16:00:00	AAPL	Stock	3.9211	3.925	3.8815	3.9107	22596616.0
2009-03-26 16:30:00	AAPL	Stock	3.9107	3.9239	3.8691	3.9057	1857912.0
2009-03-26 17:00:00	AAPL	Stock	3.9057	3.9239	3.9018	3.9196	262500.0
2009-03-26 17:30:00	AAPL	Stock	3.8892	3.9239	3.8892	3.9196	536620.0
2009-03-26 18:00:00	AAPL	Stock	3.9218	3.9239	3.9175	3.9175	1595188.0
2009-03-26 18:30:00	AAPL	Stock	3.9186	3.9211	3.9154	3.9154	91868.0
2009-03-26 19:00:00	AAPL	Stock	3.9164	3.9193	3.9164	3.9193	52388.0
2009-03-26 19:30:00	AAPL	Stock	3.9193	3.9214	3.9143	3.9143	142212.0
2009-03-26 04:00:00	MSFT	Stock	18.0	18.0	18.0	18.0	200.0
2009-03-26 07:00:00	MSFT	Stock	18.19	18.19	18.19	18.19	2000.0
2009-03-26 08:00:00	MSFT	Stock	18.13	18.13	18.0	18.07	10508.0
2009-03-26 08:30:00	MSFT	Stock	18.07	18.08	18.02	18.08	5905.0
2009-03-26 09:00:00	MSFT	Stock	18.08	18.17	18.03	18.17	21561.0
2009-03-26 09:30:00	MSFT	Stock	18.17	18.38	18.12	18.24	6410445.0
2009-03-26 10:00:00	MSFT	Stock	18.24	18.33	18.15	18.15	3745273.0
2009-03-26 10:30:00	MSFT	Stock	18.15	18.26	18.14	18.22	3587273.0
2009-03-26 11:00:00	MSFT	Stock	18.22	18.31	18.2	18.25	4218458.0
2009-03-26 11:30:00	MSFT	Stock	18.25	18.35	18.24	18.33	2895322.0
2009-03-26 12:00:00	MSFT	Stock	18.34	18.36	18.27	18.34	2135392.0
2009-03-26 13:00:00	MSFT	Stock	18.22	18.54	18.22	18.51	6280114.0
2009-03-26 13:30:00	MSFT	Stock	18.508	18.54	18.46	18.51	3537044.0
2009-03-26 14:00:00	MSFT	Stock	18.509	18.59	18.45	18.47	3637363.0
2009-03-26 14:30:00	MSFT	Stock	18.46	18.5	18.37	18.38	3232454.0
2009-03-26 15:00:00	MSFT	Stock	18.37	18.54	18.35	18.53	4809663.0
2009-03-26 15:30:00	MSFT	Stock	18.53	18.88	18.5	18.82	11130973.0
2009-03-26 16:00:00	MSFT	Stock	18.85	18.85	18.413	18.81	5030949.0
2009-03-26 16:30:00	MSFT	Stock	18.79	18.83	18.77	18.77	371623.0
2009-03-26 17:00:00	MSFT	Stock	18.83	18.83	18.74	18.79	30319.0
2009-03-26 17:30:00	MSFT	Stock	18.74	18.83	18.74	18.74	82689.0
2009-03-26 18:00:00	MSFT	Stock	18.78	18.83	18.74	18.74	293911.0
2009-03-26 18:30:00	MSFT	Stock	18.74	18.79	18.74	18.79	670.0
2009-03-26 19:00:00	MSFT	Stock	18.77	18.77	18.74	18.74	1000.0
2009-03-26 19:30:00	MSFT	Stock	18.75	18.8	18.74	18.8	2200.0
2009-03-26 08:00:00	NVDA	Stock	0.2475	0.25	0.2475	0.25	92000.0

> showing 50 of 71,769 rows — these rows as CSV

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