PREVIEW / stock_30min / 2013-07-10

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-10.parquet
  size:    1.5 MB
  rows:    78,979
  symbols: 3,494

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
2013-07-10 04:00:00	AAPL	Stock	15.1232	15.1232	15.1232	15.1232	8400.0
2013-07-10 06:00:00	AAPL	Stock	15.0679	15.0679	15.0679	15.0679	19712.0
2013-07-10 06:30:00	AAPL	Stock	15.0718	15.0718	15.0718	15.0718	19600.0
2013-07-10 07:00:00	AAPL	Stock	15.0718	15.0718	15.0393	15.0393	32564.0
2013-07-10 07:30:00	AAPL	Stock	15.0421	15.0421	15.0079	15.0079	96600.0
2013-07-10 08:00:00	AAPL	Stock	15.0164	15.0668	15.0079	15.0564	446768.0
2013-07-10 08:30:00	AAPL	Stock	15.0539	15.0711	15.0368	15.0679	350392.0
2013-07-10 09:00:00	AAPL	Stock	15.0593	15.0607	14.9554	14.9811	2827608.0
2013-07-10 09:30:00	AAPL	Stock	14.9857	15.15	14.9375	15.0282	65398172.0
2013-07-10 10:00:00	AAPL	Stock	15.0314	15.1629	14.9879	15.1493	40869248.0
2013-07-10 10:30:00	AAPL	Stock	15.1464	15.1714	15.0632	15.1032	36378636.0
2013-07-10 11:00:00	AAPL	Stock	15.1036	15.1146	15.0539	15.0721	12626544.0
2013-07-10 11:30:00	AAPL	Stock	15.0707	15.0993	15.0446	15.0586	9789528.0
2013-07-10 12:00:00	AAPL	Stock	15.0568	15.0893	15.0554	15.075	5341476.0
2013-07-10 12:30:00	AAPL	Stock	15.0779	15.1304	15.0767	15.1057	10234336.0
2013-07-10 13:00:00	AAPL	Stock	15.1065	15.1065	15.0596	15.0804	6226808.0
2013-07-10 13:30:00	AAPL	Stock	15.0789	15.0859	15.0629	15.0771	5680976.0
2013-07-10 14:00:00	AAPL	Stock	15.0767	15.1354	15.0607	15.0946	22015308.0
2013-07-10 14:30:00	AAPL	Stock	15.0946	15.1161	14.9929	15.0296	19336968.0
2013-07-10 15:00:00	AAPL	Stock	15.0296	15.0668	15.0054	15.0475	11679556.0
2013-07-10 15:30:00	AAPL	Stock	15.0468	15.0571	15.0025	15.026	21680568.0
2013-07-10 16:00:00	AAPL	Stock	15.0261	15.0848	15.0021	15.01	6639808.0
2013-07-10 16:30:00	AAPL	Stock	15.01	15.0261	15.0079	15.0243	126756.0
2013-07-10 17:00:00	AAPL	Stock	15.0243	15.06	15.0243	15.0536	413896.0
2013-07-10 17:30:00	AAPL	Stock	15.0525	15.0621	15.0489	15.0536	155512.0
2013-07-10 18:00:00	AAPL	Stock	15.0611	15.0804	15.0611	15.0761	316568.0
2013-07-10 18:30:00	AAPL	Stock	15.0786	15.1054	15.0786	15.0893	293664.0
2013-07-10 19:00:00	AAPL	Stock	15.0893	15.105	15.0893	15.1043	190988.0
2013-07-10 19:30:00	AAPL	Stock	15.1	15.1179	15.095	15.1154	173152.0
2013-07-10 08:00:00	MSFT	Stock	34.35	34.35	34.33	34.33	2506.0
2013-07-10 08:30:00	MSFT	Stock	34.35	34.35	34.35	34.35	400.0
2013-07-10 09:00:00	MSFT	Stock	34.38	34.38	34.3	34.3	2500.0
2013-07-10 09:30:00	MSFT	Stock	34.32	34.74	34.32	34.72	3792158.0
2013-07-10 10:00:00	MSFT	Stock	34.715	34.81	34.57	34.655	3155351.0
2013-07-10 10:30:00	MSFT	Stock	34.66	34.7	34.55	34.59	2599704.0
2013-07-10 11:00:00	MSFT	Stock	34.59	34.65	34.56	34.65	1666887.0
2013-07-10 11:30:00	MSFT	Stock	34.64	34.7	34.58	34.59	1673404.0
2013-07-10 12:00:00	MSFT	Stock	34.59	34.64	34.53	34.57	1478609.0
2013-07-10 12:30:00	MSFT	Stock	34.57	34.6	34.55	34.555	1058016.0
2013-07-10 13:00:00	MSFT	Stock	34.55	34.62	34.52	34.62	849428.0
2013-07-10 13:30:00	MSFT	Stock	34.62	34.69	34.61	34.654	930466.0
2013-07-10 14:00:00	MSFT	Stock	34.66	34.77	34.617	34.637	2754338.0
2013-07-10 14:30:00	MSFT	Stock	34.635	34.68	34.564	34.635	1399207.0
2013-07-10 15:00:00	MSFT	Stock	34.64	34.75	34.59	34.68	1235023.0
2013-07-10 15:30:00	MSFT	Stock	34.685	34.71	34.645	34.69	3791118.0
2013-07-10 16:00:00	MSFT	Stock	34.69	34.701	34.35	34.67	1979127.0
2013-07-10 16:30:00	MSFT	Stock	34.68	34.73	34.665	34.73	17095.0
2013-07-10 17:00:00	MSFT	Stock	34.73	34.8	34.7	34.8	2970.0
2013-07-10 17:30:00	MSFT	Stock	34.74	35.05	34.68	34.99	18664.0
2013-07-10 18:00:00	MSFT	Stock	34.97	35.0	34.97	35.0	4149.0

> showing 50 of 78,979 rows — these rows as CSV

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