PREVIEW / stock_30min / 2014-04-21

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-21.parquet
  size:    1.6 MB
  rows:    82,269
  symbols: 3,567

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
2014-04-21 07:00:00	AAPL	Stock	18.8021	18.8171	18.7946	18.8143	70000.0
2014-04-21 07:30:00	AAPL	Stock	18.7946	18.8036	18.7857	18.8036	70728.0
2014-04-21 08:00:00	AAPL	Stock	18.8025	18.8025	18.7643	18.7746	367836.0
2014-04-21 08:30:00	AAPL	Stock	18.7682	18.7746	18.7607	18.7625	139832.0
2014-04-21 09:00:00	AAPL	Stock	18.7679	18.7679	18.7589	18.7643	763168.0
2014-04-21 09:30:00	AAPL	Stock	18.7621	18.8743	18.7129	18.8609	32043844.0
2014-04-21 10:00:00	AAPL	Stock	18.8611	18.9243	18.8611	18.8982	15387316.0
2014-04-21 10:30:00	AAPL	Stock	18.8984	18.9	18.8464	18.87	13691636.0
2014-04-21 11:00:00	AAPL	Stock	18.8704	18.9168	18.87	18.8964	6363028.0
2014-04-21 11:30:00	AAPL	Stock	18.893	18.9082	18.8689	18.9064	5668796.0
2014-04-21 12:00:00	AAPL	Stock	18.905	18.9293	18.8968	18.9196	8310764.0
2014-04-21 12:30:00	AAPL	Stock	18.9161	18.9554	18.9061	18.9511	7137536.0
2014-04-21 13:00:00	AAPL	Stock	18.9514	18.9993	18.9471	18.9989	10148180.0
2014-04-21 13:30:00	AAPL	Stock	18.9996	19.0004	18.9721	18.9929	7099652.0
2014-04-21 14:00:00	AAPL	Stock	18.9993	19.005	18.9564	18.9757	6019020.0
2014-04-21 14:30:00	AAPL	Stock	18.9757	18.9779	18.9464	18.9543	4271316.0
2014-04-21 15:00:00	AAPL	Stock	18.9543	18.9568	18.9318	18.9475	6718404.0
2014-04-21 15:30:00	AAPL	Stock	18.9471	18.97	18.9286	18.97	13070540.0
2014-04-21 16:00:00	AAPL	Stock	18.9704	18.9971	18.8827	18.9625	9451344.0
2014-04-21 16:30:00	AAPL	Stock	18.9625	18.9646	18.9589	18.9589	51520.0
2014-04-21 17:00:00	AAPL	Stock	18.9571	18.9707	18.9571	18.9707	11200.0
2014-04-21 17:30:00	AAPL	Stock	18.9704	18.9711	18.9704	18.9711	328328.0
2014-04-21 18:00:00	AAPL	Stock	18.9729	18.9729	18.9711	18.9729	17920.0
2014-04-21 18:30:00	AAPL	Stock	18.9786	18.98	18.9786	18.98	7000.0
2014-04-21 19:00:00	AAPL	Stock	18.9768	18.9821	18.9768	18.9821	16660.0
2014-04-21 19:30:00	AAPL	Stock	18.9768	18.9821	18.9768	18.9821	67368.0
2014-04-21 07:30:00	MSFT	Stock	40.06	40.06	40.06	40.06	249.0
2014-04-21 08:00:00	MSFT	Stock	40.24	40.24	40.04	40.09	3916.0
2014-04-21 08:30:00	MSFT	Stock	40.06	40.08	40.02	40.02	3435.0
2014-04-21 09:00:00	MSFT	Stock	40.06	40.15	40.02	40.15	15332.0
2014-04-21 09:30:00	MSFT	Stock	40.13	40.15	39.98	40.06	2509202.0
2014-04-21 10:00:00	MSFT	Stock	40.064	40.15	39.92	39.97	1927662.0
2014-04-21 10:30:00	MSFT	Stock	39.97	40.06	39.79	39.99	1787252.0
2014-04-21 11:00:00	MSFT	Stock	40.0	40.1	39.97	40.025	1546844.0
2014-04-21 11:30:00	MSFT	Stock	40.03	40.14	40.01	40.1	1394387.0
2014-04-21 12:00:00	MSFT	Stock	40.11	40.15	40.06	40.09	1156347.0
2014-04-21 12:30:00	MSFT	Stock	40.095	40.14	40.04	40.1	895245.0
2014-04-21 13:00:00	MSFT	Stock	40.107	40.12	40.06	40.08	574412.0
2014-04-21 13:30:00	MSFT	Stock	40.085	40.1	39.99	40.01	1106681.0
2014-04-21 14:00:00	MSFT	Stock	40.01	40.04	39.97	40.0	947214.0
2014-04-21 14:30:00	MSFT	Stock	40.0	40.02	39.92	39.99	1217817.0
2014-04-21 15:00:00	MSFT	Stock	40.0	40.01	39.93	39.982	1055659.0
2014-04-21 15:30:00	MSFT	Stock	39.985	40.0	39.91	39.92	3252662.0
2014-04-21 16:00:00	MSFT	Stock	39.94	40.015	39.92	39.94	2003046.0
2014-04-21 16:30:00	MSFT	Stock	39.92	39.94	39.9	39.9	5836.0
2014-04-21 17:00:00	MSFT	Stock	40.14	40.14	39.91	39.91	351.0
2014-04-21 17:30:00	MSFT	Stock	39.94	40.0	39.94	40.0	10142.0
2014-04-21 18:00:00	MSFT	Stock	39.94	39.94	39.94	39.94	10474.0
2014-04-21 18:30:00	MSFT	Stock	39.96	39.99	39.96	39.99	639.0
2014-04-21 19:00:00	MSFT	Stock	39.99	39.99	39.99	39.99	100.0

> showing 50 of 82,269 rows — these rows as CSV

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