PREVIEW / stock_30min / 2010-11-02

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-02.parquet
  size:    1.4 MB
  rows:    78,186
  symbols: 3,502

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-11-02 04:00:00	AAPL	Stock	10.8896	10.8896	10.8893	10.8893	8400.0
2010-11-02 04:30:00	AAPL	Stock	10.8929	10.8929	10.8929	10.8929	2800.0
2010-11-02 05:00:00	AAPL	Stock	10.9018	10.9018	10.8964	10.9018	12040.0
2010-11-02 05:30:00	AAPL	Stock	10.9018	10.9018	10.8929	10.8929	11200.0
2010-11-02 06:00:00	AAPL	Stock	10.9007	10.9007	10.9007	10.9007	8400.0
2010-11-02 06:30:00	AAPL	Stock	10.8936	10.9164	10.8893	10.9164	95060.0
2010-11-02 07:00:00	AAPL	Stock	10.9107	10.9121	10.9054	10.9121	93800.0
2010-11-02 07:30:00	AAPL	Stock	10.9186	10.9407	10.9154	10.9346	182896.0
2010-11-02 08:00:00	AAPL	Stock	10.9357	10.9389	10.9154	10.9304	1949668.0
2010-11-02 08:30:00	AAPL	Stock	10.9282	10.9339	10.9179	10.9304	1183000.0
2010-11-02 09:00:00	AAPL	Stock	10.9307	10.9786	10.9304	10.9732	4794944.0
2010-11-02 09:30:00	AAPL	Stock	10.9743	11.0589	10.9643	11.0236	94331692.0
2010-11-02 10:00:00	AAPL	Stock	11.0235	11.0321	11.0036	11.0182	31435880.0
2010-11-02 10:30:00	AAPL	Stock	11.0196	11.0211	10.985	11.0175	26125932.0
2010-11-02 11:00:00	AAPL	Stock	11.0175	11.0268	10.9932	10.9938	16540076.0
2010-11-02 11:30:00	AAPL	Stock	10.994	11.0154	10.9932	11.0143	10470880.0
2010-11-02 12:00:00	AAPL	Stock	11.015	11.0254	11.0089	11.0155	14084140.0
2010-11-02 12:30:00	AAPL	Stock	11.0143	11.0464	11.0129	11.0418	23748508.0
2010-11-02 13:00:00	AAPL	Stock	11.0418	11.0707	11.0411	11.0689	32215624.0
2010-11-02 13:30:00	AAPL	Stock	11.0693	11.0782	11.0593	11.0618	32884964.0
2010-11-02 14:00:00	AAPL	Stock	11.0614	11.0621	11.0261	11.0436	26796952.0
2010-11-02 14:30:00	AAPL	Stock	11.0436	11.0486	11.02	11.0377	18871104.0
2010-11-02 15:00:00	AAPL	Stock	11.0375	11.075	11.0371	11.0561	31414740.0
2010-11-02 15:30:00	AAPL	Stock	11.0557	11.0621	11.0282	11.0607	47616072.0
2010-11-02 16:00:00	AAPL	Stock	11.0593	11.0768	11.0363	11.0661	13172292.0
2010-11-02 16:30:00	AAPL	Stock	11.0675	11.0707	11.0343	11.0679	702240.0
2010-11-02 17:00:00	AAPL	Stock	10.8636	11.0714	10.8636	11.0679	545076.0
2010-11-02 17:30:00	AAPL	Stock	11.0661	11.0711	11.0486	11.0654	385616.0
2010-11-02 18:00:00	AAPL	Stock	11.0675	11.0786	11.0486	11.0786	517160.0
2010-11-02 18:30:00	AAPL	Stock	11.075	11.0821	11.0632	11.0654	577528.0
2010-11-02 19:00:00	AAPL	Stock	11.0714	11.0804	11.0682	11.0804	530712.0
2010-11-02 19:30:00	AAPL	Stock	11.0814	11.1014	11.0771	11.0979	1160908.0
2010-11-02 05:30:00	MSFT	Stock	27.15	27.15	27.15	27.15	100.0
2010-11-02 06:30:00	MSFT	Stock	27.0	27.0	27.0	27.0	1000.0
2010-11-02 07:30:00	MSFT	Stock	27.06	27.11	27.02	27.02	7000.0
2010-11-02 08:00:00	MSFT	Stock	27.07	27.1	26.98	27.06	75878.0
2010-11-02 08:30:00	MSFT	Stock	27.06	27.1	27.06	27.08	10484.0
2010-11-02 09:00:00	MSFT	Stock	27.08	27.09	26.95	27.06	114880.0
2010-11-02 09:30:00	MSFT	Stock	27.05	27.25	27.02	27.18	6548440.0
2010-11-02 10:00:00	MSFT	Stock	27.18	27.21	27.12	27.16	3807799.0
2010-11-02 10:30:00	MSFT	Stock	27.16	27.22	27.12	27.12	3198359.0
2010-11-02 11:00:00	MSFT	Stock	27.12	27.195	27.12	27.155	2372871.0
2010-11-02 11:30:00	MSFT	Stock	27.155	27.19	27.145	27.18	1533056.0
2010-11-02 12:00:00	MSFT	Stock	27.175	27.24	27.17	27.22	2221385.0
2010-11-02 12:30:00	MSFT	Stock	27.225	27.32	27.22	27.3	3499214.0
2010-11-02 13:00:00	MSFT	Stock	27.3	27.35	27.27	27.33	2807241.0
2010-11-02 13:30:00	MSFT	Stock	27.33	27.4	27.28	27.34	4309894.0
2010-11-02 14:00:00	MSFT	Stock	27.349	27.38	27.33	27.355	2077624.0
2010-11-02 14:30:00	MSFT	Stock	27.355	27.385	27.31	27.374	2819301.0
2010-11-02 15:00:00	MSFT	Stock	27.37	27.4	27.34	27.34	3683061.0

> showing 50 of 78,186 rows — these rows as CSV

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