PREVIEW / stock_30min / 2011-12-23

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-23.parquet
  size:    1.3 MB
  rows:    72,761
  symbols: 3,569

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
2011-12-23 04:00:00	AAPL	Stock	14.2657	14.2657	14.2657	14.2657	8680.0
2011-12-23 04:30:00	AAPL	Stock	14.2411	14.2411	14.2411	14.2411	2800.0
2011-12-23 05:00:00	AAPL	Stock	14.25	14.25	14.2457	14.2457	5600.0
2011-12-23 05:30:00	AAPL	Stock	14.2457	14.2457	14.2457	14.2457	5600.0
2011-12-23 07:00:00	AAPL	Stock	14.2614	14.2889	14.2607	14.2804	324688.0
2011-12-23 07:30:00	AAPL	Stock	14.2768	14.2854	14.2714	14.2854	130872.0
2011-12-23 08:00:00	AAPL	Stock	14.2736	14.3036	14.2736	14.2932	1634948.0
2011-12-23 08:30:00	AAPL	Stock	14.3014	14.3018	14.2639	14.2725	970872.0
2011-12-23 09:00:00	AAPL	Stock	14.2729	14.2868	14.2679	14.2786	601132.0
2011-12-23 09:30:00	AAPL	Stock	14.2746	14.3132	14.2677	14.2896	41777176.0
2011-12-23 10:00:00	AAPL	Stock	14.2889	14.3029	14.2714	14.2854	20477548.0
2011-12-23 10:30:00	AAPL	Stock	14.2836	14.2964	14.2818	14.295	10093804.0
2011-12-23 11:00:00	AAPL	Stock	14.2964	14.3036	14.2911	14.3025	11846716.0
2011-12-23 11:30:00	AAPL	Stock	14.3036	14.3286	14.3025	14.3279	15600564.0
2011-12-23 12:00:00	AAPL	Stock	14.3279	14.3482	14.3189	14.345	16487912.0
2011-12-23 12:30:00	AAPL	Stock	14.3446	14.4068	14.3421	14.4046	24382680.0
2011-12-23 13:00:00	AAPL	Stock	14.4046	14.405	14.3479	14.3654	21809592.0
2011-12-23 13:30:00	AAPL	Stock	14.3654	14.3689	14.3536	14.3643	9739408.0
2011-12-23 14:00:00	AAPL	Stock	14.3643	14.3663	14.3421	14.3425	12553912.0
2011-12-23 14:30:00	AAPL	Stock	14.3432	14.3461	14.3179	14.3261	12738600.0
2011-12-23 15:00:00	AAPL	Stock	14.3263	14.3318	14.3182	14.3268	11974228.0
2011-12-23 15:30:00	AAPL	Stock	14.3257	14.4139	14.3254	14.4064	47923316.0
2011-12-23 16:00:00	AAPL	Stock	14.4064	14.4111	14.2933	14.4039	4698344.0
2011-12-23 16:30:00	AAPL	Stock	14.4107	14.415	14.3652	14.415	160076.0
2011-12-23 17:00:00	AAPL	Stock	14.4107	14.4107	14.4046	14.4046	97720.0
2011-12-23 17:30:00	AAPL	Stock	14.41	14.4125	14.4036	14.405	35980.0
2011-12-23 18:00:00	AAPL	Stock	14.4046	14.4046	14.4	14.4029	75656.0
2011-12-23 18:30:00	AAPL	Stock	14.3968	14.3986	14.3964	14.3968	69580.0
2011-12-23 19:00:00	AAPL	Stock	14.3968	14.4	14.3929	14.4	58772.0
2011-12-23 19:30:00	AAPL	Stock	14.3964	14.3996	14.3946	14.3946	42196.0
2011-12-23 08:00:00	MSFT	Stock	25.86	25.86	25.8	25.84	3830.0
2011-12-23 08:30:00	MSFT	Stock	25.84	25.88	25.84	25.88	6250.0
2011-12-23 09:00:00	MSFT	Stock	25.86	25.94	25.86	25.94	10928.0
2011-12-23 09:30:00	MSFT	Stock	25.94	25.95	25.73	25.85	3048942.0
2011-12-23 10:00:00	MSFT	Stock	25.85	25.86	25.73	25.805	1237758.0
2011-12-23 10:30:00	MSFT	Stock	25.81	25.84	25.76	25.84	1323543.0
2011-12-23 11:00:00	MSFT	Stock	25.84	25.93	25.83	25.922	1721809.0
2011-12-23 11:30:00	MSFT	Stock	25.93	25.96	25.91	25.93	2060657.0
2011-12-23 12:00:00	MSFT	Stock	25.93	25.97	25.92	25.962	1107269.0
2011-12-23 12:30:00	MSFT	Stock	25.965	26.0	25.96	25.989	1070948.0
2011-12-23 13:00:00	MSFT	Stock	25.985	26.0	25.96	25.969	1112278.0
2011-12-23 13:30:00	MSFT	Stock	25.965	26.04	25.96	26.015	1206642.0
2011-12-23 14:00:00	MSFT	Stock	26.01	26.02	25.97	25.975	931858.0
2011-12-23 14:30:00	MSFT	Stock	25.98	25.98	25.95	25.97	859260.0
2011-12-23 15:00:00	MSFT	Stock	25.97	25.97	25.95	25.965	941001.0
2011-12-23 15:30:00	MSFT	Stock	25.96	26.03	25.95	26.02	4434582.0
2011-12-23 16:00:00	MSFT	Stock	26.02	26.033	25.928	26.03	1786433.0
2011-12-23 16:30:00	MSFT	Stock	26.03	26.03	25.87	25.915	22992.0
2011-12-23 17:00:00	MSFT	Stock	25.99	26.02	25.99	26.02	4450.0
2011-12-23 18:00:00	MSFT	Stock	26.02	26.03	26.02	26.02	5900.0

> showing 50 of 72,761 rows — these rows as CSV

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