PREVIEW / stock_30min / 2015-06-19

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-19.parquet
  size:    1.6 MB
  rows:    83,367
  symbols: 3,514

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-06-19 04:00:00	AAPL	Stock	32.0	32.0375	32.0	32.01	2000.0
2015-06-19 05:30:00	AAPL	Stock	32.0325	32.0325	32.0075	32.0075	8800.0
2015-06-19 06:00:00	AAPL	Stock	32.03	32.03	32.03	32.03	5200.0
2015-06-19 06:30:00	AAPL	Stock	32.0375	32.0375	32.0125	32.0125	10012.0
2015-06-19 07:00:00	AAPL	Stock	32.035	32.0375	32.015	32.015	12000.0
2015-06-19 07:30:00	AAPL	Stock	32.02	32.035	32.0175	32.02	24192.0
2015-06-19 08:00:00	AAPL	Stock	32.0275	32.04	31.9125	32.025	177908.0
2015-06-19 08:30:00	AAPL	Stock	32.025	32.025	31.9925	32.005	194092.0
2015-06-19 09:00:00	AAPL	Stock	32.01	32.02	31.895	31.9325	1729520.0
2015-06-19 09:30:00	AAPL	Stock	31.9325	31.955	31.82	31.8825	52514392.0
2015-06-19 10:00:00	AAPL	Stock	31.8875	31.905	31.82	31.83	10482388.0
2015-06-19 10:30:00	AAPL	Stock	31.83	31.8575	31.795	31.8425	9305104.0
2015-06-19 11:00:00	AAPL	Stock	31.8425	31.8475	31.8	31.8175	6116404.0
2015-06-19 11:30:00	AAPL	Stock	31.8175	31.8225	31.7	31.7175	10030220.0
2015-06-19 12:00:00	AAPL	Stock	31.7125	31.7175	31.6762	31.681	6629580.0
2015-06-19 12:30:00	AAPL	Stock	31.68	31.7225	31.6675	31.7188	5681168.0
2015-06-19 13:00:00	AAPL	Stock	31.7188	31.79	31.7168	31.7425	5843912.0
2015-06-19 13:30:00	AAPL	Stock	31.745	31.78	31.7425	31.7625	4388904.0
2015-06-19 14:00:00	AAPL	Stock	31.765	31.7725	31.72	31.7312	5491428.0
2015-06-19 14:30:00	AAPL	Stock	31.7325	31.74	31.6875	31.7075	5620812.0
2015-06-19 15:00:00	AAPL	Stock	31.7075	31.725	31.6475	31.655	8018312.0
2015-06-19 15:30:00	AAPL	Stock	31.655	31.725	31.6	31.605	20778848.0
2015-06-19 16:00:00	AAPL	Stock	31.65	31.665	31.605	31.6575	29172884.0
2015-06-19 16:30:00	AAPL	Stock	31.6575	31.67	31.655	31.665	295248.0
2015-06-19 17:00:00	AAPL	Stock	31.6625	31.675	31.6525	31.6575	70864.0
2015-06-19 17:30:00	AAPL	Stock	31.68	31.68	31.65	31.655	42396.0
2015-06-19 18:00:00	AAPL	Stock	31.6625	31.6625	31.65	31.6525	39356.0
2015-06-19 18:30:00	AAPL	Stock	31.6525	31.655	31.65	31.6518	43976.0
2015-06-19 19:00:00	AAPL	Stock	31.6525	31.66	31.65	31.655	575940.0
2015-06-19 19:30:00	AAPL	Stock	31.6375	31.655	31.6375	31.655	13008.0
2015-06-19 06:00:00	MSFT	Stock	46.89	46.9	46.85	46.85	8915.0
2015-06-19 06:30:00	MSFT	Stock	46.88	46.88	46.83	46.83	1393.0
2015-06-19 07:00:00	MSFT	Stock	46.84	46.85	46.84	46.85	450.0
2015-06-19 07:30:00	MSFT	Stock	46.85	46.85	46.85	46.85	100.0
2015-06-19 08:00:00	MSFT	Stock	46.89	46.9	46.8	46.9	2607.0
2015-06-19 08:30:00	MSFT	Stock	46.86	46.9	46.81	46.87	7774.0
2015-06-19 09:00:00	MSFT	Stock	46.87	46.92	46.71	46.79	270057.0
2015-06-19 09:30:00	MSFT	Stock	46.79	46.825	46.25	46.28	14692432.0
2015-06-19 10:00:00	MSFT	Stock	46.27	46.42	46.27	46.28	1503703.0
2015-06-19 10:30:00	MSFT	Stock	46.28	46.345	46.19	46.315	1602474.0
2015-06-19 11:00:00	MSFT	Stock	46.32	46.33	46.15	46.23	1209291.0
2015-06-19 11:30:00	MSFT	Stock	46.23	46.24	46.04	46.08	1223083.0
2015-06-19 12:00:00	MSFT	Stock	46.07	46.116	45.99	46.07	1089750.0
2015-06-19 12:30:00	MSFT	Stock	46.065	46.13	46.01	46.1	819652.0
2015-06-19 13:00:00	MSFT	Stock	46.101	46.11	46.03	46.09	886116.0
2015-06-19 13:30:00	MSFT	Stock	46.1	46.18	46.095	46.18	963867.0
2015-06-19 14:00:00	MSFT	Stock	46.17	46.18	46.06	46.115	1304980.0
2015-06-19 14:30:00	MSFT	Stock	46.11	46.13	46.06	46.1	1341694.0
2015-06-19 15:00:00	MSFT	Stock	46.1	46.11	46.0	46.009	1579968.0
2015-06-19 15:30:00	MSFT	Stock	46.0	46.17	45.99	46.02	5861936.0

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

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