PREVIEW / stock_30min / 2008-05-01

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-01.parquet
  size:    1.3 MB
  rows:    68,025
  symbols: 3,285

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
2008-05-01 07:00:00	AAPL	Stock	6.2479	6.2711	6.2464	6.2571	170520.0
2008-05-01 07:30:00	AAPL	Stock	6.2554	6.2643	6.25	6.2611	188104.0
2008-05-01 08:00:00	AAPL	Stock	6.2643	6.2857	6.2125	6.2768	3460212.0
2008-05-01 08:30:00	AAPL	Stock	6.2779	6.2793	6.2125	6.25	2272088.0
2008-05-01 09:00:00	AAPL	Stock	6.2496	6.2546	6.2125	6.2486	3073196.0
2008-05-01 09:30:00	AAPL	Stock	6.2479	6.3279	6.245	6.3132	115893708.0
2008-05-01 10:00:00	AAPL	Stock	6.315	6.3525	6.3045	6.3496	87960852.0
2008-05-01 10:30:00	AAPL	Stock	6.3496	6.3511	6.3118	6.335	55169268.0
2008-05-01 11:00:00	AAPL	Stock	6.3343	6.3757	6.3307	6.3382	67005652.0
2008-05-01 11:30:00	AAPL	Stock	6.3379	6.3696	6.3329	6.3411	42128016.0
2008-05-01 12:00:00	AAPL	Stock	6.3418	6.3857	6.3418	6.3711	48951336.0
2008-05-01 12:30:00	AAPL	Stock	6.3711	6.4089	6.3682	6.3932	68072368.0
2008-05-01 13:00:00	AAPL	Stock	6.3932	6.4107	6.3654	6.3851	55643924.0
2008-05-01 13:30:00	AAPL	Stock	6.385	6.3964	6.3518	6.3711	42402388.0
2008-05-01 14:00:00	AAPL	Stock	6.3705	6.3911	6.3593	6.3793	34984488.0
2008-05-01 14:30:00	AAPL	Stock	6.3789	6.4071	6.3764	6.3897	56959952.0
2008-05-01 15:00:00	AAPL	Stock	6.3896	6.4082	6.3714	6.4029	66376548.0
2008-05-01 15:30:00	AAPL	Stock	6.4029	6.4286	6.3954	6.4286	118985972.0
2008-05-01 16:00:00	AAPL	Stock	6.4276	6.4404	6.3571	6.4357	18864720.0
2008-05-01 16:30:00	AAPL	Stock	6.4411	6.4464	6.4286	6.4393	1456952.0
2008-05-01 17:00:00	AAPL	Stock	6.4361	6.4411	6.4325	6.4339	130228.0
2008-05-01 17:30:00	AAPL	Stock	6.4354	6.4375	6.4296	6.4296	199248.0
2008-05-01 18:00:00	AAPL	Stock	6.4296	6.4357	6.4286	6.4314	365960.0
2008-05-01 18:30:00	AAPL	Stock	6.435	6.4375	6.4321	6.4325	356244.0
2008-05-01 19:00:00	AAPL	Stock	6.4325	6.4336	6.4311	6.4321	107688.0
2008-05-01 19:30:00	AAPL	Stock	6.4339	6.4357	6.4286	6.4293	323120.0
2008-05-01 08:00:00	MSFT	Stock	28.6	28.6	28.49	28.5	35369.0
2008-05-01 08:30:00	MSFT	Stock	28.52	28.52	28.5	28.52	13080.0
2008-05-01 09:00:00	MSFT	Stock	28.5	28.52	28.46	28.49	83749.0
2008-05-01 09:30:00	MSFT	Stock	28.5	28.68	28.48	28.631	5966045.0
2008-05-01 10:00:00	MSFT	Stock	28.64	28.89	28.63	28.85	5529279.0
2008-05-01 10:30:00	MSFT	Stock	28.85	28.88	28.75	28.78	4230321.0
2008-05-01 11:00:00	MSFT	Stock	28.77	28.83	28.71	28.75	3718187.0
2008-05-01 11:30:00	MSFT	Stock	28.76	28.85	28.74	28.81	2718634.0
2008-05-01 12:00:00	MSFT	Stock	28.81	28.94	28.8	28.93	2793355.0
2008-05-01 12:30:00	MSFT	Stock	28.93	29.12	28.81	29.032	4458418.0
2008-05-01 13:00:00	MSFT	Stock	29.032	29.29	28.81	29.2	8302297.0
2008-05-01 13:30:00	MSFT	Stock	29.191	29.21	29.07	29.09	4025615.0
2008-05-01 14:00:00	MSFT	Stock	29.082	29.15	29.01	29.03	4206307.0
2008-05-01 14:30:00	MSFT	Stock	29.02	29.19	29.02	29.15	3564788.0
2008-05-01 15:00:00	MSFT	Stock	29.14	29.19	29.07	29.17	4435943.0
2008-05-01 15:30:00	MSFT	Stock	29.16	29.49	29.09	29.36	13332254.0
2008-05-01 16:00:00	MSFT	Stock	29.361	29.43	28.5	29.38	2794582.0
2008-05-01 16:30:00	MSFT	Stock	29.4	29.42	29.4	29.4	11673.0
2008-05-01 17:00:00	MSFT	Stock	29.39	29.42	29.36	29.4	13338.0
2008-05-01 17:30:00	MSFT	Stock	28.595	29.4	28.595	29.4	53645.0
2008-05-01 18:00:00	MSFT	Stock	29.4	29.42	29.4	29.4	10430.0
2008-05-01 18:30:00	MSFT	Stock	29.41	29.41	29.35	29.36	7950.0
2008-05-01 19:00:00	MSFT	Stock	29.35	29.35	29.29	29.3	4923.0
2008-05-01 19:30:00	MSFT	Stock	29.35	29.35	29.3	29.32	1800.0

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

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