PREVIEW / stock_30min / 2014-03-11

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-11.parquet
  size:    1.6 MB
  rows:    82,849
  symbols: 3,535

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-03-11 04:00:00	AAPL	Stock	18.9143	19.0946	18.9143	19.0696	125776.0
2014-03-11 04:30:00	AAPL	Stock	19.0804	19.1286	19.0804	19.1075	78400.0
2014-03-11 05:00:00	AAPL	Stock	19.1057	19.1057	19.0879	19.0893	43960.0
2014-03-11 05:30:00	AAPL	Stock	19.1004	19.1004	19.0714	19.0714	5600.0
2014-03-11 06:00:00	AAPL	Stock	19.0589	19.0946	19.0589	19.0711	14000.0
2014-03-11 06:30:00	AAPL	Stock	19.0736	19.0939	19.0714	19.075	21000.0
2014-03-11 07:00:00	AAPL	Stock	19.0964	19.0964	19.0536	19.0657	116256.0
2014-03-11 07:30:00	AAPL	Stock	19.0657	19.0914	19.0571	19.075	273308.0
2014-03-11 08:00:00	AAPL	Stock	19.0893	19.0914	19.0446	19.0693	564200.0
2014-03-11 08:30:00	AAPL	Stock	19.0689	19.0786	19.0536	19.0711	952896.0
2014-03-11 09:00:00	AAPL	Stock	19.0689	19.15	19.0689	19.1204	2420292.0
2014-03-11 09:30:00	AAPL	Stock	19.1282	19.21	19.1093	19.1982	51007376.0
2014-03-11 10:00:00	AAPL	Stock	19.2002	19.2229	19.1554	19.2186	24191524.0
2014-03-11 10:30:00	AAPL	Stock	19.2196	19.23	19.1908	19.2268	15171492.0
2014-03-11 11:00:00	AAPL	Stock	19.2268	19.2393	19.2046	19.2129	9937788.0
2014-03-11 11:30:00	AAPL	Stock	19.213	19.2214	19.1679	19.2214	12433876.0
2014-03-11 12:00:00	AAPL	Stock	19.2211	19.2407	19.1982	19.2182	14111608.0
2014-03-11 12:30:00	AAPL	Stock	19.2182	19.2293	19.1736	19.1864	10565548.0
2014-03-11 13:00:00	AAPL	Stock	19.1825	19.1961	19.1611	19.1768	7171136.0
2014-03-11 13:30:00	AAPL	Stock	19.175	19.2089	19.1632	19.2054	6648600.0
2014-03-11 14:00:00	AAPL	Stock	19.2082	19.2125	19.1318	19.1511	9678200.0
2014-03-11 14:30:00	AAPL	Stock	19.1507	19.1537	19.0804	19.0877	14585116.0
2014-03-11 15:00:00	AAPL	Stock	19.0864	19.1061	19.0211	19.0971	17324692.0
2014-03-11 15:30:00	AAPL	Stock	19.0989	19.15	19.0907	19.1468	23337692.0
2014-03-11 16:00:00	AAPL	Stock	19.1461	19.1676	19.1461	19.1557	5749828.0
2014-03-11 16:30:00	AAPL	Stock	19.1568	19.1618	19.1422	19.1589	747712.0
2014-03-11 17:00:00	AAPL	Stock	19.1571	19.1654	19.1554	19.1607	93548.0
2014-03-11 17:30:00	AAPL	Stock	19.1511	19.1579	19.1461	19.1461	936012.0
2014-03-11 18:00:00	AAPL	Stock	19.1461	19.1571	19.1461	19.1461	462840.0
2014-03-11 18:30:00	AAPL	Stock	19.1536	19.1639	19.1536	19.1571	25340.0
2014-03-11 19:00:00	AAPL	Stock	19.1543	19.1607	19.1543	19.1607	22036.0
2014-03-11 19:30:00	AAPL	Stock	19.1536	19.1536	19.1461	19.1464	71036.0
2014-03-11 07:00:00	MSFT	Stock	37.76	37.76	37.76	37.76	150.0
2014-03-11 08:00:00	MSFT	Stock	37.79	37.87	37.79	37.87	300.0
2014-03-11 09:00:00	MSFT	Stock	37.95	37.95	37.55	37.94	2600.0
2014-03-11 09:30:00	MSFT	Stock	37.87	37.98	37.72	37.91	2301734.0
2014-03-11 10:00:00	MSFT	Stock	37.91	38.07	37.83	38.025	2037175.0
2014-03-11 10:30:00	MSFT	Stock	38.025	38.23	38.01	38.17	1701700.0
2014-03-11 11:00:00	MSFT	Stock	38.17	38.205	38.13	38.15	1359136.0
2014-03-11 11:30:00	MSFT	Stock	38.145	38.15	38.04	38.115	1568438.0
2014-03-11 12:00:00	MSFT	Stock	38.113	38.14	37.975	38.033	1321968.0
2014-03-11 12:30:00	MSFT	Stock	38.04	38.05	37.95	37.955	850592.0
2014-03-11 13:00:00	MSFT	Stock	37.96	38.02	37.92	37.98	1106244.0
2014-03-11 13:30:00	MSFT	Stock	37.98	38.08	37.95	38.07	950951.0
2014-03-11 14:00:00	MSFT	Stock	38.07	38.08	38.0	38.026	885914.0
2014-03-11 14:30:00	MSFT	Stock	38.02	38.04	37.925	37.97	1616834.0
2014-03-11 15:00:00	MSFT	Stock	37.97	37.97	37.86	37.935	2101076.0
2014-03-11 15:30:00	MSFT	Stock	37.935	38.02	37.91	38.02	2597484.0
2014-03-11 16:00:00	MSFT	Stock	38.02	38.124	37.977	38.02	3890538.0
2014-03-11 16:30:00	MSFT	Stock	38.012	38.02	37.91	38.02	112880.0

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

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