PREVIEW / stock_30min / 2012-05-25

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-25.parquet
  size:    1.4 MB
  rows:    74,656
  symbols: 3,513

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
2012-05-25 04:00:00	AAPL	Stock	20.25	20.3357	20.25	20.3214	71400.0
2012-05-25 04:30:00	AAPL	Stock	20.3143	20.3143	20.3	20.3	9800.0
2012-05-25 06:00:00	AAPL	Stock	20.3104	20.3104	20.3036	20.3036	8400.0
2012-05-25 06:30:00	AAPL	Stock	20.3036	20.3036	20.2321	20.2321	42000.0
2012-05-25 07:00:00	AAPL	Stock	20.2857	20.2857	20.2357	20.2711	125440.0
2012-05-25 07:30:00	AAPL	Stock	20.2429	20.275	20.2321	20.2436	152040.0
2012-05-25 08:00:00	AAPL	Stock	20.25	20.2946	20.1346	20.1507	1190420.0
2012-05-25 08:30:00	AAPL	Stock	20.1507	20.1782	20.0911	20.1429	1131452.0
2012-05-25 09:00:00	AAPL	Stock	20.1361	20.1661	20.1182	20.1607	1197532.0
2012-05-25 09:30:00	AAPL	Stock	20.1643	20.2089	19.9679	20.0632	67823000.0
2012-05-25 10:00:00	AAPL	Stock	20.0604	20.0779	19.9832	20.0311	29233512.0
2012-05-25 10:30:00	AAPL	Stock	20.0293	20.0919	19.9868	19.9907	24815308.0
2012-05-25 11:00:00	AAPL	Stock	19.9936	20.0429	19.9907	20.025	16910684.0
2012-05-25 11:30:00	AAPL	Stock	20.0212	20.0212	19.9454	19.9719	22655584.0
2012-05-25 12:00:00	AAPL	Stock	19.9719	20.0189	19.9575	19.9668	17208016.0
2012-05-25 12:30:00	AAPL	Stock	19.9632	20.0036	19.9518	19.9929	12356400.0
2012-05-25 13:00:00	AAPL	Stock	19.9911	20.0767	19.9768	20.0743	15094296.0
2012-05-25 13:30:00	AAPL	Stock	20.0739	20.1239	20.0264	20.0596	24136252.0
2012-05-25 14:00:00	AAPL	Stock	20.0604	20.0643	19.9893	20.015	14393848.0
2012-05-25 14:30:00	AAPL	Stock	20.0154	20.0564	20.0096	20.0186	12692848.0
2012-05-25 15:00:00	AAPL	Stock	20.02	20.05	20.0107	20.0364	15880984.0
2012-05-25 15:30:00	AAPL	Stock	20.0329	20.0893	20.025	20.0818	39777752.0
2012-05-25 16:00:00	AAPL	Stock	20.0818	20.19	20.0209	20.0209	8314348.0
2012-05-25 16:30:00	AAPL	Stock	20.0886	20.0914	20.0376	20.0879	371784.0
2012-05-25 17:00:00	AAPL	Stock	20.0879	20.1004	20.0875	20.0921	68964.0
2012-05-25 17:30:00	AAPL	Stock	20.0882	20.0943	20.0804	20.0893	53144.0
2012-05-25 18:00:00	AAPL	Stock	20.0825	20.0825	20.0786	20.0821	113372.0
2012-05-25 18:30:00	AAPL	Stock	20.0854	20.0868	20.0821	20.0832	30968.0
2012-05-25 19:00:00	AAPL	Stock	20.0854	20.0871	20.0832	20.085	25480.0
2012-05-25 19:30:00	AAPL	Stock	20.0829	20.0893	20.0804	20.0893	399728.0
2012-05-25 08:00:00	MSFT	Stock	29.19	29.2	29.14	29.14	2600.0
2012-05-25 08:30:00	MSFT	Stock	29.14	29.2	29.07	29.07	14715.0
2012-05-25 09:00:00	MSFT	Stock	29.1	29.2	29.1	29.18	31479.0
2012-05-25 09:30:00	MSFT	Stock	29.17	29.36	29.1	29.31	3516834.0
2012-05-25 10:00:00	MSFT	Stock	29.3	29.33	29.17	29.24	3225094.0
2012-05-25 10:30:00	MSFT	Stock	29.235	29.26	29.05	29.06	2422920.0
2012-05-25 11:00:00	MSFT	Stock	29.06	29.18	29.06	29.155	1524398.0
2012-05-25 11:30:00	MSFT	Stock	29.156	29.17	29.08	29.155	1509129.0
2012-05-25 12:00:00	MSFT	Stock	29.155	29.18	29.1	29.155	1560729.0
2012-05-25 12:30:00	MSFT	Stock	29.15	29.19	29.14	29.17	1089049.0
2012-05-25 13:00:00	MSFT	Stock	29.16	29.18	29.13	29.16	1190516.0
2012-05-25 13:30:00	MSFT	Stock	29.155	29.2	29.15	29.198	1021497.0
2012-05-25 14:00:00	MSFT	Stock	29.2	29.22	29.1	29.105	1874041.0
2012-05-25 14:30:00	MSFT	Stock	29.1	29.14	29.08	29.095	1334927.0
2012-05-25 15:00:00	MSFT	Stock	29.09	29.14	29.01	29.065	1902612.0
2012-05-25 15:30:00	MSFT	Stock	29.065	29.11	29.04	29.05	4336736.0
2012-05-25 16:00:00	MSFT	Stock	29.05	29.148	29.01	29.06	2510573.0
2012-05-25 16:30:00	MSFT	Stock	29.03	29.06	29.03	29.06	4811.0
2012-05-25 17:00:00	MSFT	Stock	29.06	29.06	29.06	29.06	100.0
2012-05-25 18:30:00	MSFT	Stock	29.04	29.04	29.04	29.04	200.0

> showing 50 of 74,656 rows — these rows as CSV

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