PREVIEW / stock_30min / 2015-07-24

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-24.parquet
  size:    1.6 MB
  rows:    81,681
  symbols: 3,484

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-07-24 04:00:00	AAPL	Stock	31.3625	31.4025	31.35	31.4025	16400.0
2015-07-24 04:30:00	AAPL	Stock	31.4125	31.4125	31.395	31.4075	10208.0
2015-07-24 05:00:00	AAPL	Stock	31.3975	31.3975	31.3575	31.3575	34512.0
2015-07-24 05:30:00	AAPL	Stock	31.3875	31.3875	31.3875	31.3875	400.0
2015-07-24 06:00:00	AAPL	Stock	31.3875	31.4125	31.345	31.4125	2000.0
2015-07-24 06:30:00	AAPL	Stock	31.385	31.395	31.3625	31.375	49048.0
2015-07-24 07:00:00	AAPL	Stock	31.3875	31.395	31.3625	31.375	59940.0
2015-07-24 07:30:00	AAPL	Stock	31.3775	31.3775	31.325	31.3375	71724.0
2015-07-24 08:00:00	AAPL	Stock	31.345	31.4	31.2625	31.3475	473848.0
2015-07-24 08:30:00	AAPL	Stock	31.3412	31.3775	31.32	31.32	374900.0
2015-07-24 09:00:00	AAPL	Stock	31.32	31.375	31.3025	31.3475	520052.0
2015-07-24 09:30:00	AAPL	Stock	31.335	31.4125	31.15	31.3525	24291716.0
2015-07-24 10:00:00	AAPL	Stock	31.3525	31.435	31.2575	31.295	12882388.0
2015-07-24 10:30:00	AAPL	Stock	31.295	31.3875	31.2575	31.34	10370880.0
2015-07-24 11:00:00	AAPL	Stock	31.34	31.3975	31.2775	31.3325	6944840.0
2015-07-24 11:30:00	AAPL	Stock	31.3325	31.3675	31.2225	31.2825	7226156.0
2015-07-24 12:00:00	AAPL	Stock	31.2825	31.2838	31.2025	31.2175	6512064.0
2015-07-24 12:30:00	AAPL	Stock	31.2142	31.2325	31.1	31.105	9176572.0
2015-07-24 13:00:00	AAPL	Stock	31.1075	31.1725	31.045	31.1	9172012.0
2015-07-24 13:30:00	AAPL	Stock	31.1	31.1025	30.975	31.075	11246136.0
2015-07-24 14:00:00	AAPL	Stock	31.0725	31.0875	30.99	31.0325	8312560.0
2015-07-24 14:30:00	AAPL	Stock	31.03	31.125	31.0025	31.11	8001392.0
2015-07-24 15:00:00	AAPL	Stock	31.1118	31.245	31.0525	31.1675	12515924.0
2015-07-24 15:30:00	AAPL	Stock	31.1688	31.2075	31.085	31.125	19823444.0
2015-07-24 16:00:00	AAPL	Stock	31.115	31.3155	31.1075	31.1425	7034656.0
2015-07-24 16:30:00	AAPL	Stock	31.1425	31.175	31.1425	31.1525	111380.0
2015-07-24 17:00:00	AAPL	Stock	31.1525	31.185	31.1525	31.1725	88040.0
2015-07-24 17:30:00	AAPL	Stock	31.1508	31.175	31.15	31.1675	13416.0
2015-07-24 18:00:00	AAPL	Stock	31.1725	31.175	31.1525	31.1525	27336.0
2015-07-24 18:30:00	AAPL	Stock	31.165	31.1675	31.1475	31.1475	48516.0
2015-07-24 19:00:00	AAPL	Stock	31.1475	31.15	31.1275	31.1425	46212.0
2015-07-24 19:30:00	AAPL	Stock	31.13	31.1475	31.13	31.1325	106032.0
2015-07-24 05:00:00	MSFT	Stock	46.25	46.25	46.25	46.25	100.0
2015-07-24 06:30:00	MSFT	Stock	46.1	46.11	46.1	46.1	3800.0
2015-07-24 07:00:00	MSFT	Stock	46.1	46.1	46.1	46.1	900.0
2015-07-24 07:30:00	MSFT	Stock	46.11	46.11	46.0	46.0	1275.0
2015-07-24 08:00:00	MSFT	Stock	46.03	46.03	45.81	45.81	3920.0
2015-07-24 08:30:00	MSFT	Stock	45.85	45.86	45.8	45.8	3900.0
2015-07-24 09:00:00	MSFT	Stock	45.8	46.02	45.77	46.0	42705.0
2015-07-24 09:30:00	MSFT	Stock	46.0	46.26	45.8	46.055	3221703.0
2015-07-24 10:00:00	MSFT	Stock	46.07	46.15	45.8	45.89	2343332.0
2015-07-24 10:30:00	MSFT	Stock	45.9	46.12	45.85	46.06	1648422.0
2015-07-24 11:00:00	MSFT	Stock	46.06	46.13	45.96	46.03	1638788.0
2015-07-24 11:30:00	MSFT	Stock	46.035	46.32	46.03	46.18	1285316.0
2015-07-24 12:00:00	MSFT	Stock	46.19	46.25	46.025	46.03	916344.0
2015-07-24 12:30:00	MSFT	Stock	46.04	46.09	45.995	46.055	915861.0
2015-07-24 13:00:00	MSFT	Stock	46.05	46.17	46.05	46.14	893480.0
2015-07-24 13:30:00	MSFT	Stock	46.14	46.15	46.02	46.12	1540807.0
2015-07-24 14:00:00	MSFT	Stock	46.13	46.17	45.98	45.98	2124755.0
2015-07-24 14:30:00	MSFT	Stock	45.98	46.0	45.83	45.97	2103758.0

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

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