PREVIEW / stock_30min / 2017-08-28

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-28.parquet
  size:    1.6 MB
  rows:    81,658
  symbols: 2,993

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
2017-08-28 06:00:00	AAPL	Stock	39.94	39.94	39.94	39.94	400.0
2017-08-28 06:30:00	AAPL	Stock	39.9125	39.9525	39.9125	39.95	8340.0
2017-08-28 07:00:00	AAPL	Stock	39.95	40.05	39.93	40.045	12692.0
2017-08-28 07:30:00	AAPL	Stock	40.0025	40.0375	40.0	40.0125	10124.0
2017-08-28 08:00:00	AAPL	Stock	40.045	40.05	39.9275	40.0425	83100.0
2017-08-28 08:30:00	AAPL	Stock	40.05	40.075	40.04	40.0725	49412.0
2017-08-28 09:00:00	AAPL	Stock	40.0675	40.075	40.0275	40.05	161696.0
2017-08-28 09:30:00	AAPL	Stock	40.035	40.205	39.9825	40.1562	12882076.0
2017-08-28 10:00:00	AAPL	Stock	40.157	40.39	40.105	40.3	11598632.0
2017-08-28 10:30:00	AAPL	Stock	40.3	40.4725	40.25	40.4475	8061388.0
2017-08-28 11:00:00	AAPL	Stock	40.45	40.5	40.4175	40.4475	6937444.0
2017-08-28 11:30:00	AAPL	Stock	40.4475	40.4575	40.3125	40.4125	5056964.0
2017-08-28 12:00:00	AAPL	Stock	40.415	40.4175	40.285	40.3	3373064.0
2017-08-28 12:30:00	AAPL	Stock	40.3025	40.3385	40.2375	40.29	3555396.0
2017-08-28 13:00:00	AAPL	Stock	40.29	40.335	40.2525	40.2808	2826624.0
2017-08-28 13:30:00	AAPL	Stock	40.2825	40.4025	40.2537	40.385	4128356.0
2017-08-28 14:00:00	AAPL	Stock	40.3832	40.4125	40.3575	40.3925	3598080.0
2017-08-28 14:30:00	AAPL	Stock	40.39	40.3912	40.3475	40.3675	2967416.0
2017-08-28 15:00:00	AAPL	Stock	40.3675	40.394	40.2938	40.34	3880384.0
2017-08-28 15:30:00	AAPL	Stock	40.3425	40.3875	40.3125	40.3675	7270820.0
2017-08-28 16:00:00	AAPL	Stock	40.3675	40.38	40.35	40.3675	14431544.0
2017-08-28 16:30:00	AAPL	Stock	40.3675	40.38	40.3625	40.37	115924.0
2017-08-28 17:00:00	AAPL	Stock	40.37	40.3775	40.175	40.1875	133592.0
2017-08-28 17:30:00	AAPL	Stock	40.2	40.2	39.9675	40.0	346480.0
2017-08-28 18:00:00	AAPL	Stock	40.0	40.05	39.925	40.0125	237792.0
2017-08-28 18:30:00	AAPL	Stock	40.0625	40.1	39.975	40.05	192748.0
2017-08-28 19:00:00	AAPL	Stock	40.045	40.045	39.98	39.98	157320.0
2017-08-28 19:30:00	AAPL	Stock	39.9875	40.0625	39.9875	40.05	201272.0
2017-08-28 06:00:00	MSFT	Stock	72.77	72.77	72.77	72.77	100.0
2017-08-28 08:00:00	MSFT	Stock	73.02	73.04	73.01	73.04	886.0
2017-08-28 09:00:00	MSFT	Stock	72.96	73.05	72.85	73.05	7896.0
2017-08-28 09:30:00	MSFT	Stock	73.06	73.09	72.57	72.61	1564327.0
2017-08-28 10:00:00	MSFT	Stock	72.61	72.77	72.55	72.695	660958.0
2017-08-28 10:30:00	MSFT	Stock	72.69	72.93	72.66	72.88	828385.0
2017-08-28 11:00:00	MSFT	Stock	72.88	72.94	72.85	72.9	483221.0
2017-08-28 11:30:00	MSFT	Stock	72.895	72.92	72.8	72.884	348718.0
2017-08-28 12:00:00	MSFT	Stock	72.88	72.89	72.7	72.728	337077.0
2017-08-28 12:30:00	MSFT	Stock	72.727	72.757	72.645	72.73	290419.0
2017-08-28 13:00:00	MSFT	Stock	72.73	72.77	72.675	72.695	378224.0
2017-08-28 13:30:00	MSFT	Stock	72.7	72.76	72.63	72.73	557964.0
2017-08-28 14:00:00	MSFT	Stock	72.735	72.74	72.67	72.69	439881.0
2017-08-28 14:30:00	MSFT	Stock	72.68	72.72	72.65	72.68	451646.0
2017-08-28 15:00:00	MSFT	Stock	72.68	72.71	72.58	72.67	599376.0
2017-08-28 15:30:00	MSFT	Stock	72.665	72.86	72.66	72.83	1618356.0
2017-08-28 16:00:00	MSFT	Stock	72.83	72.83	72.79	72.83	3902463.0
2017-08-28 17:00:00	MSFT	Stock	72.74	72.74	72.45	72.45	7271.0
2017-08-28 17:30:00	MSFT	Stock	72.45	72.47	72.45	72.45	830.0
2017-08-28 18:00:00	MSFT	Stock	72.15	72.3	72.15	72.3	1168.0
2017-08-28 18:30:00	MSFT	Stock	72.21	72.25	72.12	72.16	3343.0
2017-08-28 19:00:00	MSFT	Stock	72.18	72.3	72.18	72.3	1077.0

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

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