PREVIEW / stock_30min / 2011-07-08

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-08.parquet
  size:    1.4 MB
  rows:    74,608
  symbols: 3,533

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
2011-07-08 04:00:00	AAPL	Stock	12.7696	12.7696	12.7696	12.7696	2800.0
2011-07-08 05:00:00	AAPL	Stock	12.785	12.7893	12.785	12.7893	8400.0
2011-07-08 05:30:00	AAPL	Stock	12.7654	12.7654	12.7654	12.7654	5600.0
2011-07-08 06:00:00	AAPL	Stock	12.7493	12.7493	12.7493	12.7493	2800.0
2011-07-08 06:30:00	AAPL	Stock	12.7829	12.7829	12.7829	12.7829	2800.0
2011-07-08 07:00:00	AAPL	Stock	12.7846	12.8068	12.7846	12.7893	109704.0
2011-07-08 07:30:00	AAPL	Stock	12.7754	12.8107	12.775	12.7986	169540.0
2011-07-08 08:00:00	AAPL	Stock	12.7914	12.8214	12.7893	12.8107	1216656.0
2011-07-08 08:30:00	AAPL	Stock	12.8	12.8207	12.6071	12.6096	5804680.0
2011-07-08 09:00:00	AAPL	Stock	12.6089	12.6296	12.5804	12.6193	3193120.0
2011-07-08 09:30:00	AAPL	Stock	12.6193	12.8382	12.5786	12.8299	119806176.0
2011-07-08 10:00:00	AAPL	Stock	12.8311	12.8532	12.7632	12.8193	72419312.0
2011-07-08 10:30:00	AAPL	Stock	12.8157	12.82	12.7621	12.8079	36416744.0
2011-07-08 11:00:00	AAPL	Stock	12.8068	12.8104	12.725	12.7539	41377924.0
2011-07-08 11:30:00	AAPL	Stock	12.7554	12.8093	12.745	12.7843	26438244.0
2011-07-08 12:00:00	AAPL	Stock	12.785	12.7897	12.7679	12.7736	14858228.0
2011-07-08 12:30:00	AAPL	Stock	12.7757	12.8007	12.7696	12.7818	15880144.0
2011-07-08 13:00:00	AAPL	Stock	12.78	12.7925	12.7679	12.79	13691076.0
2011-07-08 13:30:00	AAPL	Stock	12.7904	12.8036	12.7754	12.7832	16545984.0
2011-07-08 14:00:00	AAPL	Stock	12.7814	12.7971	12.7689	12.7771	12102356.0
2011-07-08 14:30:00	AAPL	Stock	12.7779	12.7907	12.7679	12.7836	11027436.0
2011-07-08 15:00:00	AAPL	Stock	12.7836	12.7939	12.7757	12.785	17556532.0
2011-07-08 15:30:00	AAPL	Stock	12.785	12.8571	12.7832	12.8471	65720592.0
2011-07-08 16:00:00	AAPL	Stock	12.8468	12.8604	12.7828	12.8554	7391636.0
2011-07-08 16:30:00	AAPL	Stock	12.8536	12.8589	12.85	12.8571	566860.0
2011-07-08 17:00:00	AAPL	Stock	12.8575	12.8607	12.8564	12.8593	283080.0
2011-07-08 17:30:00	AAPL	Stock	12.8611	12.8611	12.8554	12.8571	126952.0
2011-07-08 18:00:00	AAPL	Stock	12.8607	12.8611	12.8468	12.8554	239400.0
2011-07-08 18:30:00	AAPL	Stock	12.8571	12.8625	12.8568	12.8625	116620.0
2011-07-08 19:00:00	AAPL	Stock	12.8571	12.86	12.8571	12.8575	80864.0
2011-07-08 19:30:00	AAPL	Stock	12.8607	12.8643	12.8575	12.8643	43988.0
2011-07-08 05:00:00	MSFT	Stock	26.66	26.66	26.66	26.66	400.0
2011-07-08 06:30:00	MSFT	Stock	26.61	26.61	26.61	26.61	300.0
2011-07-08 07:30:00	MSFT	Stock	26.78	26.81	26.78	26.81	1578.0
2011-07-08 08:00:00	MSFT	Stock	26.8	26.91	26.78	26.9	24671.0
2011-07-08 08:30:00	MSFT	Stock	26.86	26.86	26.4	26.42	155471.0
2011-07-08 09:00:00	MSFT	Stock	26.45	26.59	26.36	26.54	135776.0
2011-07-08 09:30:00	MSFT	Stock	26.52	26.98	26.51	26.913	12304036.0
2011-07-08 10:00:00	MSFT	Stock	26.91	26.93	26.695	26.725	6792722.0
2011-07-08 10:30:00	MSFT	Stock	26.73	26.74	26.61	26.62	3894475.0
2011-07-08 11:00:00	MSFT	Stock	26.62	26.63	26.55	26.58	3068803.0
2011-07-08 11:30:00	MSFT	Stock	26.57	26.64	26.53	26.56	2583248.0
2011-07-08 12:00:00	MSFT	Stock	26.563	26.62	26.545	26.599	2107467.0
2011-07-08 12:30:00	MSFT	Stock	26.6	26.75	26.59	26.72	2696455.0
2011-07-08 13:00:00	MSFT	Stock	26.71	26.73	26.61	26.711	1995670.0
2011-07-08 13:30:00	MSFT	Stock	26.72	26.8	26.7	26.71	3699293.0
2011-07-08 14:00:00	MSFT	Stock	26.71	26.79	26.7	26.78	2669373.0
2011-07-08 14:30:00	MSFT	Stock	26.79	26.88	26.78	26.81	3532318.0
2011-07-08 15:00:00	MSFT	Stock	26.805	26.89	26.788	26.885	2957026.0
2011-07-08 15:30:00	MSFT	Stock	26.89	26.94	26.86	26.93	6869497.0

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

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