PREVIEW / stock_30min / 2018-11-05

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-05.parquet
  size:    1.7 MB
  rows:    84,067
  symbols: 2,761

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
2018-11-05 04:00:00	AAPL	Stock	51.625	51.625	51.425	51.425	34300.0
2018-11-05 04:30:00	AAPL	Stock	51.435	51.49	51.4275	51.4625	12172.0
2018-11-05 05:00:00	AAPL	Stock	51.5775	51.615	51.5	51.57	8172.0
2018-11-05 05:30:00	AAPL	Stock	51.5525	51.56	51.425	51.55	55060.0
2018-11-05 06:00:00	AAPL	Stock	51.5375	51.575	51.45	51.5	44416.0
2018-11-05 06:30:00	AAPL	Stock	51.455	51.455	51.2875	51.355	63380.0
2018-11-05 07:00:00	AAPL	Stock	51.32	51.535	51.265	51.29	260060.0
2018-11-05 07:30:00	AAPL	Stock	51.3125	51.325	50.905	50.905	963880.0
2018-11-05 08:00:00	AAPL	Stock	51.04	51.4375	50.875	50.975	1030088.0
2018-11-05 08:30:00	AAPL	Stock	50.9725	51.1125	50.94	51.0075	431364.0
2018-11-05 09:00:00	AAPL	Stock	51.0275	51.11	51.0	51.0975	741468.0
2018-11-05 09:30:00	AAPL	Stock	51.075	51.0975	50.207	50.2578	44796708.0
2018-11-05 10:00:00	AAPL	Stock	50.26	50.2925	49.5425	49.6698	42340644.0
2018-11-05 10:30:00	AAPL	Stock	49.6625	50.3625	49.6425	50.337	26858752.0
2018-11-05 11:00:00	AAPL	Stock	50.3362	50.3975	50.095	50.21	13463596.0
2018-11-05 11:30:00	AAPL	Stock	50.209	50.4725	50.1625	50.3912	10766052.0
2018-11-05 12:00:00	AAPL	Stock	50.3915	50.4225	49.89	50.0415	13846560.0
2018-11-05 12:30:00	AAPL	Stock	50.0375	50.0675	49.9225	50.045	5726788.0
2018-11-05 13:00:00	AAPL	Stock	50.0425	50.1125	49.9052	49.9762	6864880.0
2018-11-05 13:30:00	AAPL	Stock	49.9775	50.2375	49.895	50.2098	6324504.0
2018-11-05 14:00:00	AAPL	Stock	50.2088	50.445	50.1675	50.415	7421676.0
2018-11-05 14:30:00	AAPL	Stock	50.4075	50.4075	50.1625	50.231	6641876.0
2018-11-05 15:00:00	AAPL	Stock	50.2325	50.4575	50.2075	50.33	7881032.0
2018-11-05 15:30:00	AAPL	Stock	50.3325	50.4725	50.2625	50.3975	13749920.0
2018-11-05 16:00:00	AAPL	Stock	50.3925	50.4375	50.335	50.4	13980844.0
2018-11-05 16:30:00	AAPL	Stock	50.4025	50.4225	50.3775	50.4	101340.0
2018-11-05 17:00:00	AAPL	Stock	50.4	50.435	50.3875	50.41	75684.0
2018-11-05 17:30:00	AAPL	Stock	50.425	50.47	50.39	50.45	68364.0
2018-11-05 18:00:00	AAPL	Stock	50.4375	50.485	50.4275	50.475	60264.0
2018-11-05 18:30:00	AAPL	Stock	50.4725	50.4725	50.425	50.4275	90524.0
2018-11-05 19:00:00	AAPL	Stock	50.4275	50.4475	50.41	50.4325	29344.0
2018-11-05 19:30:00	AAPL	Stock	50.425	50.5	50.425	50.5	47540.0
2018-11-05 05:00:00	MSFT	Stock	106.14	106.14	106.13	106.13	928.0
2018-11-05 06:00:00	MSFT	Stock	106.5	106.5	106.5	106.5	1000.0
2018-11-05 06:30:00	MSFT	Stock	106.5	106.5	106.5	106.5	506.0
2018-11-05 07:00:00	MSFT	Stock	106.51	106.7	106.5	106.6	1869.0
2018-11-05 07:30:00	MSFT	Stock	106.3	106.45	106.0	106.0	5750.0
2018-11-05 08:00:00	MSFT	Stock	106.57	106.68	106.02	106.05	10295.0
2018-11-05 08:30:00	MSFT	Stock	106.15	106.21	105.9	106.15	7783.0
2018-11-05 09:00:00	MSFT	Stock	106.17	106.69	106.14	106.5	14897.0
2018-11-05 09:30:00	MSFT	Stock	106.38	106.525	105.9	106.28	4343452.0
2018-11-05 10:00:00	MSFT	Stock	106.29	106.53	105.98	106.025	2666111.0
2018-11-05 10:30:00	MSFT	Stock	106.03	107.02	106.025	106.975	2331862.0
2018-11-05 11:00:00	MSFT	Stock	106.97	106.975	106.46	106.497	1419366.0
2018-11-05 11:30:00	MSFT	Stock	106.5	106.7	106.23	106.57	1409360.0
2018-11-05 12:00:00	MSFT	Stock	106.57	106.95	106.36	106.855	1025211.0
2018-11-05 12:30:00	MSFT	Stock	106.855	106.97	106.705	106.92	1048873.0
2018-11-05 13:00:00	MSFT	Stock	106.92	107.16	106.8	106.96	937932.0
2018-11-05 13:30:00	MSFT	Stock	106.951	107.1	106.67	106.97	897562.0
2018-11-05 14:00:00	MSFT	Stock	106.96	107.59	106.85	107.59	1256747.0

> showing 50 of 84,067 rows — these rows as CSV

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