PREVIEW / stock_30min / 2010-10-15

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-15.parquet
  size:    1.4 MB
  rows:    73,243
  symbols: 3,461

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-10-15 05:30:00	AAPL	Stock	10.8882	10.8929	10.8786	10.8875	36988.0
2010-10-15 06:00:00	AAPL	Stock	10.8721	10.8929	10.8721	10.8929	33012.0
2010-10-15 06:30:00	AAPL	Stock	10.8679	10.8679	10.8643	10.8643	8400.0
2010-10-15 07:00:00	AAPL	Stock	10.8643	10.8929	10.85	10.8571	466788.0
2010-10-15 07:30:00	AAPL	Stock	10.8493	10.8504	10.8214	10.8439	357532.0
2010-10-15 08:00:00	AAPL	Stock	10.8429	10.9071	10.8321	10.895	4337564.0
2010-10-15 08:30:00	AAPL	Stock	10.8929	10.9546	10.8929	10.925	6210400.0
2010-10-15 09:00:00	AAPL	Stock	10.925	10.9786	10.9021	10.9761	6573392.0
2010-10-15 09:30:00	AAPL	Stock	10.9739	10.9804	10.8896	10.9614	164467156.0
2010-10-15 10:00:00	AAPL	Stock	10.9636	10.9661	10.9018	10.9436	82004356.0
2010-10-15 10:30:00	AAPL	Stock	10.9432	10.9932	10.9257	10.9886	52681496.0
2010-10-15 11:00:00	AAPL	Stock	10.9886	11.0554	10.975	11.0511	82929588.0
2010-10-15 11:30:00	AAPL	Stock	11.0507	11.0882	11.0496	11.0521	74231360.0
2010-10-15 12:00:00	AAPL	Stock	11.0521	11.075	11.0393	11.0622	39818492.0
2010-10-15 12:30:00	AAPL	Stock	11.0614	11.0714	11.0489	11.0507	31099152.0
2010-10-15 13:00:00	AAPL	Stock	11.0507	11.0729	11.05	11.0697	18631844.0
2010-10-15 13:30:00	AAPL	Stock	11.0711	11.0807	11.0571	11.0785	35259392.0
2010-10-15 14:00:00	AAPL	Stock	11.0771	11.0804	11.0625	11.0768	28871024.0
2010-10-15 14:30:00	AAPL	Stock	11.0775	11.1025	11.0754	11.0996	48607804.0
2010-10-15 15:00:00	AAPL	Stock	11.0993	11.1007	11.0768	11.0954	44912756.0
2010-10-15 15:30:00	AAPL	Stock	11.0956	11.25	11.0929	11.2489	155361500.0
2010-10-15 16:00:00	AAPL	Stock	11.25	11.2668	11.0393	11.2607	25155592.0
2010-10-15 16:30:00	AAPL	Stock	10.9867	11.2854	10.9867	11.2821	5611060.0
2010-10-15 17:00:00	AAPL	Stock	11.2836	11.2886	11.1183	11.275	2578856.0
2010-10-15 17:30:00	AAPL	Stock	11.2754	11.2846	11.2643	11.2661	1170736.0
2010-10-15 18:00:00	AAPL	Stock	11.265	11.2679	11.2407	11.2679	2555224.0
2010-10-15 18:30:00	AAPL	Stock	11.2679	11.3018	11.2679	11.3004	701456.0
2010-10-15 19:00:00	AAPL	Stock	11.3018	11.3132	11.2879	11.3	372512.0
2010-10-15 19:30:00	AAPL	Stock	11.3	11.3071	11.2879	11.3	495264.0
2010-10-15 07:00:00	MSFT	Stock	25.27	25.27	25.27	25.27	900.0
2010-10-15 07:30:00	MSFT	Stock	25.27	25.27	25.25	25.27	1400.0
2010-10-15 08:00:00	MSFT	Stock	25.27	25.35	25.17	25.29	43261.0
2010-10-15 08:30:00	MSFT	Stock	25.29	25.45	25.29	25.35	28129.0
2010-10-15 09:00:00	MSFT	Stock	25.31	25.39	25.25	25.35	185327.0
2010-10-15 09:30:00	MSFT	Stock	25.36	25.49	25.32	25.43	13426834.0
2010-10-15 10:00:00	MSFT	Stock	25.435	25.47	25.27	25.33	7316273.0
2010-10-15 10:30:00	MSFT	Stock	25.33	25.39	25.29	25.32	3738888.0
2010-10-15 11:00:00	MSFT	Stock	25.325	25.34	25.25	25.295	5564460.0
2010-10-15 11:30:00	MSFT	Stock	25.299	25.44	25.26	25.28	4061895.0
2010-10-15 12:00:00	MSFT	Stock	25.28	25.32	25.23	25.281	2091720.0
2010-10-15 12:30:00	MSFT	Stock	25.29	25.31	25.25	25.3	2299983.0
2010-10-15 13:00:00	MSFT	Stock	25.295	25.31	25.27	25.31	2065029.0
2010-10-15 13:30:00	MSFT	Stock	25.31	25.37	25.28	25.335	3395983.0
2010-10-15 14:00:00	MSFT	Stock	25.33	25.44	25.3	25.44	2271381.0
2010-10-15 14:30:00	MSFT	Stock	25.44	25.49	25.42	25.46	2930864.0
2010-10-15 15:00:00	MSFT	Stock	25.47	25.47	25.42	25.43	3547206.0
2010-10-15 15:30:00	MSFT	Stock	25.43	25.55	25.41	25.54	9933919.0
2010-10-15 16:00:00	MSFT	Stock	25.55	25.59	25.23	25.54	4171321.0
2010-10-15 16:30:00	MSFT	Stock	25.535	25.56	25.408	25.54	356015.0
2010-10-15 17:00:00	MSFT	Stock	25.44	25.44	25.44	25.44	25900.0

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

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