PREVIEW / stock_30min / 2016-04-26

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-26.parquet
  size:    1.6 MB
  rows:    82,627
  symbols: 3,322

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-26 04:00:00	AAPL	Stock	26.325	26.325	26.27	26.27	9240.0
2016-04-26 04:30:00	AAPL	Stock	26.3	26.325	26.2375	26.2375	22400.0
2016-04-26 05:00:00	AAPL	Stock	26.2325	26.2325	26.2325	26.2325	800.0
2016-04-26 05:30:00	AAPL	Stock	26.225	26.23	26.22	26.23	1620.0
2016-04-26 06:00:00	AAPL	Stock	26.25	26.25	26.175	26.175	9652.0
2016-04-26 06:30:00	AAPL	Stock	26.1875	26.1975	26.1275	26.1275	8008.0
2016-04-26 07:00:00	AAPL	Stock	26.15	26.2025	26.0725	26.0725	89148.0
2016-04-26 07:30:00	AAPL	Stock	26.085	26.1125	26.0	26.0725	123068.0
2016-04-26 08:00:00	AAPL	Stock	26.0825	26.325	26.025	26.055	598576.0
2016-04-26 08:30:00	AAPL	Stock	26.07	26.135	26.0625	26.1025	313152.0
2016-04-26 09:00:00	AAPL	Stock	26.1025	26.15	25.965	25.975	640888.0
2016-04-26 09:30:00	AAPL	Stock	25.9675	26.325	25.9675	26.25	23220056.0
2016-04-26 10:00:00	AAPL	Stock	26.25	26.2825	26.1525	26.155	11190972.0
2016-04-26 10:30:00	AAPL	Stock	26.1525	26.22	26.0675	26.1132	10342536.0
2016-04-26 11:00:00	AAPL	Stock	26.1135	26.16	26.0625	26.1525	7674120.0
2016-04-26 11:30:00	AAPL	Stock	26.155	26.1838	26.105	26.1588	6458788.0
2016-04-26 12:00:00	AAPL	Stock	26.159	26.225	26.1475	26.1715	5934372.0
2016-04-26 12:30:00	AAPL	Stock	26.1725	26.1875	26.075	26.0807	5406560.0
2016-04-26 13:00:00	AAPL	Stock	26.08	26.1075	26.0138	26.0925	8200108.0
2016-04-26 13:30:00	AAPL	Stock	26.095	26.135	26.07	26.115	6539280.0
2016-04-26 14:00:00	AAPL	Stock	26.115	26.1275	26.035	26.075	8985888.0
2016-04-26 14:30:00	AAPL	Stock	26.075	26.1675	26.07	26.101	9152128.0
2016-04-26 15:00:00	AAPL	Stock	26.1025	26.1425	26.0425	26.0575	11589932.0
2016-04-26 15:30:00	AAPL	Stock	26.0575	26.105	26.0125	26.075	25013384.0
2016-04-26 16:00:00	AAPL	Stock	26.0875	26.2168	26.0	26.0375	6523356.0
2016-04-26 16:30:00	AAPL	Stock	26.01	26.0978	24.105	24.1425	34363528.0
2016-04-26 17:00:00	AAPL	Stock	24.15	24.25	23.955	24.01	16013056.0
2016-04-26 17:30:00	AAPL	Stock	24.0225	24.1625	23.94	23.9625	4265008.0
2016-04-26 18:00:00	AAPL	Stock	23.9575	26.1335	23.8775	23.93	2775304.0
2016-04-26 18:30:00	AAPL	Stock	23.93	24.02	23.91	23.97	1361068.0
2016-04-26 19:00:00	AAPL	Stock	23.97	23.99	23.95	23.9775	417364.0
2016-04-26 19:30:00	AAPL	Stock	23.9775	24.03	23.9375	24.0275	745388.0
2016-04-26 05:30:00	MSFT	Stock	52.3	52.3	52.3	52.3	2000.0
2016-04-26 07:30:00	MSFT	Stock	52.27	52.27	52.27	52.27	100.0
2016-04-26 08:00:00	MSFT	Stock	52.27	52.27	52.13	52.15	16323.0
2016-04-26 08:30:00	MSFT	Stock	52.2	52.2	52.13	52.13	4350.0
2016-04-26 09:00:00	MSFT	Stock	52.18	52.28	52.11	52.25	6120.0
2016-04-26 09:30:00	MSFT	Stock	52.26	52.35	51.78	51.81	3428459.0
2016-04-26 10:00:00	MSFT	Stock	51.81	51.94	51.57	51.595	2190660.0
2016-04-26 10:30:00	MSFT	Stock	51.59	51.65	51.36	51.48	2449114.0
2016-04-26 11:00:00	MSFT	Stock	51.49	51.61	51.4	51.42	1951614.0
2016-04-26 11:30:00	MSFT	Stock	51.43	51.49	51.32	51.445	1494238.0
2016-04-26 12:00:00	MSFT	Stock	51.445	51.55	51.44	51.455	1150051.0
2016-04-26 12:30:00	MSFT	Stock	51.455	51.46	51.31	51.315	1538463.0
2016-04-26 13:00:00	MSFT	Stock	51.32	51.35	51.22	51.35	1585967.0
2016-04-26 13:30:00	MSFT	Stock	51.34	51.41	51.22	51.22	1588956.0
2016-04-26 14:00:00	MSFT	Stock	51.226	51.27	51.09	51.155	2404462.0
2016-04-26 14:30:00	MSFT	Stock	51.153	51.26	51.14	51.185	1688763.0
2016-04-26 15:00:00	MSFT	Stock	51.18	51.315	51.16	51.185	2797606.0
2016-04-26 15:30:00	MSFT	Stock	51.185	51.44	51.16	51.44	4968406.0

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

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