PREVIEW / stock_30min / 2014-04-29

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-29.parquet
  size:    1.6 MB
  rows:    82,252
  symbols: 3,553

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-29 04:00:00	AAPL	Stock	21.2857	21.2857	21.2536	21.2536	8400.0
2014-04-29 04:30:00	AAPL	Stock	21.2621	21.2621	21.2621	21.2621	3780.0
2014-04-29 05:00:00	AAPL	Stock	21.2668	21.2668	21.25	21.25	5600.0
2014-04-29 05:30:00	AAPL	Stock	21.2668	21.2821	21.2668	21.2821	16800.0
2014-04-29 06:00:00	AAPL	Stock	21.2857	21.2964	21.2857	21.2957	22652.0
2014-04-29 06:30:00	AAPL	Stock	21.2964	21.3025	21.2821	21.3025	32200.0
2014-04-29 07:00:00	AAPL	Stock	21.2732	21.3064	21.2732	21.2857	116004.0
2014-04-29 07:30:00	AAPL	Stock	21.2779	21.3386	21.2639	21.3175	720860.0
2014-04-29 08:00:00	AAPL	Stock	21.3075	21.3214	21.2714	21.2929	1416184.0
2014-04-29 08:30:00	AAPL	Stock	21.2964	21.2986	21.2536	21.26	832524.0
2014-04-29 09:00:00	AAPL	Stock	21.2604	21.2768	21.2086	21.2086	3791340.0
2014-04-29 09:30:00	AAPL	Stock	21.205	21.285	21.0539	21.1189	66045672.0
2014-04-29 10:00:00	AAPL	Stock	21.1132	21.2625	21.0625	21.1429	36807680.0
2014-04-29 10:30:00	AAPL	Stock	21.1441	21.2175	21.1429	21.1811	17965696.0
2014-04-29 11:00:00	AAPL	Stock	21.1793	21.2081	21.1011	21.1747	14510244.0
2014-04-29 11:30:00	AAPL	Stock	21.1768	21.2107	21.1214	21.1443	11549804.0
2014-04-29 12:00:00	AAPL	Stock	21.15	21.1936	21.1179	21.1711	12619544.0
2014-04-29 12:30:00	AAPL	Stock	21.1711	21.1993	21.1618	21.1725	8416212.0
2014-04-29 13:00:00	AAPL	Stock	21.1704	21.1929	21.1357	21.1675	10531192.0
2014-04-29 13:30:00	AAPL	Stock	21.1675	21.2436	21.1532	21.2221	14836360.0
2014-04-29 14:00:00	AAPL	Stock	21.225	21.2489	21.1989	21.2168	13717620.0
2014-04-29 14:30:00	AAPL	Stock	21.2146	21.2254	21.1786	21.2043	7051436.0
2014-04-29 15:00:00	AAPL	Stock	21.2046	21.2159	21.175	21.2143	9364432.0
2014-04-29 15:30:00	AAPL	Stock	21.2129	21.2132	21.1364	21.1586	25290748.0
2014-04-29 16:00:00	AAPL	Stock	21.1546	21.1859	21.1254	21.1289	22243732.0
2014-04-29 16:30:00	AAPL	Stock	21.125	21.1839	21.1075	21.1075	242760.0
2014-04-29 17:00:00	AAPL	Stock	21.1107	21.1161	21.1029	21.1161	108584.0
2014-04-29 17:30:00	AAPL	Stock	21.1546	21.1546	21.0825	21.0857	135548.0
2014-04-29 18:00:00	AAPL	Stock	21.0861	21.1061	21.075	21.0893	108836.0
2014-04-29 18:30:00	AAPL	Stock	21.0893	21.1546	21.0718	21.0846	430584.0
2014-04-29 19:00:00	AAPL	Stock	21.0768	21.0893	21.075	21.075	68544.0
2014-04-29 19:30:00	AAPL	Stock	21.0839	21.0893	21.0714	21.0714	180236.0
2014-04-29 05:00:00	MSFT	Stock	41.04	41.04	41.04	41.04	200.0
2014-04-29 05:30:00	MSFT	Stock	41.04	41.04	41.04	41.04	100.0
2014-04-29 06:00:00	MSFT	Stock	41.04	41.05	41.04	41.05	1381.0
2014-04-29 06:30:00	MSFT	Stock	41.13	41.14	41.13	41.14	1700.0
2014-04-29 07:00:00	MSFT	Stock	41.14	41.14	41.14	41.14	300.0
2014-04-29 07:30:00	MSFT	Stock	41.16	41.23	41.16	41.17	2784.0
2014-04-29 08:00:00	MSFT	Stock	41.17	41.17	41.11	41.14	6946.0
2014-04-29 08:30:00	MSFT	Stock	41.16	41.16	41.04	41.07	5300.0
2014-04-29 09:00:00	MSFT	Stock	41.1	41.11	41.07	41.11	14834.0
2014-04-29 09:30:00	MSFT	Stock	41.1	41.19	40.75	40.75	4100433.0
2014-04-29 10:00:00	MSFT	Stock	40.76	40.81	40.4	40.46	3016329.0
2014-04-29 10:30:00	MSFT	Stock	40.46	40.73	40.39	40.68	2359948.0
2014-04-29 11:00:00	MSFT	Stock	40.68	40.745	40.595	40.7	1594761.0
2014-04-29 11:30:00	MSFT	Stock	40.7	40.72	40.55	40.6	1456152.0
2014-04-29 12:00:00	MSFT	Stock	40.61	40.65	40.53	40.584	1209670.0
2014-04-29 12:30:00	MSFT	Stock	40.59	40.69	40.56	40.68	1167705.0
2014-04-29 13:00:00	MSFT	Stock	40.67	40.685	40.58	40.63	1013559.0
2014-04-29 13:30:00	MSFT	Stock	40.63	40.64	40.53	40.6	1267766.0

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

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