PREVIEW / stock_30min / 2012-03-07

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-07.parquet
  size:    1.4 MB
  rows:    74,208
  symbols: 3,503

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
2012-03-07 04:00:00	AAPL	Stock	19.0129	19.0429	19.0129	19.0357	67200.0
2012-03-07 04:30:00	AAPL	Stock	19.0357	19.0357	19.025	19.025	15260.0
2012-03-07 05:00:00	AAPL	Stock	19.0286	19.0429	19.0286	19.0429	25200.0
2012-03-07 05:30:00	AAPL	Stock	19.0679	19.1393	19.0571	19.0571	64400.0
2012-03-07 06:00:00	AAPL	Stock	19.0625	19.0625	19.0536	19.0536	34412.0
2012-03-07 06:30:00	AAPL	Stock	19.0568	19.0568	19.0357	19.0536	171724.0
2012-03-07 07:00:00	AAPL	Stock	19.0411	19.0686	19.0393	19.0554	322588.0
2012-03-07 07:30:00	AAPL	Stock	19.0568	19.0714	19.0357	19.0464	777056.0
2012-03-07 08:00:00	AAPL	Stock	19.0482	19.1196	18.975	19.1079	5077772.0
2012-03-07 08:30:00	AAPL	Stock	19.1107	19.1507	19.1071	19.1436	4734016.0
2012-03-07 09:00:00	AAPL	Stock	19.1432	19.1786	19.1071	19.1611	6465284.0
2012-03-07 09:30:00	AAPL	Stock	19.1711	19.2064	19.0257	19.0457	89563768.0
2012-03-07 10:00:00	AAPL	Stock	19.0418	19.0989	19.0186	19.0771	43552180.0
2012-03-07 10:30:00	AAPL	Stock	19.0771	19.0811	19.0304	19.0692	27733776.0
2012-03-07 11:00:00	AAPL	Stock	19.0658	19.0911	19.0411	19.0664	23757020.0
2012-03-07 11:30:00	AAPL	Stock	19.0679	19.1407	19.0539	19.1379	37282672.0
2012-03-07 12:00:00	AAPL	Stock	19.1375	19.1486	19.1014	19.1065	23284856.0
2012-03-07 12:30:00	AAPL	Stock	19.11	19.1379	19.0811	19.1111	18165896.0
2012-03-07 13:00:00	AAPL	Stock	19.112	19.1604	18.9661	19.0548	88935728.0
2012-03-07 13:30:00	AAPL	Stock	19.056	19.0804	18.8611	18.9775	103177956.0
2012-03-07 14:00:00	AAPL	Stock	18.9804	19.0671	18.9036	18.9804	59020360.0
2012-03-07 14:30:00	AAPL	Stock	18.9796	18.9839	18.7575	18.8193	78509480.0
2012-03-07 15:00:00	AAPL	Stock	18.8159	18.8714	18.6893	18.8679	82720736.0
2012-03-07 15:30:00	AAPL	Stock	18.8643	19.0143	18.8421	18.9511	82792528.0
2012-03-07 16:00:00	AAPL	Stock	18.9509	19.1328	18.8778	18.9911	8221024.0
2012-03-07 16:30:00	AAPL	Stock	18.9864	18.9961	18.9418	18.9786	917224.0
2012-03-07 17:00:00	AAPL	Stock	18.9789	18.9943	18.9786	18.9911	293748.0
2012-03-07 17:30:00	AAPL	Stock	18.9936	18.9936	18.9575	18.9589	723072.0
2012-03-07 18:00:00	AAPL	Stock	18.9571	18.9732	18.9393	18.9682	1048208.0
2012-03-07 18:30:00	AAPL	Stock	18.9693	18.97	18.9571	18.9618	197652.0
2012-03-07 19:00:00	AAPL	Stock	18.9636	18.9682	18.9625	18.9625	256368.0
2012-03-07 19:30:00	AAPL	Stock	18.9643	18.9725	18.9589	18.9711	337232.0
2012-03-07 07:00:00	MSFT	Stock	31.69	31.73	31.69	31.73	425.0
2012-03-07 07:30:00	MSFT	Stock	31.72	31.73	31.72	31.73	1000.0
2012-03-07 08:00:00	MSFT	Stock	31.72	31.77	31.65	31.77	17547.0
2012-03-07 08:30:00	MSFT	Stock	31.77	31.8	31.66	31.75	14572.0
2012-03-07 09:00:00	MSFT	Stock	31.74	31.76	31.63	31.65	16794.0
2012-03-07 09:30:00	MSFT	Stock	31.67	31.82	31.6	31.66	4586855.0
2012-03-07 10:00:00	MSFT	Stock	31.665	31.72	31.53	31.66	3622094.0
2012-03-07 10:30:00	MSFT	Stock	31.66	31.71	31.62	31.71	2351900.0
2012-03-07 11:00:00	MSFT	Stock	31.7	31.85	31.7	31.82	2432481.0
2012-03-07 11:30:00	MSFT	Stock	31.812	31.84	31.76	31.79	1455944.0
2012-03-07 12:00:00	MSFT	Stock	31.79	31.84	31.78	31.83	1202698.0
2012-03-07 12:30:00	MSFT	Stock	31.83	31.92	31.8	31.89	1510830.0
2012-03-07 13:00:00	MSFT	Stock	31.892	31.91	31.86	31.89	1623972.0
2012-03-07 13:30:00	MSFT	Stock	31.88	31.89	31.81	31.815	1885757.0
2012-03-07 14:00:00	MSFT	Stock	31.82	31.88	31.81	31.865	2162741.0
2012-03-07 14:30:00	MSFT	Stock	31.87	31.87	31.8	31.822	2243619.0
2012-03-07 15:00:00	MSFT	Stock	31.825	31.85	31.77	31.82	1686630.0
2012-03-07 15:30:00	MSFT	Stock	31.815	31.89	31.81	31.84	4051793.0

> showing 50 of 74,208 rows — these rows as CSV

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