PREVIEW / stock_30min / 2007-03-20

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-20.parquet
  size:    1.0 MB
  rows:    55,360
  symbols: 2,548

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
2007-03-20 07:00:00	AAPL	Stock	3.2607	3.2607	3.2607	3.2607	14000.0
2007-03-20 07:30:00	AAPL	Stock	3.255	3.2679	3.255	3.2643	456400.0
2007-03-20 08:00:00	AAPL	Stock	3.2643	3.2643	3.2546	3.2564	1809360.0
2007-03-20 08:30:00	AAPL	Stock	3.2582	3.2636	3.2571	3.2607	1045604.0
2007-03-20 09:00:00	AAPL	Stock	3.2607	3.2632	3.2596	3.2629	1466080.0
2007-03-20 09:30:00	AAPL	Stock	3.2618	3.2736	3.2521	3.2579	91688408.0
2007-03-20 10:00:00	AAPL	Stock	3.2571	3.2729	3.2543	3.2639	43800400.0
2007-03-20 10:30:00	AAPL	Stock	3.2636	3.2679	3.2589	3.2621	35023912.0
2007-03-20 11:00:00	AAPL	Stock	3.2618	3.2675	3.2586	3.2654	26731824.0
2007-03-20 11:30:00	AAPL	Stock	3.2654	3.2768	3.2621	3.2746	41453048.0
2007-03-20 12:00:00	AAPL	Stock	3.2746	3.28	3.2689	3.2707	29359736.0
2007-03-20 12:30:00	AAPL	Stock	3.2707	3.2743	3.2686	3.2697	24178588.0
2007-03-20 13:00:00	AAPL	Stock	3.2696	3.2736	3.2661	3.2689	25839520.0
2007-03-20 13:30:00	AAPL	Stock	3.2689	3.2711	3.2568	3.2607	36930516.0
2007-03-20 14:00:00	AAPL	Stock	3.2607	3.2661	3.26	3.265	25819640.0
2007-03-20 14:30:00	AAPL	Stock	3.2646	3.2754	3.2625	3.2668	27427064.0
2007-03-20 15:00:00	AAPL	Stock	3.2666	3.2732	3.2661	3.2721	24007256.0
2007-03-20 15:30:00	AAPL	Stock	3.2721	3.2764	3.2654	3.2668	41843172.0
2007-03-20 16:00:00	AAPL	Stock	3.2664	3.2739	3.2664	3.2671	2184028.0
2007-03-20 16:30:00	AAPL	Stock	3.2693	3.2714	3.2689	3.2696	117376.0
2007-03-20 17:00:00	AAPL	Stock	3.2711	3.2739	3.2711	3.2739	429240.0
2007-03-20 17:30:00	AAPL	Stock	3.2714	3.2714	3.2693	3.2693	153328.0
2007-03-20 18:00:00	AAPL	Stock	3.2696	3.2711	3.2696	3.2711	68600.0
2007-03-20 18:30:00	AAPL	Stock	3.2711	3.2725	3.2711	3.2725	24920.0
2007-03-20 19:00:00	AAPL	Stock	3.2711	3.2711	3.2707	3.2707	75880.0
2007-03-20 19:30:00	AAPL	Stock	3.2711	3.2714	3.2682	3.2686	63336.0
2007-03-20 07:00:00	MSFT	Stock	27.85	27.85	27.85	27.85	100.0
2007-03-20 07:30:00	MSFT	Stock	27.83	27.83	27.83	27.83	100.0
2007-03-20 08:00:00	MSFT	Stock	27.83	27.85	27.82	27.85	929.0
2007-03-20 08:30:00	MSFT	Stock	27.85	27.92	27.85	27.91	18776.0
2007-03-20 09:00:00	MSFT	Stock	27.9	27.93	27.85	27.92	82426.0
2007-03-20 09:30:00	MSFT	Stock	27.93	27.99	27.76	27.96	6219803.0
2007-03-20 10:00:00	MSFT	Stock	27.97	28.0	27.88	27.95	4345741.0
2007-03-20 10:30:00	MSFT	Stock	27.95	27.97	27.9	27.92	2081331.0
2007-03-20 11:00:00	MSFT	Stock	27.923	28.0	27.88	27.98	1833109.0
2007-03-20 11:30:00	MSFT	Stock	27.98	28.09	27.9	28.08	3269125.0
2007-03-20 12:00:00	MSFT	Stock	28.08	28.16	28.07	28.14	3461762.0
2007-03-20 12:30:00	MSFT	Stock	28.15	28.16	28.01	28.04	2258538.0
2007-03-20 13:00:00	MSFT	Stock	28.04	28.09	28.02	28.03	2589560.0
2007-03-20 13:30:00	MSFT	Stock	28.03	28.08	27.9	27.96	3344336.0
2007-03-20 14:00:00	MSFT	Stock	27.95	28.04	27.95	28.0	2570022.0
2007-03-20 14:30:00	MSFT	Stock	28.0	28.0	27.92	27.95	2488604.0
2007-03-20 15:00:00	MSFT	Stock	27.95	27.96	27.87	27.88	4041490.0
2007-03-20 15:30:00	MSFT	Stock	27.88	27.97	27.82	27.82	6244270.0
2007-03-20 16:00:00	MSFT	Stock	27.82	28.0	27.82	27.84	1132450.0
2007-03-20 17:00:00	MSFT	Stock	27.89	27.9	27.88	27.88	8085.0
2007-03-20 17:30:00	MSFT	Stock	27.92	27.92	27.89	27.9	6100.0
2007-03-20 18:00:00	MSFT	Stock	27.9	27.9	27.89	27.89	2400.0
2007-03-20 18:30:00	MSFT	Stock	27.87	27.95	27.87	27.95	1572.0
2007-03-20 19:30:00	MSFT	Stock	27.9	27.99	27.9	27.99	10220.0

> showing 50 of 55,360 rows — these rows as CSV

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