PREVIEW / stock_30min / 2009-02-03

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-02-03.parquet
  size:    1.2 MB
  rows:    68,159
  symbols: 3,272

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-02-03 07:00:00	AAPL	Stock	3.2679	3.2679	3.2675	3.2675	8400.0
2009-02-03 07:30:00	AAPL	Stock	3.2736	3.2779	3.2736	3.2779	53200.0
2009-02-03 08:00:00	AAPL	Stock	3.2675	3.275	3.2675	3.2675	195076.0
2009-02-03 08:30:00	AAPL	Stock	3.2643	3.2829	3.2643	3.2814	245700.0
2009-02-03 09:00:00	AAPL	Stock	3.2829	3.2957	3.2782	3.2804	1268232.0
2009-02-03 09:30:00	AAPL	Stock	3.2821	3.29	3.2243	3.2418	82812464.0
2009-02-03 10:00:00	AAPL	Stock	3.2418	3.28	3.2396	3.2714	61272036.0
2009-02-03 10:30:00	AAPL	Stock	3.2714	3.3036	3.2686	3.2943	49835912.0
2009-02-03 11:00:00	AAPL	Stock	3.295	3.3104	3.2929	3.3054	34200180.0
2009-02-03 11:30:00	AAPL	Stock	3.3061	3.3075	3.2879	3.2925	25090156.0
2009-02-03 12:00:00	AAPL	Stock	3.2925	3.2971	3.2746	3.2882	27781936.0
2009-02-03 12:30:00	AAPL	Stock	3.2882	3.2979	3.2843	3.285	22444996.0
2009-02-03 13:00:00	AAPL	Stock	3.2846	3.2882	3.2707	3.2736	29757896.0
2009-02-03 13:30:00	AAPL	Stock	3.2739	3.2946	3.2711	3.2854	26310564.0
2009-02-03 14:00:00	AAPL	Stock	3.2857	3.3096	3.2829	3.3004	39325328.0
2009-02-03 14:30:00	AAPL	Stock	3.3007	3.3214	3.2993	3.3111	36817060.0
2009-02-03 15:00:00	AAPL	Stock	3.3107	3.3286	3.3046	3.3261	46159428.0
2009-02-03 15:30:00	AAPL	Stock	3.3257	3.335	3.3107	3.32	75011804.0
2009-02-03 16:00:00	AAPL	Stock	3.3193	3.3214	3.2755	3.3115	16720116.0
2009-02-03 16:30:00	AAPL	Stock	3.2915	3.3207	3.2915	3.3129	4696860.0
2009-02-03 17:00:00	AAPL	Stock	3.3125	3.3161	3.3125	3.3132	166180.0
2009-02-03 17:30:00	AAPL	Stock	3.3161	3.3161	3.3139	3.3143	236320.0
2009-02-03 18:00:00	AAPL	Stock	3.3207	3.3207	3.31	3.31	16219812.0
2009-02-03 18:30:00	AAPL	Stock	3.3075	3.31	3.3075	3.31	13972.0
2009-02-03 19:30:00	AAPL	Stock	3.3125	3.3125	3.3082	3.3104	106288.0
2009-02-03 05:30:00	MSFT	Stock	17.67	17.67	17.67	17.67	100.0
2009-02-03 07:30:00	MSFT	Stock	17.8	17.85	17.8	17.85	3774.0
2009-02-03 08:00:00	MSFT	Stock	17.9	17.96	17.9	17.96	9372.0
2009-02-03 08:30:00	MSFT	Stock	17.94	17.96	17.9	17.95	6549.0
2009-02-03 09:00:00	MSFT	Stock	17.96	17.96	17.84	17.85	36009.0
2009-02-03 09:30:00	MSFT	Stock	17.85	17.96	17.6	17.72	5574656.0
2009-02-03 10:00:00	MSFT	Stock	17.72	17.82	17.7	17.8	4058095.0
2009-02-03 10:30:00	MSFT	Stock	17.79	18.09	17.77	18.05	5181099.0
2009-02-03 11:00:00	MSFT	Stock	18.05	18.26	18.04	18.25	5638269.0
2009-02-03 11:30:00	MSFT	Stock	18.25	18.28	18.16	18.172	4766942.0
2009-02-03 12:00:00	MSFT	Stock	18.17	18.19	18.03	18.078	4417487.0
2009-02-03 12:30:00	MSFT	Stock	18.08	18.14	18.01	18.01	4845594.0
2009-02-03 13:00:00	MSFT	Stock	18.02	18.088	17.95	18.011	3361831.0
2009-02-03 13:30:00	MSFT	Stock	18.01	18.12	18.01	18.082	2204558.0
2009-02-03 14:00:00	MSFT	Stock	18.09	18.24	18.09	18.22	4589338.0
2009-02-03 14:30:00	MSFT	Stock	18.23	18.38	18.21	18.24	7508382.0
2009-02-03 15:00:00	MSFT	Stock	18.23	18.58	18.23	18.57	10002443.0
2009-02-03 15:30:00	MSFT	Stock	18.58	18.61	18.42	18.5	15332578.0
2009-02-03 16:00:00	MSFT	Stock	18.51	18.52	18.035	18.212	6639762.0
2009-02-03 16:30:00	MSFT	Stock	18.5	18.5	18.41	18.47	810652.0
2009-02-03 17:00:00	MSFT	Stock	18.42	18.44	18.42	18.44	2056.0
2009-02-03 17:30:00	MSFT	Stock	18.43	18.44	18.43	18.44	1900.0
2009-02-03 18:00:00	MSFT	Stock	18.43	18.5	18.43	18.43	490618.0
2009-02-03 18:30:00	MSFT	Stock	18.45	18.45	18.42	18.42	4695.0
2009-02-03 19:00:00	MSFT	Stock	18.42	18.45	18.42	18.45	8340.0

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

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