PREVIEW / stock_30min / 2015-08-21

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-21.parquet
  size:    1.7 MB
  rows:    84,750
  symbols: 3,475

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
2015-08-21 04:00:00	AAPL	Stock	28.0	28.0	27.8375	27.875	136008.0
2015-08-21 04:30:00	AAPL	Stock	27.875	27.9125	27.865	27.9125	26268.0
2015-08-21 05:00:00	AAPL	Stock	27.935	27.96	27.9125	27.96	17376.0
2015-08-21 05:30:00	AAPL	Stock	27.95	28.015	27.93	27.93	44484.0
2015-08-21 06:00:00	AAPL	Stock	27.9725	27.9725	27.895	27.895	57924.0
2015-08-21 06:30:00	AAPL	Stock	27.93	27.93	27.8125	27.85	38268.0
2015-08-21 07:00:00	AAPL	Stock	27.85	27.875	27.8125	27.85	95064.0
2015-08-21 07:30:00	AAPL	Stock	27.85	27.87	27.8125	27.85	267976.0
2015-08-21 08:00:00	AAPL	Stock	27.8375	27.895	27.6875	27.7375	1080092.0
2015-08-21 08:30:00	AAPL	Stock	27.7325	27.7625	27.675	27.7125	759416.0
2015-08-21 09:00:00	AAPL	Stock	27.71	27.7125	27.5625	27.6125	3463192.0
2015-08-21 09:30:00	AAPL	Stock	27.6075	27.975	27.5275	27.8725	49791600.0
2015-08-21 10:00:00	AAPL	Stock	27.87	27.945	27.6375	27.6525	27894264.0
2015-08-21 10:30:00	AAPL	Stock	27.6538	27.75	27.0275	27.2725	53787080.0
2015-08-21 11:00:00	AAPL	Stock	27.2725	27.2875	26.9375	27.2125	45041620.0
2015-08-21 11:30:00	AAPL	Stock	27.2125	27.2562	27.02	27.1745	27553336.0
2015-08-21 12:00:00	AAPL	Stock	27.1725	27.2175	26.9125	26.9475	28163312.0
2015-08-21 12:30:00	AAPL	Stock	26.9475	27.0925	26.9375	26.975	20305240.0
2015-08-21 13:00:00	AAPL	Stock	26.975	27.145	26.9275	27.135	18768196.0
2015-08-21 13:30:00	AAPL	Stock	27.1362	27.1362	26.95	27.1075	19181768.0
2015-08-21 14:00:00	AAPL	Stock	27.11	27.2025	26.9875	27.0325	16489584.0
2015-08-21 14:30:00	AAPL	Stock	27.035	27.0525	26.76	26.855	25688708.0
2015-08-21 15:00:00	AAPL	Stock	26.8525	26.9	26.42	26.5445	46628236.0
2015-08-21 15:30:00	AAPL	Stock	26.545	26.75	26.4112	26.4425	66190736.0
2015-08-21 16:00:00	AAPL	Stock	26.4425	27.2125	26.4375	26.5825	23760272.0
2015-08-21 16:30:00	AAPL	Stock	26.58	26.605	26.5375	26.55	371544.0
2015-08-21 17:00:00	AAPL	Stock	26.5625	26.6125	26.5	26.5125	279008.0
2015-08-21 17:30:00	AAPL	Stock	26.515	26.55	26.44	26.5242	3053588.0
2015-08-21 18:00:00	AAPL	Stock	26.515	26.5375	26.495	26.525	152148.0
2015-08-21 18:30:00	AAPL	Stock	26.525	26.55	26.505	26.5125	101228.0
2015-08-21 19:00:00	AAPL	Stock	26.51	26.5175	26.475	26.4875	128552.0
2015-08-21 19:30:00	AAPL	Stock	26.485	26.5042	26.4375	26.475	198224.0
2015-08-21 04:00:00	MSFT	Stock	45.5	45.5	45.5	45.5	100.0
2015-08-21 05:00:00	MSFT	Stock	45.57	45.58	45.57	45.58	200.0
2015-08-21 06:00:00	MSFT	Stock	45.35	45.35	45.3	45.35	2004.0
2015-08-21 06:30:00	MSFT	Stock	45.35	45.35	45.28	45.28	3500.0
2015-08-21 07:00:00	MSFT	Stock	45.37	45.37	45.37	45.37	500.0
2015-08-21 07:30:00	MSFT	Stock	45.37	45.4	45.37	45.4	2900.0
2015-08-21 08:00:00	MSFT	Stock	45.47	45.57	45.2	45.3	8058.0
2015-08-21 08:30:00	MSFT	Stock	45.33	45.4	45.28	45.33	6512.0
2015-08-21 09:00:00	MSFT	Stock	45.35	45.43	45.17	45.2	675803.0
2015-08-21 09:30:00	MSFT	Stock	45.3	45.44	44.92	45.385	7471927.0
2015-08-21 10:00:00	MSFT	Stock	45.38	45.48	45.09	45.11	2652217.0
2015-08-21 10:30:00	MSFT	Stock	45.11	45.175	44.88	44.92	3741573.0
2015-08-21 11:00:00	MSFT	Stock	44.91	44.935	44.54	44.725	3936523.0
2015-08-21 11:30:00	MSFT	Stock	44.73	44.82	44.35	44.4	4498333.0
2015-08-21 12:00:00	MSFT	Stock	44.39	44.51	44.24	44.28	3251847.0
2015-08-21 12:30:00	MSFT	Stock	44.28	44.345	44.02	44.04	2493272.0
2015-08-21 13:00:00	MSFT	Stock	44.04	44.17	43.95	44.14	2481889.0
2015-08-21 13:30:00	MSFT	Stock	44.14	44.16	43.87	44.04	3667220.0

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

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