PREVIEW / stock_30min / 2016-04-21

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-21.parquet
  size:    1.6 MB
  rows:    81,900
  symbols: 3,323

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
2016-04-21 04:30:00	AAPL	Stock	26.7875	26.7875	26.7875	26.7875	2000.0
2016-04-21 06:30:00	AAPL	Stock	26.7875	26.8175	26.7875	26.8175	5480.0
2016-04-21 07:00:00	AAPL	Stock	26.8175	26.84	26.8	26.825	43744.0
2016-04-21 07:30:00	AAPL	Stock	26.825	26.8625	26.7875	26.825	22800.0
2016-04-21 08:00:00	AAPL	Stock	26.805	26.875	26.7875	26.875	89264.0
2016-04-21 08:30:00	AAPL	Stock	26.8625	26.8825	26.8175	26.845	135192.0
2016-04-21 09:00:00	AAPL	Stock	26.8125	26.8425	26.73	26.7325	269416.0
2016-04-21 09:30:00	AAPL	Stock	26.7325	26.7325	26.38	26.49	26310940.0
2016-04-21 10:00:00	AAPL	Stock	26.488	26.625	26.45	26.6038	11657864.0
2016-04-21 10:30:00	AAPL	Stock	26.6028	26.6638	26.56	26.605	8143680.0
2016-04-21 11:00:00	AAPL	Stock	26.6058	26.64	26.5525	26.565	6226312.0
2016-04-21 11:30:00	AAPL	Stock	26.5638	26.58	26.4525	26.4552	9088252.0
2016-04-21 12:00:00	AAPL	Stock	26.455	26.5025	26.425	26.47	5141468.0
2016-04-21 12:30:00	AAPL	Stock	26.47	26.495	26.4225	26.425	4738616.0
2016-04-21 13:00:00	AAPL	Stock	26.425	26.4525	26.3812	26.4272	5326752.0
2016-04-21 13:30:00	AAPL	Stock	26.425	26.4825	26.4075	26.4775	5215320.0
2016-04-21 14:00:00	AAPL	Stock	26.4775	26.5225	26.46	26.5025	5519752.0
2016-04-21 14:30:00	AAPL	Stock	26.5025	26.5025	26.4325	26.4925	5948208.0
2016-04-21 15:00:00	AAPL	Stock	26.49	26.53	26.48	26.485	5719820.0
2016-04-21 15:30:00	AAPL	Stock	26.484	26.5238	26.4825	26.4925	10590900.0
2016-04-21 16:00:00	AAPL	Stock	26.4925	26.5962	26.35	26.3625	6225576.0
2016-04-21 16:30:00	AAPL	Stock	26.3625	26.375	26.345	26.3625	192932.0
2016-04-21 17:00:00	AAPL	Stock	26.3625	26.37	26.35	26.355	31484.0
2016-04-21 17:30:00	AAPL	Stock	26.355	26.355	26.25	26.2625	143588.0
2016-04-21 18:00:00	AAPL	Stock	26.28	26.3	26.25	26.2925	79424.0
2016-04-21 18:30:00	AAPL	Stock	26.2925	26.2925	26.2275	26.2725	124816.0
2016-04-21 19:00:00	AAPL	Stock	26.2575	26.2875	26.2525	26.285	42084.0
2016-04-21 19:30:00	AAPL	Stock	26.2775	26.3125	26.26	26.3	59040.0
2016-04-21 06:00:00	MSFT	Stock	55.85	55.85	55.7	55.78	3500.0
2016-04-21 06:30:00	MSFT	Stock	55.78	55.8	55.78	55.8	4150.0
2016-04-21 07:00:00	MSFT	Stock	55.85	55.85	55.85	55.85	1100.0
2016-04-21 07:30:00	MSFT	Stock	55.8	55.85	55.75	55.75	12900.0
2016-04-21 08:00:00	MSFT	Stock	55.75	55.85	55.72	55.76	15085.0
2016-04-21 08:30:00	MSFT	Stock	55.8	55.84	55.77	55.84	24553.0
2016-04-21 09:00:00	MSFT	Stock	55.8	55.87	55.56	55.56	90075.0
2016-04-21 09:30:00	MSFT	Stock	55.57	56.01	55.415	55.505	4915470.0
2016-04-21 10:00:00	MSFT	Stock	55.51	55.75	55.5	55.71	2553697.0
2016-04-21 10:30:00	MSFT	Stock	55.7	56.115	55.66	56.05	1946916.0
2016-04-21 11:00:00	MSFT	Stock	56.05	56.23	55.97	56.1	2275386.0
2016-04-21 11:30:00	MSFT	Stock	56.1	56.11	55.875	55.88	1938713.0
2016-04-21 12:00:00	MSFT	Stock	55.885	55.89	55.63	55.705	1528677.0
2016-04-21 12:30:00	MSFT	Stock	55.705	55.905	55.705	55.855	1915788.0
2016-04-21 13:00:00	MSFT	Stock	55.855	55.916	55.685	55.724	1917599.0
2016-04-21 13:30:00	MSFT	Stock	55.72	55.99	55.72	55.83	1573967.0
2016-04-21 14:00:00	MSFT	Stock	55.824	55.88	55.71	55.74	1719656.0
2016-04-21 14:30:00	MSFT	Stock	55.74	55.88	55.62	55.85	1980565.0
2016-04-21 15:00:00	MSFT	Stock	55.85	55.92	55.76	55.76	1953299.0
2016-04-21 15:30:00	MSFT	Stock	55.76	55.97	55.71	55.788	4892902.0
2016-04-21 16:00:00	MSFT	Stock	55.8	56.5	52.99	53.05	2906868.0
2016-04-21 16:30:00	MSFT	Stock	53.02	55.855	52.9	54.15	959774.0

> showing 50 of 81,900 rows — these rows as CSV

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