PREVIEW / stock_30min / 2010-08-03

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-03.parquet
  size:    1.4 MB
  rows:    72,903
  symbols: 3,481

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
2010-08-03 04:00:00	AAPL	Stock	9.3561	9.3561	9.3561	9.3561	5600.0
2010-08-03 06:00:00	AAPL	Stock	9.3532	9.3532	9.3532	9.3532	2800.0
2010-08-03 07:00:00	AAPL	Stock	9.3536	9.3536	9.3536	9.3536	38920.0
2010-08-03 07:30:00	AAPL	Stock	9.345	9.3461	9.3393	9.3393	24780.0
2010-08-03 08:00:00	AAPL	Stock	9.3393	9.3461	9.3261	9.33	208012.0
2010-08-03 08:30:00	AAPL	Stock	9.3307	9.3496	9.3218	9.3475	381416.0
2010-08-03 09:00:00	AAPL	Stock	9.3446	9.3493	9.3182	9.3229	403872.0
2010-08-03 09:30:00	AAPL	Stock	9.3218	9.3386	9.2757	9.2886	49585704.0
2010-08-03 10:00:00	AAPL	Stock	9.2879	9.2946	9.265	9.2789	38648596.0
2010-08-03 10:30:00	AAPL	Stock	9.2768	9.323	9.2732	9.3186	27200516.0
2010-08-03 11:00:00	AAPL	Stock	9.32	9.3446	9.2959	9.3314	21417312.0
2010-08-03 11:30:00	AAPL	Stock	9.3299	9.4021	9.3282	9.3932	50159116.0
2010-08-03 12:00:00	AAPL	Stock	9.3925	9.3936	9.3104	9.3215	37334808.0
2010-08-03 12:30:00	AAPL	Stock	9.3221	9.3571	9.3204	9.3443	24060316.0
2010-08-03 13:00:00	AAPL	Stock	9.3429	9.3554	9.3271	9.3507	15579928.0
2010-08-03 13:30:00	AAPL	Stock	9.3515	9.3764	9.3496	9.3621	19173476.0
2010-08-03 14:00:00	AAPL	Stock	9.3632	9.3693	9.3421	9.3693	16593640.0
2010-08-03 14:30:00	AAPL	Stock	9.3693	9.3743	9.35	9.3639	16520420.0
2010-08-03 15:00:00	AAPL	Stock	9.364	9.3668	9.3361	9.3439	18900504.0
2010-08-03 15:30:00	AAPL	Stock	9.3446	9.3557	9.3268	9.3543	38844708.0
2010-08-03 16:00:00	AAPL	Stock	9.3546	9.3829	9.3099	9.3571	38302740.0
2010-08-03 16:30:00	AAPL	Stock	9.3571	9.36	9.3444	9.3582	147840.0
2010-08-03 17:00:00	AAPL	Stock	9.3669	9.3669	9.3582	9.3661	416080.0
2010-08-03 17:30:00	AAPL	Stock	9.3661	9.3661	9.3614	9.3643	124600.0
2010-08-03 18:00:00	AAPL	Stock	9.3646	9.3754	9.3546	9.3643	485324.0
2010-08-03 18:30:00	AAPL	Stock	9.3582	9.3746	9.3439	9.3446	475720.0
2010-08-03 19:00:00	AAPL	Stock	9.3482	9.3496	9.3461	9.3461	30800.0
2010-08-03 19:30:00	AAPL	Stock	9.3457	9.3496	9.3457	9.3468	133504.0
2010-08-03 07:00:00	MSFT	Stock	26.27	26.27	26.26	26.26	1600.0
2010-08-03 08:00:00	MSFT	Stock	26.26	26.26	26.24	26.25	3500.0
2010-08-03 08:30:00	MSFT	Stock	26.24	26.24	26.19	26.19	5400.0
2010-08-03 09:00:00	MSFT	Stock	26.19	26.27	26.14	26.2	59362.0
2010-08-03 09:30:00	MSFT	Stock	26.2	26.35	26.19	26.2	6591983.0
2010-08-03 10:00:00	MSFT	Stock	26.2	26.264	26.13	26.205	3897125.0
2010-08-03 10:30:00	MSFT	Stock	26.215	26.28	26.2	26.275	3312816.0
2010-08-03 11:00:00	MSFT	Stock	26.29	26.32	26.26	26.274	2480464.0
2010-08-03 11:30:00	MSFT	Stock	26.276	26.3	26.16	26.19	2814987.0
2010-08-03 12:00:00	MSFT	Stock	26.195	26.2	26.01	26.01	4052311.0
2010-08-03 12:30:00	MSFT	Stock	26.01	26.168	25.97	26.0	5266297.0
2010-08-03 13:00:00	MSFT	Stock	26.005	26.03	25.97	26.01	3486175.0
2010-08-03 13:30:00	MSFT	Stock	26.01	26.03	25.97	25.97	2991034.0
2010-08-03 14:00:00	MSFT	Stock	25.97	26.09	25.97	26.08	4705298.0
2010-08-03 14:30:00	MSFT	Stock	26.09	26.1	26.03	26.06	2037261.0
2010-08-03 15:00:00	MSFT	Stock	26.065	26.1	26.02	26.07	2195237.0
2010-08-03 15:30:00	MSFT	Stock	26.07	26.15	26.02	26.13	6156279.0
2010-08-03 16:00:00	MSFT	Stock	26.16	26.18	26.048	26.18	6392092.0
2010-08-03 16:30:00	MSFT	Stock	26.18	26.19	26.06	26.19	21400.0
2010-08-03 17:00:00	MSFT	Stock	26.19	26.22	26.19	26.19	7087.0
2010-08-03 17:30:00	MSFT	Stock	26.16	26.2	26.12	26.2	11663.0
2010-08-03 18:00:00	MSFT	Stock	26.2	26.2	26.16	26.16	10129.0

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

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