PREVIEW / stock_30min / 2012-09-11

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-11.parquet
  size:    1.4 MB
  rows:    73,299
  symbols: 3,470

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-09-11 04:00:00	AAPL	Stock	23.6261	23.6429	23.6261	23.6393	116956.0
2012-09-11 04:30:00	AAPL	Stock	23.6554	23.6786	23.6554	23.6786	64288.0
2012-09-11 05:00:00	AAPL	Stock	23.6964	23.7196	23.6789	23.7196	38920.0
2012-09-11 05:30:00	AAPL	Stock	23.7107	23.7143	23.7071	23.7143	33600.0
2012-09-11 06:00:00	AAPL	Stock	23.6893	23.7279	23.6786	23.7279	57596.0
2012-09-11 06:30:00	AAPL	Stock	23.7411	23.75	23.7143	23.7446	57960.0
2012-09-11 07:00:00	AAPL	Stock	23.7464	23.7693	23.7143	23.7379	352576.0
2012-09-11 07:30:00	AAPL	Stock	23.7321	23.7946	23.7314	23.7936	867160.0
2012-09-11 08:00:00	AAPL	Stock	23.7921	23.8714	23.7314	23.8018	3388644.0
2012-09-11 08:30:00	AAPL	Stock	23.7936	23.7986	23.7325	23.7679	2146452.0
2012-09-11 09:00:00	AAPL	Stock	23.7711	23.775	23.7321	23.7536	1372672.0
2012-09-11 09:30:00	AAPL	Stock	23.7586	23.9182	23.7071	23.8979	91156632.0
2012-09-11 10:00:00	AAPL	Stock	23.8978	23.9321	23.6861	23.8114	54115460.0
2012-09-11 10:30:00	AAPL	Stock	23.8143	23.875	23.7939	23.8536	27886040.0
2012-09-11 11:00:00	AAPL	Stock	23.8536	23.8764	23.8243	23.8589	15208844.0
2012-09-11 11:30:00	AAPL	Stock	23.8568	23.8569	23.75	23.7893	18787804.0
2012-09-11 12:00:00	AAPL	Stock	23.7893	23.83	23.6804	23.6811	23414216.0
2012-09-11 12:30:00	AAPL	Stock	23.6811	23.7297	23.5989	23.647	34319768.0
2012-09-11 13:00:00	AAPL	Stock	23.6482	23.7446	23.5861	23.7326	32820956.0
2012-09-11 13:30:00	AAPL	Stock	23.7289	23.7764	23.6868	23.6996	23494240.0
2012-09-11 14:00:00	AAPL	Stock	23.6964	23.7054	23.5964	23.6929	28271012.0
2012-09-11 14:30:00	AAPL	Stock	23.6921	23.6946	23.4839	23.5135	37960804.0
2012-09-11 15:00:00	AAPL	Stock	23.5096	23.5839	23.4464	23.4771	35631484.0
2012-09-11 15:30:00	AAPL	Stock	23.4768	23.6746	23.4746	23.5929	46739980.0
2012-09-11 16:00:00	AAPL	Stock	23.5929	23.7103	23.5893	23.6071	14973168.0
2012-09-11 16:30:00	AAPL	Stock	23.6007	23.8192	23.4737	23.6046	420840.0
2012-09-11 17:00:00	AAPL	Stock	23.5957	23.6311	23.5957	23.6311	265832.0
2012-09-11 17:30:00	AAPL	Stock	23.6321	23.6511	23.6307	23.6357	274344.0
2012-09-11 18:00:00	AAPL	Stock	23.6361	23.6364	23.6071	23.6139	217896.0
2012-09-11 18:30:00	AAPL	Stock	23.6071	23.6314	23.6071	23.6286	32900.0
2012-09-11 19:00:00	AAPL	Stock	23.6286	23.64	23.625	23.6286	87024.0
2012-09-11 19:30:00	AAPL	Stock	23.6321	23.6429	23.6214	23.6429	208600.0
2012-09-11 08:30:00	MSFT	Stock	30.76	30.79	30.75	30.75	5900.0
2012-09-11 09:00:00	MSFT	Stock	30.79	30.79	30.6	30.64	69091.0
2012-09-11 09:30:00	MSFT	Stock	30.69	30.85	30.61	30.8	3559372.0
2012-09-11 10:00:00	MSFT	Stock	30.81	30.83	30.7	30.735	2068490.0
2012-09-11 10:30:00	MSFT	Stock	30.735	30.86	30.72	30.84	1637010.0
2012-09-11 11:00:00	MSFT	Stock	30.85	30.91	30.84	30.891	1335026.0
2012-09-11 11:30:00	MSFT	Stock	30.895	30.905	30.79	30.795	1114288.0
2012-09-11 12:00:00	MSFT	Stock	30.795	30.87	30.79	30.853	972825.0
2012-09-11 12:30:00	MSFT	Stock	30.856	30.88	30.85	30.87	760208.0
2012-09-11 13:00:00	MSFT	Stock	30.87	30.89	30.855	30.878	969945.0
2012-09-11 13:30:00	MSFT	Stock	30.87	30.9	30.87	30.9	629499.0
2012-09-11 14:00:00	MSFT	Stock	30.895	30.9	30.86	30.885	1113562.0
2012-09-11 14:30:00	MSFT	Stock	30.89	30.89	30.8	30.83	1659167.0
2012-09-11 15:00:00	MSFT	Stock	30.83	30.88	30.77	30.775	1758675.0
2012-09-11 15:30:00	MSFT	Stock	30.77	30.85	30.77	30.79	3718185.0
2012-09-11 16:00:00	MSFT	Stock	30.79	30.84	30.75	30.79	1603295.0
2012-09-11 16:30:00	MSFT	Stock	30.78	30.842	30.75	30.79	844809.0
2012-09-11 17:00:00	MSFT	Stock	30.75	30.79	30.75	30.79	9765.0

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

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