PREVIEW / stock_30min / 2009-04-13

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-13.parquet
  size:    1.2 MB
  rows:    68,737
  symbols: 3,339

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
2009-04-13 04:00:00	AAPL	Stock	4.2857	4.2857	4.2857	4.2857	5600.0
2009-04-13 04:30:00	AAPL	Stock	4.2946	4.2946	4.2946	4.2946	2800.0
2009-04-13 06:00:00	AAPL	Stock	4.2857	4.2857	4.2857	4.2857	2800.0
2009-04-13 06:30:00	AAPL	Stock	4.2768	4.2768	4.2768	4.2768	2800.0
2009-04-13 07:00:00	AAPL	Stock	4.2679	4.2679	4.25	4.25	11200.0
2009-04-13 07:30:00	AAPL	Stock	4.2504	4.2596	4.2504	4.2596	30800.0
2009-04-13 08:00:00	AAPL	Stock	4.2646	4.2786	4.2514	4.2768	410368.0
2009-04-13 08:30:00	AAPL	Stock	4.2821	4.2857	4.2679	4.2786	245028.0
2009-04-13 09:00:00	AAPL	Stock	4.2821	4.2911	4.2768	4.2857	1807848.0
2009-04-13 09:30:00	AAPL	Stock	4.2857	4.3129	4.25	4.2646	76487936.0
2009-04-13 10:00:00	AAPL	Stock	4.2654	4.3179	4.2629	4.3032	44557856.0
2009-04-13 10:30:00	AAPL	Stock	4.3036	4.3057	4.2643	4.2681	33446224.0
2009-04-13 11:00:00	AAPL	Stock	4.2682	4.2836	4.2607	4.2768	21035140.0
2009-04-13 11:30:00	AAPL	Stock	4.2771	4.3118	4.2596	4.2757	21316316.0
2009-04-13 12:00:00	AAPL	Stock	4.2757	4.285	4.2736	4.2822	12258540.0
2009-04-13 12:30:00	AAPL	Stock	4.2822	4.3107	4.2821	4.3083	17260012.0
2009-04-13 13:00:00	AAPL	Stock	4.3075	4.3196	4.2971	4.3104	17955840.0
2009-04-13 13:30:00	AAPL	Stock	4.3111	4.3171	4.3007	4.3075	15380400.0
2009-04-13 14:00:00	AAPL	Stock	4.3079	4.3114	4.2879	4.2932	18879840.0
2009-04-13 14:30:00	AAPL	Stock	4.2936	4.3032	4.2886	4.2907	15006600.0
2009-04-13 15:00:00	AAPL	Stock	4.2907	4.3207	4.2857	4.3136	29903580.0
2009-04-13 15:30:00	AAPL	Stock	4.3129	4.3143	4.2932	4.2932	49916244.0
2009-04-13 16:00:00	AAPL	Stock	4.2932	4.3061	4.2861	4.2989	4889920.0
2009-04-13 16:30:00	AAPL	Stock	4.2936	4.2982	4.2893	4.2936	1043476.0
2009-04-13 17:00:00	AAPL	Stock	4.2914	4.3068	4.2911	4.2911	220444.0
2009-04-13 17:30:00	AAPL	Stock	4.2904	4.2939	4.2871	4.2925	114492.0
2009-04-13 18:00:00	AAPL	Stock	4.2936	4.2964	4.2921	4.2964	178192.0
2009-04-13 18:30:00	AAPL	Stock	4.2936	4.2936	4.2875	4.2893	91868.0
2009-04-13 19:00:00	AAPL	Stock	4.2886	4.2921	4.2886	4.29	82600.0
2009-04-13 19:30:00	AAPL	Stock	4.2946	4.2946	4.2911	4.2911	49000.0
2009-04-13 07:00:00	MSFT	Stock	19.24	19.24	19.24	19.24	300.0
2009-04-13 07:30:00	MSFT	Stock	19.67	19.67	19.64	19.65	3000.0
2009-04-13 08:00:00	MSFT	Stock	19.65	19.86	19.65	19.79	37515.0
2009-04-13 08:30:00	MSFT	Stock	19.8	19.8	19.76	19.78	9028.0
2009-04-13 09:00:00	MSFT	Stock	19.78	19.79	19.69	19.69	33897.0
2009-04-13 09:30:00	MSFT	Stock	19.68	19.85	19.49	19.5	6817138.0
2009-04-13 10:00:00	MSFT	Stock	19.5	19.85	19.41	19.45	3914377.0
2009-04-13 10:30:00	MSFT	Stock	19.46	19.49	19.38	19.42	2749086.0
2009-04-13 11:00:00	MSFT	Stock	19.42	19.52	19.37	19.51	3354096.0
2009-04-13 11:30:00	MSFT	Stock	19.5	19.84	19.47	19.51	1948103.0
2009-04-13 12:00:00	MSFT	Stock	19.5	19.55	19.5	19.52	1413669.0
2009-04-13 12:30:00	MSFT	Stock	19.52	19.59	19.52	19.58	1443250.0
2009-04-13 13:00:00	MSFT	Stock	19.58	19.67	19.56	19.65	1790541.0
2009-04-13 13:30:00	MSFT	Stock	19.65	19.66	19.6	19.615	1829104.0
2009-04-13 14:00:00	MSFT	Stock	19.62	19.63	19.54	19.54	2178878.0
2009-04-13 14:30:00	MSFT	Stock	19.54	19.58	19.51	19.518	1784102.0
2009-04-13 15:00:00	MSFT	Stock	19.51	19.72	19.5	19.69	4952949.0
2009-04-13 15:30:00	MSFT	Stock	19.69	19.78	19.58	19.59	8118086.0
2009-04-13 16:00:00	MSFT	Stock	19.58	19.657	19.56	19.6	1094750.0
2009-04-13 16:30:00	MSFT	Stock	19.59	19.7	19.58	19.65	169241.0

> showing 50 of 68,737 rows — these rows as CSV

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