PREVIEW / stock_30min / 2016-10-24

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-24.parquet
  size:    1.5 MB
  rows:    79,343
  symbols: 3,212

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-10-24 04:00:00	AAPL	Stock	29.1675	29.25	29.1675	29.25	800.0
2016-10-24 04:30:00	AAPL	Stock	29.2675	29.285	29.2675	29.285	1200.0
2016-10-24 05:00:00	AAPL	Stock	29.3125	29.365	29.3125	29.3425	17324.0
2016-10-24 05:30:00	AAPL	Stock	29.35	29.3525	29.325	29.35	12752.0
2016-10-24 06:00:00	AAPL	Stock	29.35	29.37	29.3375	29.37	6056.0
2016-10-24 06:30:00	AAPL	Stock	29.37	29.37	29.35	29.37	20152.0
2016-10-24 07:00:00	AAPL	Stock	29.35	29.3675	29.3125	29.335	42916.0
2016-10-24 07:30:00	AAPL	Stock	29.315	29.315	29.275	29.2925	22100.0
2016-10-24 08:00:00	AAPL	Stock	29.3575	29.3575	29.2475	29.275	206536.0
2016-10-24 08:30:00	AAPL	Stock	29.2625	29.295	29.25	29.28	183928.0
2016-10-24 09:00:00	AAPL	Stock	29.29	29.3425	29.225	29.2725	279612.0
2016-10-24 09:30:00	AAPL	Stock	29.275	29.3975	29.25	29.3562	14840508.0
2016-10-24 10:00:00	AAPL	Stock	29.3575	29.3675	29.2825	29.2825	8024676.0
2016-10-24 10:30:00	AAPL	Stock	29.285	29.35	29.265	29.34	6378152.0
2016-10-24 11:00:00	AAPL	Stock	29.34	29.3675	29.33	29.3425	4881884.0
2016-10-24 11:30:00	AAPL	Stock	29.3438	29.375	29.3375	29.3388	4320552.0
2016-10-24 12:00:00	AAPL	Stock	29.3388	29.35	29.315	29.325	3458148.0
2016-10-24 12:30:00	AAPL	Stock	29.325	29.33	29.3025	29.3175	3002840.0
2016-10-24 13:00:00	AAPL	Stock	29.3198	29.375	29.3175	29.37	4130388.0
2016-10-24 13:30:00	AAPL	Stock	29.37	29.41	29.3675	29.4045	4702828.0
2016-10-24 14:00:00	AAPL	Stock	29.405	29.435	29.37	29.3865	4651228.0
2016-10-24 14:30:00	AAPL	Stock	29.3862	29.405	29.3325	29.3625	4326324.0
2016-10-24 15:00:00	AAPL	Stock	29.36	29.385	29.34	29.35	4340392.0
2016-10-24 15:30:00	AAPL	Stock	29.35	29.42	29.335	29.4025	9699256.0
2016-10-24 16:00:00	AAPL	Stock	29.4125	29.4175	29.3425	29.4125	7535384.0
2016-10-24 16:30:00	AAPL	Stock	29.4125	29.415	29.4025	29.415	45384.0
2016-10-24 17:00:00	AAPL	Stock	29.41	29.415	29.4	29.4	216356.0
2016-10-24 17:30:00	AAPL	Stock	29.4125	29.4125	29.4025	29.4125	53292.0
2016-10-24 18:00:00	AAPL	Stock	29.4	29.41	29.375	29.4	28300.0
2016-10-24 18:30:00	AAPL	Stock	29.4075	29.4125	29.4	29.4125	21536.0
2016-10-24 19:00:00	AAPL	Stock	29.4125	29.4225	29.4025	29.4225	19488.0
2016-10-24 19:30:00	AAPL	Stock	29.4225	29.425	29.415	29.425	38052.0
2016-10-24 04:00:00	MSFT	Stock	59.94	60.05	59.94	59.98	3581.0
2016-10-24 04:30:00	MSFT	Stock	59.97	59.97	59.96	59.96	800.0
2016-10-24 05:30:00	MSFT	Stock	59.94	59.94	59.94	59.94	400.0
2016-10-24 06:00:00	MSFT	Stock	59.94	59.94	59.85	59.91	6495.0
2016-10-24 06:30:00	MSFT	Stock	59.9	59.91	59.9	59.91	8440.0
2016-10-24 07:00:00	MSFT	Stock	59.91	59.91	59.82	59.89	9351.0
2016-10-24 07:30:00	MSFT	Stock	59.8	59.82	59.79	59.79	4899.0
2016-10-24 08:00:00	MSFT	Stock	59.76	59.88	59.66	59.76	10650.0
2016-10-24 08:30:00	MSFT	Stock	59.75	59.85	59.75	59.84	15152.0
2016-10-24 09:00:00	MSFT	Stock	59.8	59.97	59.77	59.95	103359.0
2016-10-24 09:30:00	MSFT	Stock	59.94	60.5	59.93	60.415	6953577.0
2016-10-24 10:00:00	MSFT	Stock	60.415	60.57	60.35	60.43	3656476.0
2016-10-24 10:30:00	MSFT	Stock	60.42	60.59	60.35	60.47	3320609.0
2016-10-24 11:00:00	MSFT	Stock	60.47	60.7	60.465	60.595	2154528.0
2016-10-24 11:30:00	MSFT	Stock	60.595	60.639	60.46	60.48	2166319.0
2016-10-24 12:00:00	MSFT	Stock	60.471	60.51	60.38	60.4	2096612.0
2016-10-24 12:30:00	MSFT	Stock	60.41	60.53	60.39	60.515	2154157.0
2016-10-24 13:00:00	MSFT	Stock	60.515	60.69	60.5	60.65	2120891.0

> showing 50 of 79,343 rows — these rows as CSV

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