PREVIEW / stock_30min / 2010-03-08

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-08.parquet
  size:    1.4 MB
  rows:    73,493
  symbols: 3,474

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
2010-03-08 04:00:00	AAPL	Stock	7.8268	7.8339	7.8268	7.8339	11200.0
2010-03-08 04:30:00	AAPL	Stock	7.8386	7.8539	7.8386	7.8539	14000.0
2010-03-08 05:00:00	AAPL	Stock	7.8411	7.8464	7.8411	7.8464	11200.0
2010-03-08 07:00:00	AAPL	Stock	7.8329	7.8411	7.8243	7.8389	81340.0
2010-03-08 07:30:00	AAPL	Stock	7.8425	7.8464	7.8357	7.8464	245532.0
2010-03-08 08:00:00	AAPL	Stock	7.8446	7.8839	7.8429	7.8839	4455780.0
2010-03-08 08:30:00	AAPL	Stock	7.8857	7.8893	7.8571	7.8593	2862580.0
2010-03-08 09:00:00	AAPL	Stock	7.8579	7.8693	7.8525	7.8571	1945636.0
2010-03-08 09:30:00	AAPL	Stock	7.8579	7.8604	7.7946	7.8018	111394780.0
2010-03-08 10:00:00	AAPL	Stock	7.8007	7.8389	7.7986	7.8236	42728532.0
2010-03-08 10:30:00	AAPL	Stock	7.8237	7.8511	7.8125	7.8482	34655768.0
2010-03-08 11:00:00	AAPL	Stock	7.8489	7.8514	7.8168	7.8179	31810436.0
2010-03-08 11:30:00	AAPL	Stock	7.8179	7.8421	7.8171	7.8322	23374932.0
2010-03-08 12:00:00	AAPL	Stock	7.8318	7.8357	7.8179	7.8314	20428940.0
2010-03-08 12:30:00	AAPL	Stock	7.8314	7.8354	7.8214	7.8321	16585744.0
2010-03-08 13:00:00	AAPL	Stock	7.8318	7.8364	7.8268	7.8321	13331416.0
2010-03-08 13:30:00	AAPL	Stock	7.8329	7.84	7.8286	7.8336	16367484.0
2010-03-08 14:00:00	AAPL	Stock	7.8336	7.8357	7.8179	7.8225	18671464.0
2010-03-08 14:30:00	AAPL	Stock	7.8225	7.8329	7.8222	7.8246	14158172.0
2010-03-08 15:00:00	AAPL	Stock	7.8247	7.8296	7.8164	7.8211	25372256.0
2010-03-08 15:30:00	AAPL	Stock	7.8211	7.8275	7.8143	7.8225	43508612.0
2010-03-08 16:00:00	AAPL	Stock	7.8193	7.8309	7.8114	7.82	5729024.0
2010-03-08 16:30:00	AAPL	Stock	7.8256	7.8256	7.8171	7.8189	252588.0
2010-03-08 17:00:00	AAPL	Stock	7.8193	7.8207	7.8157	7.8171	163660.0
2010-03-08 17:30:00	AAPL	Stock	7.8171	7.8307	7.8171	7.8196	150976.0
2010-03-08 18:00:00	AAPL	Stock	7.8196	7.8207	7.8175	7.8189	74760.0
2010-03-08 18:30:00	AAPL	Stock	7.8411	7.8411	7.8186	7.8211	37800.0
2010-03-08 19:00:00	AAPL	Stock	7.8204	7.8204	7.8154	7.8154	107016.0
2010-03-08 19:30:00	AAPL	Stock	7.8196	7.8196	7.8057	7.8125	175812.0
2010-03-08 07:00:00	MSFT	Stock	28.67	28.67	28.67	28.67	1000.0
2010-03-08 07:30:00	MSFT	Stock	28.65	28.65	28.65	28.65	259.0
2010-03-08 08:00:00	MSFT	Stock	28.61	28.65	28.6	28.6	34694.0
2010-03-08 08:30:00	MSFT	Stock	28.59	28.59	28.56	28.56	8679.0
2010-03-08 09:00:00	MSFT	Stock	28.57	28.58	28.53	28.54	37229.0
2010-03-08 09:30:00	MSFT	Stock	28.53	28.78	28.5	28.78	4707680.0
2010-03-08 10:00:00	MSFT	Stock	28.78	28.93	28.77	28.803	5844108.0
2010-03-08 10:30:00	MSFT	Stock	28.8	28.88	28.76	28.845	2700065.0
2010-03-08 11:00:00	MSFT	Stock	28.84	28.85	28.7	28.73	2619816.0
2010-03-08 11:30:00	MSFT	Stock	28.721	28.77	28.67	28.675	5353929.0
2010-03-08 12:00:00	MSFT	Stock	28.675	28.74	28.62	28.72	1488879.0
2010-03-08 12:30:00	MSFT	Stock	28.715	28.788	28.7	28.76	1435178.0
2010-03-08 13:00:00	MSFT	Stock	28.76	28.79	28.73	28.78	1338291.0
2010-03-08 13:30:00	MSFT	Stock	28.772	28.8	28.735	28.748	2006555.0
2010-03-08 14:00:00	MSFT	Stock	28.75	28.77	28.69	28.72	1313045.0
2010-03-08 14:30:00	MSFT	Stock	28.72	28.75	28.66	28.68	2140916.0
2010-03-08 15:00:00	MSFT	Stock	28.68	28.69	28.61	28.665	2598707.0
2010-03-08 15:30:00	MSFT	Stock	28.665	28.72	28.63	28.63	3146555.0
2010-03-08 16:00:00	MSFT	Stock	28.63	28.75	28.61	28.63	884527.0
2010-03-08 16:30:00	MSFT	Stock	28.717	28.719	28.62	28.719	10881.0
2010-03-08 17:00:00	MSFT	Stock	28.64	28.66	28.63	28.65	23700.0

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

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