PREVIEW / stock_30min / 2009-06-01

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-06-01.parquet
  size:    1.4 MB
  rows:    73,923
  symbols: 3,347

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-06-01 04:00:00	AAPL	Stock	4.8457	4.8457	4.8457	4.8457	4200.0
2009-06-01 04:30:00	AAPL	Stock	4.8643	4.8643	4.8643	4.8643	2800.0
2009-06-01 06:00:00	AAPL	Stock	4.9018	4.9018	4.9018	4.9018	2800.0
2009-06-01 07:00:00	AAPL	Stock	4.9107	4.9146	4.9075	4.9075	74620.0
2009-06-01 07:30:00	AAPL	Stock	4.9075	4.9075	4.8946	4.9036	59360.0
2009-06-01 08:00:00	AAPL	Stock	4.8357	4.9125	4.8357	4.9071	748076.0
2009-06-01 08:30:00	AAPL	Stock	4.9089	4.9107	4.9018	4.9089	601776.0
2009-06-01 09:00:00	AAPL	Stock	4.9086	4.9111	4.8504	4.8743	5322716.0
2009-06-01 09:30:00	AAPL	Stock	4.8739	4.94	4.8571	4.9243	81472860.0
2009-06-01 10:00:00	AAPL	Stock	4.9243	4.9571	4.9243	4.9511	41853588.0
2009-06-01 10:30:00	AAPL	Stock	4.9504	4.9607	4.9414	4.9568	31578540.0
2009-06-01 11:00:00	AAPL	Stock	4.9568	4.9732	4.9357	4.95	29827924.0
2009-06-01 11:30:00	AAPL	Stock	4.9493	4.9732	4.9482	4.9711	18543756.0
2009-06-01 12:00:00	AAPL	Stock	4.97	4.9811	4.9657	4.9782	15271676.0
2009-06-01 12:30:00	AAPL	Stock	4.9782	4.9954	4.9761	4.9764	28042056.0
2009-06-01 13:00:00	AAPL	Stock	4.9764	4.985	4.9718	4.985	14491092.0
2009-06-01 13:30:00	AAPL	Stock	4.9843	4.9996	4.9696	4.9954	23815568.0
2009-06-01 14:00:00	AAPL	Stock	4.9954	4.9996	4.9882	4.9911	22385300.0
2009-06-01 14:30:00	AAPL	Stock	4.9918	4.9964	4.9846	4.9904	22843800.0
2009-06-01 15:00:00	AAPL	Stock	4.99	4.9918	4.9554	4.9786	44206792.0
2009-06-01 15:30:00	AAPL	Stock	4.9782	4.9893	4.9643	4.9764	56194628.0
2009-06-01 16:00:00	AAPL	Stock	4.9764	4.9857	4.9464	4.9732	9775752.0
2009-06-01 16:30:00	AAPL	Stock	4.975	4.9825	4.8615	4.975	575400.0
2009-06-01 17:00:00	AAPL	Stock	4.9725	4.9729	4.9689	4.9689	137620.0
2009-06-01 17:30:00	AAPL	Stock	4.8504	4.9754	4.8504	4.9729	83804.0
2009-06-01 18:00:00	AAPL	Stock	4.975	4.975	4.9718	4.9718	1770552.0
2009-06-01 18:30:00	AAPL	Stock	4.975	4.9775	4.975	4.9775	45892.0
2009-06-01 19:00:00	AAPL	Stock	4.9768	4.9782	4.9761	4.9782	71848.0
2009-06-01 19:30:00	AAPL	Stock	4.9757	4.9804	4.9757	4.9782	51632.0
2009-06-01 04:00:00	MSFT	Stock	20.91	20.91	20.91	20.91	12000.0
2009-06-01 05:30:00	MSFT	Stock	21.1	21.1	21.1	21.1	2100.0
2009-06-01 06:00:00	MSFT	Stock	21.18	21.24	21.18	21.24	4500.0
2009-06-01 06:30:00	MSFT	Stock	21.18	21.18	21.18	21.18	100.0
2009-06-01 07:00:00	MSFT	Stock	21.1	21.1	21.1	21.1	5000.0
2009-06-01 07:30:00	MSFT	Stock	21.1	21.16	21.08	21.08	1270.0
2009-06-01 08:00:00	MSFT	Stock	21.0	21.12	20.95	21.1	42145.0
2009-06-01 08:30:00	MSFT	Stock	21.1	21.15	21.1	21.15	53525.0
2009-06-01 09:00:00	MSFT	Stock	21.15	21.15	20.89	21.03	311954.0
2009-06-01 09:30:00	MSFT	Stock	21.03	21.22	20.86	21.1	6319654.0
2009-06-01 10:00:00	MSFT	Stock	21.11	21.28	21.11	21.23	4557506.0
2009-06-01 10:30:00	MSFT	Stock	21.23	21.26	21.17	21.2	3033339.0
2009-06-01 11:00:00	MSFT	Stock	21.2	21.25	21.19	21.23	1682016.0
2009-06-01 11:30:00	MSFT	Stock	21.24	21.3	21.2	21.263	2095908.0
2009-06-01 12:00:00	MSFT	Stock	21.26	21.29	21.24	21.28	1706772.0
2009-06-01 12:30:00	MSFT	Stock	21.29	21.37	21.2	21.22	4636680.0
2009-06-01 13:00:00	MSFT	Stock	21.21	21.235	21.12	21.13	3036617.0
2009-06-01 13:30:00	MSFT	Stock	21.13	21.385	21.13	21.365	3008264.0
2009-06-01 14:00:00	MSFT	Stock	21.37	21.44	21.2	21.37	3274301.0
2009-06-01 14:30:00	MSFT	Stock	21.37	21.44	21.32	21.39	2935351.0
2009-06-01 15:00:00	MSFT	Stock	21.392	21.43	21.34	21.4	3666403.0

> showing 50 of 73,923 rows — these rows as CSV

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