PREVIEW / stock_30min / 2016-04-13

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-13.parquet
  size:    1.6 MB
  rows:    83,048
  symbols: 3,340

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-04-13 04:00:00	AAPL	Stock	27.6275	27.735	27.6275	27.7075	13184.0
2016-04-13 04:30:00	AAPL	Stock	27.725	27.725	27.68	27.7225	9200.0
2016-04-13 05:00:00	AAPL	Stock	27.735	27.7925	27.735	27.7925	12848.0
2016-04-13 05:30:00	AAPL	Stock	27.785	27.8	27.785	27.785	10216.0
2016-04-13 06:00:00	AAPL	Stock	27.7575	27.8	27.7575	27.76	10396.0
2016-04-13 06:30:00	AAPL	Stock	27.76	27.765	27.76	27.765	4780.0
2016-04-13 07:00:00	AAPL	Stock	27.775	27.8125	27.765	27.775	49260.0
2016-04-13 07:30:00	AAPL	Stock	27.775	27.8	27.765	27.795	35628.0
2016-04-13 08:00:00	AAPL	Stock	27.78	27.8	27.7425	27.75	154804.0
2016-04-13 08:30:00	AAPL	Stock	27.7425	27.75	27.7	27.7425	184520.0
2016-04-13 09:00:00	AAPL	Stock	27.745	27.785	27.6925	27.7	440040.0
2016-04-13 09:30:00	AAPL	Stock	27.69	27.9625	27.69	27.8725	19272740.0
2016-04-13 10:00:00	AAPL	Stock	27.877	27.9925	27.8625	27.9875	9769944.0
2016-04-13 10:30:00	AAPL	Stock	27.99	27.995	27.895	27.905	10998304.0
2016-04-13 11:00:00	AAPL	Stock	27.9	27.9875	27.8625	27.985	9984808.0
2016-04-13 11:30:00	AAPL	Stock	27.985	28.05	27.96	28.015	10782124.0
2016-04-13 12:00:00	AAPL	Stock	28.0175	28.0225	27.93	27.98	4123164.0
2016-04-13 12:30:00	AAPL	Stock	27.9825	27.995	27.95	27.955	3083760.0
2016-04-13 13:00:00	AAPL	Stock	27.955	27.9925	27.9025	27.9625	4770156.0
2016-04-13 13:30:00	AAPL	Stock	27.96	28.025	27.96	28.02	6132288.0
2016-04-13 14:00:00	AAPL	Stock	28.02	28.05	27.985	28.0225	6050864.0
2016-04-13 14:30:00	AAPL	Stock	28.0225	28.085	28.0	28.015	7957500.0
2016-04-13 15:00:00	AAPL	Stock	28.015	28.075	28.0075	28.0548	6198536.0
2016-04-13 15:30:00	AAPL	Stock	28.055	28.08	27.9775	28.01	14862408.0
2016-04-13 16:00:00	AAPL	Stock	28.01	28.0175	28.0	28.0	5328144.0
2016-04-13 16:30:00	AAPL	Stock	27.9975	28.0025	27.9925	28.0025	21764.0
2016-04-13 17:00:00	AAPL	Stock	27.9925	28.025	27.985	28.0	160592.0
2016-04-13 17:30:00	AAPL	Stock	28.0	28.025	28.0	28.025	20988.0
2016-04-13 18:00:00	AAPL	Stock	28.0125	28.025	28.0125	28.025	7032.0
2016-04-13 18:30:00	AAPL	Stock	28.0125	28.025	28.0125	28.0125	6408.0
2016-04-13 19:00:00	AAPL	Stock	28.015	28.025	28.0125	28.015	8820.0
2016-04-13 19:30:00	AAPL	Stock	28.02	28.0425	28.02	28.0325	42652.0
2016-04-13 05:00:00	MSFT	Stock	54.89	54.89	54.89	54.89	100.0
2016-04-13 07:30:00	MSFT	Stock	54.97	54.97	54.97	54.97	200.0
2016-04-13 08:00:00	MSFT	Stock	54.98	55.0	54.97	54.97	6171.0
2016-04-13 08:30:00	MSFT	Stock	55.0	55.02	54.9	54.96	3500.0
2016-04-13 09:00:00	MSFT	Stock	54.99	55.1	54.99	55.1	30410.0
2016-04-13 09:30:00	MSFT	Stock	55.11	55.32	54.93	55.21	2590993.0
2016-04-13 10:00:00	MSFT	Stock	55.22	55.29	54.99	55.145	1363079.0
2016-04-13 10:30:00	MSFT	Stock	55.15	55.16	54.975	54.99	1221252.0
2016-04-13 11:00:00	MSFT	Stock	54.99	55.145	54.95	55.12	1143517.0
2016-04-13 11:30:00	MSFT	Stock	55.12	55.21	55.085	55.105	1086257.0
2016-04-13 12:00:00	MSFT	Stock	55.105	55.145	55.0	55.1	750909.0
2016-04-13 12:30:00	MSFT	Stock	55.1	55.12	54.995	55.0	762078.0
2016-04-13 13:00:00	MSFT	Stock	55.0	55.06	54.895	54.955	935939.0
2016-04-13 13:30:00	MSFT	Stock	54.96	55.09	54.89	55.06	1207182.0
2016-04-13 14:00:00	MSFT	Stock	55.06	55.21	55.02	55.14	917829.0
2016-04-13 14:30:00	MSFT	Stock	55.14	55.24	55.14	55.195	744525.0
2016-04-13 15:00:00	MSFT	Stock	55.19	55.35	55.18	55.315	1166023.0
2016-04-13 15:30:00	MSFT	Stock	55.31	55.438	55.295	55.35	2855553.0

> showing 50 of 83,048 rows — these rows as CSV

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