PREVIEW / stock_30min / 2016-08-23

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-23.parquet
  size:    1.6 MB
  rows:    81,607
  symbols: 3,255

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-08-23 04:00:00	AAPL	Stock	27.1	27.175	27.1	27.17	4800.0
2016-08-23 04:30:00	AAPL	Stock	27.1425	27.17	27.1375	27.17	2400.0
2016-08-23 05:00:00	AAPL	Stock	27.185	27.185	27.1675	27.17	2636.0
2016-08-23 05:30:00	AAPL	Stock	27.1925	27.1925	27.1925	27.1925	2400.0
2016-08-23 06:00:00	AAPL	Stock	27.2	27.2	27.175	27.175	1200.0
2016-08-23 06:30:00	AAPL	Stock	27.175	27.175	27.175	27.175	472.0
2016-08-23 07:00:00	AAPL	Stock	27.17	27.175	27.1575	27.1575	8160.0
2016-08-23 07:30:00	AAPL	Stock	27.17	27.17	27.1675	27.1675	11600.0
2016-08-23 08:00:00	AAPL	Stock	27.15	27.175	27.125	27.1575	43488.0
2016-08-23 08:30:00	AAPL	Stock	27.1575	27.16	27.1375	27.1425	96212.0
2016-08-23 09:00:00	AAPL	Stock	27.15	27.165	27.1225	27.1325	325464.0
2016-08-23 09:30:00	AAPL	Stock	27.1525	27.33	27.1325	27.325	15934652.0
2016-08-23 10:00:00	AAPL	Stock	27.3248	27.33	27.275	27.2938	6671540.0
2016-08-23 10:30:00	AAPL	Stock	27.295	27.3125	27.2625	27.28	4528056.0
2016-08-23 11:00:00	AAPL	Stock	27.278	27.28	27.21	27.2225	4723824.0
2016-08-23 11:30:00	AAPL	Stock	27.225	27.245	27.2025	27.219	5138556.0
2016-08-23 12:00:00	AAPL	Stock	27.2175	27.28	27.2025	27.235	4641164.0
2016-08-23 12:30:00	AAPL	Stock	27.235	27.2575	27.2	27.22	3225368.0
2016-08-23 13:00:00	AAPL	Stock	27.2175	27.25	27.21	27.2375	2324768.0
2016-08-23 13:30:00	AAPL	Stock	27.2375	27.2675	27.2225	27.255	2330008.0
2016-08-23 14:00:00	AAPL	Stock	27.255	27.275	27.2175	27.25	2863196.0
2016-08-23 14:30:00	AAPL	Stock	27.2475	27.26	27.2225	27.2365	2881080.0
2016-08-23 15:00:00	AAPL	Stock	27.235	27.245	27.225	27.2352	3141688.0
2016-08-23 15:30:00	AAPL	Stock	27.235	27.2375	27.2	27.2075	7265772.0
2016-08-23 16:00:00	AAPL	Stock	27.2025	27.2875	27.2	27.2125	7192560.0
2016-08-23 16:30:00	AAPL	Stock	27.2025	27.2125	27.2025	27.2125	19544.0
2016-08-23 17:00:00	AAPL	Stock	27.21	27.2125	27.205	27.21	7652.0
2016-08-23 17:30:00	AAPL	Stock	27.205	27.2225	27.205	27.2225	9600.0
2016-08-23 18:00:00	AAPL	Stock	27.205	27.2275	27.205	27.2125	2800.0
2016-08-23 18:30:00	AAPL	Stock	27.2125	27.2125	27.2075	27.2075	18400.0
2016-08-23 19:00:00	AAPL	Stock	27.2075	27.2125	27.2075	27.2125	1500.0
2016-08-23 19:30:00	AAPL	Stock	27.2125	27.22	27.2125	27.22	6424.0
2016-08-23 08:00:00	MSFT	Stock	57.75	57.75	57.75	57.75	125.0
2016-08-23 08:30:00	MSFT	Stock	57.77	57.8	57.77	57.8	1366.0
2016-08-23 09:00:00	MSFT	Stock	57.8	57.94	57.76	57.92	18712.0
2016-08-23 09:30:00	MSFT	Stock	57.9	58.18	57.88	58.13	2176519.0
2016-08-23 10:00:00	MSFT	Stock	58.125	58.17	58.06	58.08	1240337.0
2016-08-23 10:30:00	MSFT	Stock	58.079	58.09	57.98	58.03	939736.0
2016-08-23 11:00:00	MSFT	Stock	58.03	58.06	57.9	57.97	833369.0
2016-08-23 11:30:00	MSFT	Stock	57.97	58.04	57.94	57.95	969639.0
2016-08-23 12:00:00	MSFT	Stock	57.94	57.99	57.89	57.965	664806.0
2016-08-23 12:30:00	MSFT	Stock	57.96	57.98	57.86	57.907	684412.0
2016-08-23 13:00:00	MSFT	Stock	57.91	58.0	57.9	58.0	838448.0
2016-08-23 13:30:00	MSFT	Stock	58.0	58.04	57.94	57.95	745389.0
2016-08-23 14:00:00	MSFT	Stock	57.95	57.98	57.89	57.965	744850.0
2016-08-23 14:30:00	MSFT	Stock	57.96	57.99	57.88	57.94	1157849.0
2016-08-23 15:00:00	MSFT	Stock	57.92	57.95	57.85	57.915	955403.0
2016-08-23 15:30:00	MSFT	Stock	57.916	57.98	57.87	57.9	2943880.0
2016-08-23 16:00:00	MSFT	Stock	57.9	57.9	57.89	57.89	2446254.0
2016-08-23 16:30:00	MSFT	Stock	57.89	57.89	57.89	57.89	1120.0

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

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