PREVIEW / stock_30min / 2013-06-11

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-11.parquet
  size:    1.5 MB
  rows:    78,248
  symbols: 3,495

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-06-11 04:00:00	AAPL	Stock	15.6764	15.6764	15.6764	15.6764	8400.0
2013-06-11 06:00:00	AAPL	Stock	15.6036	15.6036	15.6032	15.6032	5600.0
2013-06-11 06:30:00	AAPL	Stock	15.5821	15.5821	15.5339	15.5429	83720.0
2013-06-11 07:00:00	AAPL	Stock	15.5371	15.5625	15.525	15.5339	161280.0
2013-06-11 07:30:00	AAPL	Stock	15.5496	15.5786	15.5375	15.5764	160356.0
2013-06-11 08:00:00	AAPL	Stock	15.5714	15.7143	15.5189	15.5429	1016596.0
2013-06-11 08:30:00	AAPL	Stock	15.545	15.5589	15.5375	15.5536	886592.0
2013-06-11 09:00:00	AAPL	Stock	15.5518	15.6286	15.5518	15.5679	1423716.0
2013-06-11 09:30:00	AAPL	Stock	15.5679	15.7518	15.4757	15.7229	65795492.0
2013-06-11 10:00:00	AAPL	Stock	15.7189	15.7979	15.69	15.7575	45689364.0
2013-06-11 10:30:00	AAPL	Stock	15.7575	15.8129	15.7164	15.735	25982460.0
2013-06-11 11:00:00	AAPL	Stock	15.735	15.7679	15.7025	15.7599	11476136.0
2013-06-11 11:30:00	AAPL	Stock	15.7648	15.7725	15.7182	15.7196	13394892.0
2013-06-11 12:00:00	AAPL	Stock	15.7239	15.7775	15.7054	15.775	15067724.0
2013-06-11 12:30:00	AAPL	Stock	15.7773	15.7968	15.7429	15.7461	12390084.0
2013-06-11 13:00:00	AAPL	Stock	15.7496	15.7757	15.7129	15.7182	10846780.0
2013-06-11 13:30:00	AAPL	Stock	15.7164	15.7436	15.6875	15.7246	12389216.0
2013-06-11 14:00:00	AAPL	Stock	15.7246	15.7482	15.7057	15.735	10898300.0
2013-06-11 14:30:00	AAPL	Stock	15.7357	15.7457	15.6964	15.7446	11049136.0
2013-06-11 15:00:00	AAPL	Stock	15.7429	15.7561	15.7143	15.7202	10226860.0
2013-06-11 15:30:00	AAPL	Stock	15.7205	15.7282	15.62	15.6314	29327396.0
2013-06-11 16:00:00	AAPL	Stock	15.6286	15.7367	15.625	15.6354	5561892.0
2013-06-11 16:30:00	AAPL	Stock	15.6379	15.6418	15.6286	15.6286	216160.0
2013-06-11 17:00:00	AAPL	Stock	15.6418	15.6432	15.6357	15.6425	156744.0
2013-06-11 17:30:00	AAPL	Stock	15.6432	15.6446	15.6361	15.6393	27944.0
2013-06-11 18:00:00	AAPL	Stock	15.6404	15.6404	15.6393	15.6393	5600.0
2013-06-11 19:00:00	AAPL	Stock	15.6429	15.6429	15.6407	15.6414	43400.0
2013-06-11 19:30:00	AAPL	Stock	15.6393	15.6482	15.6393	15.6482	228844.0
2013-06-11 07:30:00	MSFT	Stock	35.19	35.2	35.19	35.2	1016.0
2013-06-11 08:00:00	MSFT	Stock	35.5	35.5	35.14	35.15	17693.0
2013-06-11 08:30:00	MSFT	Stock	35.13	35.47	35.11	35.11	51821.0
2013-06-11 09:00:00	MSFT	Stock	35.15	35.15	35.03	35.03	20279.0
2013-06-11 09:30:00	MSFT	Stock	35.03	35.05	34.81	34.945	5609870.0
2013-06-11 10:00:00	MSFT	Stock	34.95	34.97	34.68	34.89	5444061.0
2013-06-11 10:30:00	MSFT	Stock	34.89	34.93	34.845	34.88	2444485.0
2013-06-11 11:00:00	MSFT	Stock	34.89	35.03	34.83	35.03	2840769.0
2013-06-11 11:30:00	MSFT	Stock	35.03	35.15	35.025	35.1	2929284.0
2013-06-11 12:00:00	MSFT	Stock	35.105	35.18	35.09	35.104	1708895.0
2013-06-11 12:30:00	MSFT	Stock	35.105	35.11	34.99	35.045	2066766.0
2013-06-11 13:00:00	MSFT	Stock	35.045	35.08	34.94	34.965	1592713.0
2013-06-11 13:30:00	MSFT	Stock	34.96	34.99	34.86	34.88	1626256.0
2013-06-11 14:00:00	MSFT	Stock	34.87	34.92	34.8	34.91	2105791.0
2013-06-11 14:30:00	MSFT	Stock	34.902	34.98	34.84	34.98	1719741.0
2013-06-11 15:00:00	MSFT	Stock	34.975	35.01	34.94	34.95	2111855.0
2013-06-11 15:30:00	MSFT	Stock	34.95	34.95	34.81	34.85	4257281.0
2013-06-11 16:00:00	MSFT	Stock	34.85	35.47	34.84	34.84	1731493.0
2013-06-11 16:30:00	MSFT	Stock	34.86	34.95	34.84	34.87	64744.0
2013-06-11 17:00:00	MSFT	Stock	34.833	35.05	34.833	35.05	20385.0
2013-06-11 18:00:00	MSFT	Stock	34.98	34.98	34.87	34.87	417.0
2013-06-11 19:00:00	MSFT	Stock	34.87	34.87	34.87	34.87	1500.0

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

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