PREVIEW / stock_30min / 2008-09-25

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-09-25.parquet
  size:    1.2 MB
  rows:    69,027
  symbols: 3,343

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
2008-09-25 05:30:00	AAPL	Stock	4.6425	4.6425	4.6425	4.6425	28000.0
2008-09-25 06:30:00	AAPL	Stock	4.6429	4.6429	4.6071	4.6071	14000.0
2008-09-25 07:00:00	AAPL	Stock	4.6082	4.6339	4.6064	4.6064	158620.0
2008-09-25 07:30:00	AAPL	Stock	4.5893	4.5893	4.5489	4.5661	440664.0
2008-09-25 08:00:00	AAPL	Stock	4.5711	4.6332	4.5696	4.625	3407936.0
2008-09-25 08:30:00	AAPL	Stock	4.6275	4.6329	4.6	4.6229	2932076.0
2008-09-25 09:00:00	AAPL	Stock	4.6246	4.6407	4.6014	4.6364	2738148.0
2008-09-25 09:30:00	AAPL	Stock	4.6364	4.6661	4.59	4.6268	119554904.0
2008-09-25 10:00:00	AAPL	Stock	4.625	4.6925	4.6125	4.6779	102834928.0
2008-09-25 10:30:00	AAPL	Stock	4.6779	4.7107	4.6714	4.6886	83904240.0
2008-09-25 11:00:00	AAPL	Stock	4.6886	4.7239	4.6811	4.7211	45938508.0
2008-09-25 11:30:00	AAPL	Stock	4.7211	4.7354	4.7082	4.7175	49840196.0
2008-09-25 12:00:00	AAPL	Stock	4.7175	4.7446	4.7	4.7414	39054736.0
2008-09-25 12:30:00	AAPL	Stock	4.7411	4.7743	4.735	4.7625	50180312.0
2008-09-25 13:00:00	AAPL	Stock	4.7623	4.7979	4.7454	4.7729	59352888.0
2008-09-25 13:30:00	AAPL	Stock	4.7729	4.8139	4.7561	4.7765	69816600.0
2008-09-25 14:00:00	AAPL	Stock	4.7768	4.7775	4.7239	4.7425	69642692.0
2008-09-25 14:30:00	AAPL	Stock	4.7414	4.7589	4.7036	4.7311	67892916.0
2008-09-25 15:00:00	AAPL	Stock	4.7318	4.7657	4.7211	4.7525	77190036.0
2008-09-25 15:30:00	AAPL	Stock	4.7529	4.7643	4.6796	4.7121	106954624.0
2008-09-25 16:00:00	AAPL	Stock	4.7118	4.7147	4.5021	4.5071	30147208.0
2008-09-25 16:30:00	AAPL	Stock	4.5071	4.7414	4.4979	4.5518	10680320.0
2008-09-25 17:00:00	AAPL	Stock	4.5546	4.5846	4.5536	4.5686	2134692.0
2008-09-25 17:30:00	AAPL	Stock	4.5714	4.7118	4.5268	4.5357	2201472.0
2008-09-25 18:00:00	AAPL	Stock	4.5357	4.5696	4.5357	4.5625	921704.0
2008-09-25 18:30:00	AAPL	Stock	4.5639	4.5675	4.5486	4.5536	378364.0
2008-09-25 19:00:00	AAPL	Stock	4.5536	4.5586	4.5357	4.5429	255948.0
2008-09-25 19:30:00	AAPL	Stock	4.5482	4.5489	4.5179	4.5289	656964.0
2008-09-25 07:00:00	MSFT	Stock	25.8	25.8	25.8	25.8	980.0
2008-09-25 07:30:00	MSFT	Stock	25.8	25.8	25.8	25.8	600.0
2008-09-25 08:00:00	MSFT	Stock	25.79	25.94	25.79	25.89	16585.0
2008-09-25 08:30:00	MSFT	Stock	25.89	25.89	25.75	25.75	139138.0
2008-09-25 09:00:00	MSFT	Stock	25.75	25.82	25.54	25.82	551876.0
2008-09-25 09:30:00	MSFT	Stock	25.82	26.35	25.74	26.27	9330630.0
2008-09-25 10:00:00	MSFT	Stock	26.27	26.67	26.18	26.48	11200436.0
2008-09-25 10:30:00	MSFT	Stock	26.48	26.49	26.26	26.362	6160379.0
2008-09-25 11:00:00	MSFT	Stock	26.37	26.6	26.34	26.58	4158745.0
2008-09-25 11:30:00	MSFT	Stock	26.58	26.67	26.5	26.55	4108387.0
2008-09-25 12:00:00	MSFT	Stock	26.552	26.69	26.5	26.64	5144476.0
2008-09-25 12:30:00	MSFT	Stock	26.631	26.67	26.55	26.61	3988102.0
2008-09-25 13:00:00	MSFT	Stock	26.6	26.7	26.59	26.7	5833781.0
2008-09-25 13:30:00	MSFT	Stock	26.7	26.82	26.59	26.7	6768886.0
2008-09-25 14:00:00	MSFT	Stock	26.7	26.75	26.5	26.52	7636469.0
2008-09-25 14:30:00	MSFT	Stock	26.52	26.65	26.48	26.62	6151965.0
2008-09-25 15:00:00	MSFT	Stock	26.62	26.88	26.59	26.86	7785613.0
2008-09-25 15:30:00	MSFT	Stock	26.86	26.88	26.51	26.65	11328552.0
2008-09-25 16:00:00	MSFT	Stock	26.65	26.88	26.4	26.49	3804016.0
2008-09-25 16:30:00	MSFT	Stock	26.5	26.61	26.4	26.48	16211.0
2008-09-25 17:00:00	MSFT	Stock	26.41	26.48	26.37	26.48	5333.0
2008-09-25 17:30:00	MSFT	Stock	26.61	26.623	26.33	26.35	14481.0

> showing 50 of 69,027 rows — these rows as CSV

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